dbms_project_InsertData.sql

insert into phoenix_customer values
(101, 'John', 'Pilot', '1943-12-31', 'M', 'Hyderabad', 8937629017, 'johnpilot@comedian.com', 45567834, 'Married', 'AAICA4667N'),
(102, 'Tom', 'Paul', '1961-07-01', 'M', 'Kochi', 9027561813, 'tompaul@actor.com', 45987998, 'Married', 'AACCA8464F'),
(103, 'Ishan', 'Khan', '1973-09-12', 'M', 'California', 9864276532, 'ishan@nbabasketball.com', 23452343, 'Divorced', 'AAACG2755R'),
(104, 'Derik', 'Walker', '1953-12-08', 'M', 'kanchpuram', 9748632798, 'walker@iaf.com', 99085463, 'Single', 'AAACH0632A'),
(105, 'Trisha', 'Srivastava', '1943-02-27', 'F', 'Bangalore', 8927654891, 'trisha@scientist.com', 78650036, 'Married', 'AAACT2786P'),
(106, 'Rishu', 'Kumar', '1977-06-11', 'F', 'Indore', 9830553876, 'rishu@iaf.com', 45290354, 'Single', 'AAACI1223J'),
(107, 'Faiz', 'Iqbal', '1859-05-15', 'M', 'Lucknow', 8926778935, 'iqbal@stunts.com', 56713234, 'Married', 'AAACK4409J'),
(108, 'Sana', 'Dean', '1987-01-16', 'F', 'Yeswanthpur', 6785432890, 'sana@iaf.com', 98076347, 'Married', 'AAACT5558K'),
(109, 'Akshay', 'Sharma', '1933-04-19', 'M', 'Kacheguda', 9834528945, 'sharma@nbabasketball.com', 55783309, 'Single', 'AAAFT1403C'),
(110, 'Greeshma', 'Kelly', '1948-10-16', 'F', 'Jhansi', 9898450910, 'kelly@scientist.com', 22390876, 'Divorced', 'AAACT5568K'),
(111, 'Kriti', 'Curie', '1943-12-31', 'F', 'Mumbai', 7865894599, 'kriticurie@stunts.com', 45337865, 'Married', 'AAGCS9120G'),
(112, 'Jitesh', 'Agrawal', '1917-05-29', 'M', 'Mangalore', 6734900434, 'jitesh@stunts.com', 22170956, 'Married', 'AAACV4791J'),
(113, 'Luna', 'Singh', '1936-06-18', 'F', 'Silchar', 7198992201, 'lunasingh@nbabasketball.com', 66345893, 'Single', 'AADCT6631L'),
(114, 'Gracy', 'Sood', '1897-01-23', 'F', 'Mandi', 6012389455, 'gracysood@iaf.com', 53478934, 'Single', 'AAACU3561B'),
(115, 'Fiza', 'Obama', '1859-05-15', 'F', 'Kottayam', 7834003211, 'obama@iaf.com', 63356876, 'Divorced', 'AADCP9147P');

insert into phoenix_company values
(11, 'DLF Pramerica Insurance Company Limited', '103 JFK Parkway, Short Hills, Millburn, New Jersey', 'https://www.dlfpi.com/',9739215500),
(12, 'IDBI Insurance Company Limited','1st Floor, Atharva Building, Behind Payyade Residency','https://www.idbi.com/',8977109876),
(13, 'Bupa Insurance Group', 'Kiewit Plaza, 3555 Farnam St., Omaha, NE', 'https://www.bupa.com.au/', 8947872827),
(14, 'Reliance Life Insurance Corporation Limited', 'Aviva plc, St Helens, 1 Undershaft, EC3P 3DQ, London', 'https://www.reliancelife.com', 8605475000),
(15, 'PNB Insurance Company Limited', '33 Exhibition Street, Melbourne, VIC 3000 Australia', 'https://www.pnbmetlife.co.in/', 8492145766),
(16, 'American International Group, Inc.', 'The Hartford Financial Services Group, Inc., 690 Asylum Avenue, Hartford, CT', 'https://www.aig.com/', 9685852555),
(17, 'Tata Insurance Company Limited', 'First Floor Hosto Centre, No. 43, Millers Road, Vasanth Nagar', 'https://www.tata.com', 1800786668),
(18, 'Reliance Vehicle Insurance Company Limited', 'Unit No. 701, 702 & 703, 7th Floor, West Wing, Raheja Towers, 26/27 M G Road', 'https://www.reliancelife.com', 1800498592),
(19, 'IDBI Insurance Company Limited', 'Real Tower, Upperhill, Kenya', 'https://www.idbi.com/', 1899983766),
(20, 'Life Insurance Corporation of India Limited', '175, Water Street, New York', 'https://www.lic.com', 1088997755),
(21, 'Aegon Insurance Company Limited', 'SBI Corporate Solutions. 4th Floor, MV Road, Andheri (East)', 'https://www.aegon.com/', 1800678692),
(22, 'Birkshire Hathaway Inc.', 'Tower A, Peninsula Business Park, Senapati Bapat Marg, Lower Parel', 'https://www.berkshirehathaway.com/', 180994288),
(23, 'DP International Vehicle Insurance Limited', 'Reliance Centre, 5th floor, Off Western Express Highway, Santacruz East', 'https://www.dpinternational.com', 1804489999),
(24, 'Bharti AXA General Insurance Company Limited', '2nd Floor, Aditya Trade Center, 7-1-618, Hyderabad', 'https://www.bhartiaxa.com', 2241790000),
(25, 'Bupa Insurance Group', '4th Floor, Commerce Enclave, Financial District, Gachibowli', 'https://www.bupa.com.au/', 1800786668);

insert into phoenix_product values
(101, 11, 50000, 'Zero-dep'),
(102, 12, 65322, 'Comprehensive'),
(103, 11, 6000, 'Third-party'),
(104, 13, 80000, 'Own-damage'),
(105, 14, 96000, 'Theft'),
(106, 12, 50000, 'Comprehensive'),
(107, 12, 5500, 'Full'),
(108, 11, 56000, 'Zero-dep'),
(109, 24, 23000, 'Own-damage'),
(110, 16, 89250, 'Third-party'),
(111, 22, 45666, 'Full'),
(112, 21, 65800, 'Third-party'),
(113, 19, 47800, 'own-damage'),
(114, 15, 45600, 'Comprehensive'),
(115, 20, 35000, 'Theft');

insert into phoenix_department values
(501, 11, 'Vehicle Insurance Division', 'London', 'Tony Montana'),
(502, 12, 'Sales Division', 'Mumbai', 'Dexter Morgan'),
(503, 13, 'Scraping Division', 'Delhi', 'Ajay Gupta'),
(504, 13, 'Inspection department', 'Delhi', 'Anant Mishra'),
(505, 14, 'Sales', 'Bangalore', 'James Howlett'),
(506, 14, 'Legal affairs', 'Pune', 'Conan Stark'),
(507, 12, 'Sales Division', 'Mumbai', 'Rakesh Tripathi'),
(508, 11, 'Inspection Division', 'Delhi', 'Tony Montana'),
(509, 20, 'Legal affairs', 'Pune', 'John Titor'),
(510, 16, 'Scraping Division', 'Mumbai', 'Denis Mir'),
(511, 24, 'Sales Division', 'Noida', 'Scott Ogden'),
(512, 22, 'Inspection Division', 'Delhi', 'Joshua Page'),
(513, 19, 'Legal affairs', 'Bangalore', 'Helmut Marko'),
(514, 20, 'Sales Division', 'Kolkata', 'Tony Rea'),
(515, 17, 'Inspection Division', 'Indore', 'Brad Whatley');

insert into phoenix_nok values
(201, 101, 'Amruth', 'karnataka', 8084658783, 'M', 'married', 'father'),
(202, 102, 'Sonu', 'madhya pradesh', 8352759361, 'F', 'Unmarried', 'sister'),
(203, 103, 'Sanjay', 'karnataka', 8569452361, 'M', 'married', 'wife'),
(204, 104, 'Arrohi Shindey','Himachal pradesh',8569452371,'F', 'Married', 'Mother'),
(205, 105, 'Kanika Arora', 'Assam', 8647912354, 'F', 'Unmarried', 'Daughter'),
(206, 106, 'Kajal Kumar', 'Manipur', 7035489621, 'F', 'Married', 'Wife'),
(207, 107, 'Mandeep Singh', 'Punjab', 6547813059, 'M', 'Married', 'Father'),
(208, 108, 'Jai Kumar', 'J&K', 9458761125, 'M', 'Married', 'Brother'),
(209, 109, 'Umang Rana', 'Maharhastra', 9965713584, 'M', 'Unmarried', 'Brother'),
(210, 110, 'Kavita Joshi', 'Orrisa', 5874123658, 'F', 'Married', 'Wifer'),
(211, 111, 'Anushka Rawat', 'Bihar', 6665874128, 'F', 'Married', 'Sister'),
(212, 112, 'Vishal Jain', 'UP', 7958412572, 'M', 'Unmarried', 'Son'),
(213, 113, 'Parkash Joshi', 'UP', 9855755455, 'M', 'Married', 'Husband'),
(214, 114, 'Monika Goel', 'Haryana', 9257845545, 'F', 'Married', 'Father'),
(215, 115, 'Ruchir Bam', 'Delhi', 8124557878, 'M', 'Married' , 'Husband');

insert into phoenix_vehicle values
(701, 101, 'Toyota', 'A2020', 'sedan', '6789','GU856GF', 'AFGY4567RT','blue', '2004-02-03'),
(702, 102, 'Honda', 'B2020', 'SUV', '1268', 'HDU846A', 'DFGT7894GH','pink', '2003-03-06'),
(703, 103, 'TATA', 'C2020', 'Hatch', '7645', 'SJU367G', 'GHUY6783HI', 'purple','2006-07-12'),
(704, 104, 'TVS', 'D2020', 'motorcycle', '6675', 'IT829TH', 'WERT0953HU', 'black', '2007-05-03'),
(705, 104, 'TVS', 'D2020', 'motorcycle', '0075', 'JT569IP', 'WEET4358FR', 'green', '2005-04-02'),
(706, 107, 'VW', 'D2020', 'SUV', '4075', 'JT569IP', 'WEET4358FR', 'black', '2005-04-02'),
(707, 113, 'Honda', 'D2020', 'sedan', '5656', 'IT829TH', 'WERT0953JU', 'blue', '2007-05-03'),
(708, 110, 'TATA', 'D2020', 'hatch', '5874', 'FRE237D', 'POI7509EW', 'red', '2012-05-03'),
(709, 112, 'Kia', 'D2020', 'SUV', '1245', 'NBVG489F', 'GYR40503S', 'red', '2006-05-03'),
(710, 114, 'Kia', 'D2020', 'Van', '5686', 'PHFG38JD', 'WEOI8990', 'white', '2005-05-03'),
(711, 105, 'Hyundai', 'D2020', 'hatch', '3652', 'INVKH65', 'ERT5677UI', 'grey', '2008-05-03'),
(712, 110, 'Maruti', 'D2020', 'hatch', '7412', 'PIGC24G', 'POIY5647ER', 'white', '2013-05-03'),
(713, 109, 'Hero', 'D2020', 'motorcycle', '0358', 'ZQW25OY', 'HUYE456DE', 'black', '2011-05-03'),
(714, 111, 'Bajaj', 'D2020', 'motorcycle', '4587', 'PI75RGF', 'WERTHTF54', 'green', '2010-05-03'),
(715, 115, 'Mahindra', 'D2020', 'SUV', '0328', 'P009IY6', 'YUTR0953HU', 'blue', '2010-05-03'),
(716, 111, 'Skoda', 'D2020', 'seadn', '4732', 'VGYT896', 'JUTRR53HU', 'white', '2007-05-03'),
(717, 112, 'Nissan', 'D2020', 'SUV', '5680', 'VCEW3432', 'OERT0953UP', 'white', '2012-05-03'),
(718, 115, 'Maruti', 'D2020', 'sedan', '9396', 'KJY47DF', 'HUYT0953HR', 'silver', '2011-05-03'),
(719, 106, 'TATA', 'D2020', 'SUV', '2587', 'DTH137ME', 'KIU0953GYT', 'red', '2009-05-03'),
(720, 108, 'Mahindra', 'D2020', 'SUV', '9875', 'IFMP3N17', 'KIRT0953PI', 'white', '2006-05-03');

insert into phoenix_coverage values
(11, 101, 40100, 'Personal Injury Coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '15 Months'),
(12, 102, 25200, 'Liability Coverage', 'LOW', 'Covers the medical bills of the third party due to hospitalization or medical treatment','3 Months'),
(13, 103, 35000, 'Personal Injury Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '8 Months'),
(14, 104, 10090, 'Uninsured Motorist Protection', 'LOW', 'If your vehicle is hit by another vehicle which is not covered by any insurance policy', '12 Months'),
(15, 105, 55000, 'Expendable coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '18 Months'),
(16, 106, 39000, 'Personal Injury Coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '2 Months'),
(17, 107, 67000, 'Own damage Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '4 Months'),
(18, 108, 78900, 'Third party Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '6 Months'),
(19, 109, 36500, 'Service Coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '8 Months'),
(20, 110, 78000, 'Flood damage Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '12 Months'),
(21, 111, 6500, 'Uninsured motorist Coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '3 Months'),
(22, 112, 168000, 'Liability Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '6 Months'),
(23, 113, 100000, 'Full Coverage', 'HIGH', 'Personal injury protection will cover all the costs associated with the accident', '8 Months'),
(24, 114, 45850, 'Personal Injury Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '12 Months'),
(25, 115, 62350, 'Personal Injury Coverage', 'LOW', 'Personal injury protection will cover all the costs associated with the accident', '4 Months');

insert into phoenix_staff values
(101, 501,'Deepanshu','Sachdeva','Ghaziabad', 7126589754,'M','Unmarried','Indian','B.Tech',125000, 665897),
(102, 502,'Harley','Mcquiene','Hyderabad', 9784632589,'F','Married','Indian','B.Sc',170000, 568947),
(103, 503,'Pranjal','Aggarwal','Varanasi', 9874535698,'M','Unmarried','Indian','B.Tech',200000, 365478),
(104, 504,'Shubham','Sharma','Gwalior', 8974632859,'M','Unmarried','Indian','B.Tech',300000, 698421),
(105, 505,'Nikita','Reddy','Lucknow', 8974536254,'F','Unmarried','Indian','B.Tech',50000, 369857),
(106, 506,'Vinita','Yadav','Hyderabad', 8945623485,'M','Unmarried','Indian','MBA',90000, 321457),
(107, 505, 'Tanu','Reddy','Lucknow', 8866436254,'F','Unmarried','Indian','B.Tech',50000, 356874),
(108, 513, 'Shivai','Reddy','Lucknow', 9887611454,'F','Unmarried','Indian','Ph.D.',50000, 384454),
(109, 511, 'Arjun','Bhat','Delhi', 6825574454,'M','Unmarried','Indian','B.Comm',75000, 354157),
(110, 514, 'Ajay','Mishra','Delhi', 8974687444,'M','Unmarried','Indian','B.Tech',80000, 397787),
(111, 507, 'Paul','Singh','Mumbai', 8055689424,'M','Married','Indian','B.Tech',56800, 369847),
(112, 508, 'Lilly','Agarwal','Pune', 6325478104,'F','Unmarried','Indian','B.Arch',32000, 369357),
(113, 506, 'Amisha','Kumar','Guwahati', 9024578902,'F','Unmarried','Indian','B.Tech',45000, 362857),
(114, 509, 'Jack','Joshi','Hyderabad', 8400230258,'M','Married','Indian','B.Sc',95000, 319857),
(115, 509, 'Anita','Rawal','Nagpur', 7065482138,'F','Unmarried','Indian','B.B.A',59000, 360857),
(116, 501, 'Sameer','Khan','Pune', 6262354807,'M','Married','Indian','B.A.',35000, 369897),
(117, 510, 'Ravi','Khanna','Bangalore', 7061984259,'M','Married','Indian','M.A.',56800, 369887),
(118, 514, 'Shashi','Reddy','Chennai', 7360025589,'F','Unmarried','Indian','B.Tech',38500, 379857),
(119, 502, 'Riya','Reddy','Chennai', 5963147822,'F','Unmarried','Indian','B.Tech',49000, 369856),
(120, 513, 'Liya','Kapoor','Lucknow', 6238899771,'F','Married','Indian','M.Tech',46500, 365857),
(121, 515, 'Manoj','Reddy','Ajmer', 9995023001,'M','Married','Indian','B.Tech',75000, 349857),
(122, 515, 'Reena','Singh','Jaipur', 6498743075,'F','Married','Indian','B.Tech',10000, 339857),
(123, 506, 'Nikhil','Sharma','Kolkata', 9875643115,'M','Unmarried','Indian','B.Tech',20000, 369852),
(124, 509, 'Ram','Tiwari','Agra', 9456187227,'M','Unmarried','Indian','B.Tech',56000, 369851);

insert into phoenix_insurance_policy values
(21, 701, 102, '2020-03-03', '2021-03-03'),
(22, 702, 105, '2020-03-05', '2021-03-05'),
(23, 703, 104, '2020-03-07', '2021-03-07'),
(24, 704, 103, '2020-03-09', '2022-03-09'),
(25, 705, 105, '2020-04-01', '2023-04-01'),
(26, 706, 106, '2020-05-05', '2022-05-05'),
(27, 707, 115, '2020-09-13', '2023-09-13'),
(28, 708, 114, '2021-10-15', '2024-10-15'),
(29, 709, 113, '2020-11-30', '2023-04-01'),
(30, 710, 108, '2021-03-24', '2024-03-24'),
(31, 711, 106, '2020-02-26', '2023-02-26'),
(32, 712, 102, '2020-12-23', '2023-12-23'),
(33, 713, 107, '2021-11-14', '2024-11-14'),
(34, 714, 115, '2020-09-13', '2023-09-13'),
(35, 715, 109, '2021-10-11', '2024-10-11');

insert into phoenix_incident values
(1101, 701, 101, 'Accident','2019-02-18','The car was hit my a bike'),
(1102, 702, 102, 'Damage','2019-04-15','The car crashed itself to a wall while taking reverse'),
(1103, 703, 103, 'Collision','2019-07-25','The car crashed to another moving bike'),
(1104, 705, 104, 'Accident','2019-02-08', 'The car accidentally crashed into truck'),
(1105, 703, 103, 'Windshield','2020-01-08', 'A ball hit the windshield leading to crack'),
(1106, 706, 119, 'Accident','2019-02-08', 'Rear end collision'),
(1107, 717, 108, 'Accident','2018-07-21', 'Tyre burst'),
(1108, 711, 107, 'Flood damage','2021-02-18', 'Water ingress'),
(1109, 716, 118, 'Accident','2022-05-30', 'The car turned over at high speed'),
(1110, 709, 113, 'Accident','2019-06-08', 'The car fell into a gorge');

insert into phoenix_premium_payment values
(301, 21, 20001, '2022-04-08', 'done'),
(302, 22, 24016, '2022-04-11', 'pending'),
(303, 23, 1600, '2022-04-14', 'pending'),
(304, 24, 29804, '2022-04-16', 'done'),
(305, 26, 21400, '2022-04-18', 'pending'),
(306, 21, 25862, '2022-04-21', 'done'),
(307, 25, 20897, '2022-04-23', 'pending'),
(308, 35, 1778, '2022-04-30', 'done'),
(309, 32, 30000, '2022-03-11', 'done'),
(310, 24, 11200, '2022-04-26', 'pending'),
(311, 30, 5900, '2022-04-27', 'pending'),
(312, 29, 6500, '2022-04-28', 'done'),
(313, 33, 7500, '2022-03-19', 'done'),
(314, 27, 9000, '2022-04-16', 'pending'),
(315, 34, 10258, '2022-04-05', 'done');

insert into phoenix_receipt values
(1,301, 20001),
(2,304, 29804),
(3,306, 25862),
(4,308, 1778),
(5,309, 30000),
(6,312, 6500),
(7,313, 7500),
(8,315, 10258);

insert into phoenix_claim values
(230, 21, 28000.0, 'bumper damage', '2021-03-21', 'pending'),
(231, 22, 23000.0, 'engine damage', '2021-11-11', 'approved'),
(232, 23, 45000.0, 'bent frames', '2022-03-07', 'approved'),
(233, 24, 9685.0, 'glass damage', '2022-01-17', 'pending'),
(234, 25, 56800.0, 'theft', '2022-03-07', 'approved'),
(235, 21, 54780.0, 'dent', '2021-04-30', 'approved'),
(236, 28, 66302.0, 'engine failure', '2021-07-22', 'approved'),
(237, 35, 450000.0, 'battery failure', '2021-07-14', 'pending'),
(238, 32, 324444.0, 'body damage', '2021-10-15', 'approved'),
(239, 30, 10578.0, 'bent frames', '2021-11-20', 'pending'),
(240, 29, 98752.0, 'glass damage', '2022-03-01', 'approved'),
(241, 26, 69158.0, 'tire failure', '2022-03-23', 'approved'),
(242, 21, 73492.0, 'gearbox failure', '2021-06-20', 'pending'),
(243, 34, 87944.0, 'bent frames', '2021-09-19', 'approved'),
(244, 31, 45000.0, 'bent frames', '2021-11-29', 'approved');

insert into phoenix_claim_payment values 
(111, 231, '2021-03-21', 28000.0 ),
(112, 232, '2021-11-11', 23000.0 ),
(113, 234, '2022-03-07', 45000.0 ),
(114, 235, '2022-01-17', 9685.0 ),
(115, 236, '2021-12-16', 8794.34),
(116, 238, '2021-01-17', 10562.0 ),
(117, 240, '2021-05-02', 96025.0 ),
(118, 241, '2021-11-06', 98711.0 ),
(119, 243, '2021-10-25', 42366.0 ),
(120, 244, '2021-01-21', 3258.0 );

insert into phoenix_application values
(1, 711, 102, 111, 'pending'),
(2, 702, 101, 112, 'approved'),
(3, 705, 103, 116, 'pending'),
(4, 703, 104, 109, 'pending'),
(5, 717, 104, 108, 'approved'),
(6, 719, 105, 107, 'pending'),
(7, 718, 115, 102, 'approved'),
(8, 706, 111, 104, 'pending'),
(9, 704, 114, 105, 'approved'),
(10, 701, 110, 106, 'pending');