-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathFinal_Insertions.sql
More file actions
582 lines (479 loc) · 49.6 KB
/
Final_Insertions.sql
File metadata and controls
582 lines (479 loc) · 49.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
INSERT INTO T11_INCIDENT VALUES('101','Accident','1990-08-19','Accident by the party uintentionally');
INSERT INTO T11_INCIDENT VALUES('102','Property Damage','1990-08-19','Damage to the Vehicle by 3rd party');
INSERT INTO T11_INCIDENT VALUES('103','Personal accident','1990-08-19','The damage done to the vehicle is covered 50%');
INSERT INTO T11_INCIDENT VALUES('104','Earthquake','1990-08-19','100% of the damage done in case of Earthquake is covered by the company.');
INSERT INTO T11_INCIDENT VALUES('105','Cyclone','1990-08-19',"Any serious damage to the engine or exterior of the vehicle will be insured");
INSERT INTO T11_INCIDENT VALUES('106','Criminal Accident','1990-08-19',"Crimes including Theft, in hate damage or breaking due to anger is covered completely by Insurance company");
INSERT INTO T11_INCIDENT VALUES('107','Riots','1990-08-19', 'Any damage done to the vehicle by the people involved in riots will be covered 50% by the company');
INSERT INTO T11_INCIDENT VALUES('108','Engine overheating','1990-08-19', 'Overheating of the engine , in this the company is not liable to pay any amount');
INSERT INTO T11_INCIDENT VALUES('109','Landslide','1990-08-19','Any domage done to the vehicle in a land slide that occured unanimously is covered fully by the company.');
INSERT INTO T11_INCIDENT VALUES('110','Overspeeding','1990-08-19','Company is not liable to pay any amount in case of overspeeding by the driver of the vehicle');
INSERT INTO T11_INCIDENT VALUES('111','Fire','1990-08-19','If the fire is caused by some natural or by accident by a third party then only the insurance company is liable to pay.');
INSERT INTO T11_INCIDENT VALUES('112','Damage by 3rd party','1990-08-19','In case there is a conclusion that there is a conspiracy by the third party and the owner then no insurance will be covered , otherwise 100% is covered.');
INSERT INTO T11_INCIDENT VALUES('113','Animal attack','1990-08-19', '100% coverage by the company.');
INSERT INTO T11_INCIDENT VALUES('114','Engine Failure','1990-08-19','Overhead cost and the installation charges are covered by the company.');
INSERT INTO T11_INCIDENT VALUES('115','Collision','1990-08-19','light damages such as the damages to the hood or tire or windshield will be fully recoverable.');
INSERT INTO T11_INCIDENT VALUES('116','Injury of 3rd party','1990-08-19','Injury to the 3rd party if involves anyone other than the owner will not be recoverable.');
INSERT INTO T11_INCIDENT VALUES('117','Rust','1990-08-19','25% recoverable by the company.');
INSERT INTO T11_INCIDENT VALUES('118','Seizure of Engine','1990-08-19','If the engine is previously repaired by some 3rd party other than the show room then it will not be recovered.');
INSERT INTO T11_INCIDENT VALUES('119', 'Overheating','1990-08-19','100% recoverable.');
INSERT INTO T11_INCIDENT VALUES('120','Short circuit','1990-08-19','Any coverage cost for the repair will be insured by the company.');
-- SELECT * FROM T11_INCIDENT;
INSERT INTO T11_CUSTOMER VALUES (201, 'Paul', 'Walker', '1973-09-12', 'M', 'California', 8937629017, 'paulwalker@actor.com', 33694855, 'Married', 40 );
INSERT INTO T11_CUSTOMER VALUES (202, 'Jaspal', 'Bhatti','1955-03-03' ,'M','Amritsar', 6710947824 , 'jaspalbhatti@comedian.com', 7922033,'Married', 57);
INSERT INTO T11_CUSTOMER VALUES (203, 'Lady', 'Diana Spencer','1961-07-01' , 'F','Sandringham', 1111111111 ,'princessidana@wales.com', 125580, 'Divorced ', 36 );
INSERT INTO T11_CUSTOMER VALUES (204, 'Drazen', 'Petrovic','1964-10-22' ,'M', 'Croatia', 9178456927, 'drazen@nbabasketball.com', 49105443, 'Single', 28);
INSERT INTO T11_CUSTOMER VALUES (205, 'James', 'Dean','1931-02-08' ,'M','Indiana', 7826501975 , 'jamesdean@actor.com', 5468084, 'Single', 24);
INSERT INTO T11_CUSTOMER VALUES (206, 'John Fitzgerald', 'Kennedy','1917-05-29' ,'M', 'Brookline', 9825908717 , 'jfk@uspresident.com', 095084, 'Married', 46);
INSERT INTO T11_CUSTOMER VALUES (207, 'Sam', 'Kinison','1953-12-08' ,'M','Washington', 9027561813 , 'sam@comedian.com', 7721945, 'Divorced', 38);
INSERT INTO T11_CUSTOMER VALUES (208, 'Sonu', 'Sood','1973-07-30' ,'M','Moga', 9748632798, 'sonusood@actor.com', 354070, 'Married', 41);
INSERT INTO T11_CUSTOMER VALUES (209, 'Barack', 'Obama Sr.','1936-06-18 ','M','Kenya ', 9864276532, 'seniorobama@econimist.com', 8892341, 'Married', 46);
INSERT INTO T11_CUSTOMER VALUES (210, 'John', 'Denver','1943-12-31' ,'M','New Mexico', 8816354290 ,'johndenver@singer.com', 7321879, 'Divorced', 53);
INSERT INTO T11_CUSTOMER VALUES (211, 'Subhash Chandra', 'Bose','1897-01-23' ,'M','Cuttac', 8973526754, 'scbose@freedomfighter.com', 1897385, 'Married', 48);
INSERT INTO T11_CUSTOMER VALUES (212, 'Kalika Prasad', 'Bhattacharya','1970-09-11' ,'M', 'Silchar', 8927675517 ,'kpbhattacharya@folksinger.com', 782563, 'Divorced', 46);
INSERT INTO T11_CUSTOMER VALUES (213, 'Ryan', 'Dunn','1977-06-11 ','M','Ohio', 8927654891, 'dunn@stunts.com', 892764, 'Single', 34);
INSERT INTO T11_CUSTOMER VALUES (214, 'Pierre', 'Curie','1859-05-15' ,'M', 'Paris', 9830553876, 'curie@scientist.com', 765432, 'Married', 46);
INSERT INTO T11_CUSTOMER VALUES (215, 'Hema', 'Malini','1948-10-16' ,'F', 'Tamil Nadu', 8926778935 ,'hemamalini@actress.com', 897643, 'Married', 72);
INSERT INTO T11_CUSTOMER VALUES (216, 'Grace', 'Kelly','1929-11-12' ,'F','Pennsylvania', 79217654897, 'kelly@actress.com', 873078, 'Married', 52);
INSERT INTO T11_CUSTOMER VALUES (217, 'Sana', 'Iqbal','1987-01-16' ,'F','Hyderabad', 7908887689 ,'sana@biker.com', 7896736, 'Single', 30);
INSERT INTO T11_CUSTOMER VALUES (218, 'Sunil', 'Grover','1977-08-03' ,'M','Mandi', 8765997647, 'sunilgrover@actor.com', 683757, 'Married', 37);
INSERT INTO T11_CUSTOMER VALUES (219, 'Rajesh', 'Pilot', '1945-02-10', 'M', 'Ghaziabad', 789875783, 'rajesh@iaf.com', 672867, 'Married', 55);
INSERT INTO T11_CUSTOMER VALUES (220, 'Jayne', 'Mansfield','1933-04-19', 'F', 'Pennsylvania', 8975889764, 'jayne@actress.com', 768388, 'Married', 34);
-- SELECT * FROM T11_CUSTOMER;
-- table 3
INSERT INTO T11_INCIDENT_REPORT VALUES('301','Fire','Deepanshu Sachdeva', '1990-08-19', 560000,'Severe fire caused due to accident, damage 90%','111',201);
INSERT INTO T11_INCIDENT_REPORT VALUES('302','Cyclone',' Vinita Yadav', '1990-08-19', 890000,'Severe damage of about 85% dur to Cyclone Aila','105',203);
INSERT INTO T11_INCIDENT_REPORT VALUES('303','Accident','Pranjal Aggarwal', '1990-08-19',12000000,'Damage of about 50% caused due to head in collision','101',203);
INSERT INTO T11_INCIDENT_REPORT VALUES('304','Animal Attack','Shubham Sharma', '1990-08-19', 1850980,'Wild animal attack at the rear of the vehicle, damage 30%','113',204);
INSERT INTO T11_INCIDENT_REPORT VALUES('305','Corrosion','Jagrut Nemade', '1990-08-19',450000,'Vehicle Damaged due to heavy corrosion','117',205);
INSERT INTO T11_INCIDENT_REPORT VALUES('306','Riots','Kshitiz Michael', '1990-08-19', 3400500,'Vehicle flipped over and damaged during the Cambridge Riot','107',206);
INSERT INTO T11_INCIDENT_REPORT VALUES('307','Drunken Driving','Kalin Sharma', '1990-08-19',76000,'Light damage to the vehicle caused due to collision with a drunk driver vehicle','103',207);
INSERT INTO T11_INCIDENT_REPORT VALUES('308','Engine Overheating','Bitoo Bhaiya', '1990-08-19',45000,'Engine overheating caused due to parking in extreme sunlight','108',208);
INSERT INTO T11_INCIDENT_REPORT VALUES('309','Property Damage','Aditya Katoch', '1990-08-19',765000,'Vehicle damaged during demolition work','102',209);
INSERT INTO T11_INCIDENT_REPORT VALUES('310','Engine Overheating','Rajeevni Suryavanshi', '1990-08-19',980400,'Fuel Tank explosion due to overheating, damage 100%','108',210);
INSERT INTO T11_INCIDENT_REPORT VALUES('311','Collision','Rakesh Kumar', '1990-08-19',8790050,'Damage due to head on collision with electricity pole, full frontal damage','115',211);
INSERT INTO T11_INCIDENT_REPORT VALUES('312','Earthquake','Rahul Raghav', '1990-08-19',875000,'Vehicle buried under debris due to earthquake, damage 60%','104',212);
INSERT INTO T11_INCIDENT_REPORT VALUES('313','Damage Caused Due to 3rd Party','Naman Kant', '1990-08-19',8798400,'Vehicle damaged during fight among two people','112',213);
INSERT INTO T11_INCIDENT_REPORT VALUES('314','Engine Failure','Nayan Kant', '1990-08-19',6574500,'Vehicle damaged due to engine failure while driving, collision with vehicle coming from behind','114',214);
INSERT INTO T11_INCIDENT_REPORT VALUES('315','Landslide','Avinash Singh', '1990-08-19',84900,'Vehicle slipped through the valley, during landslides','109',215);
INSERT INTO T11_INCIDENT_REPORT VALUES('316','Overspeeding','Aman Yadav', '1990-08-19',12098500,'Partial Damage due to collision while overspeeding','110',216);
INSERT INTO T11_INCIDENT_REPORT VALUES('317','Criminal Activity','Akshay Kumar', '1990-08-19',8795000,'Car stolen and damaged during a robbery','106',217);
INSERT INTO T11_INCIDENT_REPORT VALUES('318','Short Circuit','Lakshya Chatrapati', '1990-08-19',6574500,'Damage due to short circuit, damage 65%','120',218);
INSERT INTO T11_INCIDENT_REPORT VALUES('319','Seizure of Engine','Akarsh Maurya', '1990-08-19',5794000,'Unpredicted engine seizure, damage 45%','118',219);
INSERT INTO T11_INCIDENT_REPORT VALUES('320','Fire','Mithil Anchan', '1990-08-19',5500000,'Damage due to car set on fire, damage 85%','111',220);
-- SELECT * FROM T11_INCIDENT_REPORT;
-- table 4
INSERT INTO T11_INSURANCE_COMPANY VALUES('Dun & Bradstreet Private Limited','103 JFK Parkway, Short Hills, Millburn, New Jersey', 9739215500, 08977109876, 'receivablequestions@dnb.com', 'https://www.dnb.com/','USA','Dun & Bradstree Vehicle Insurance Division', 'Dun & Bradstree Insurance');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Reliance Life Insurance Corporation Limited','1st Floor, Atharva Building, Behind Payyade Residency, Off Mira Bhayander Road, Mira Road - East, Mumbai, Thane district', 022-28555240, 1800872555,'rnlife.customerservice@relianceada.com', 'https://www.reliancenipponlife.com/','Mumbai ','Reliance Vehicle Insurance Division','Reliance Life Insurance');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Bupa Insurance Group','33 Exhibition Street, Melbourne, VIC 3000 Australia', 8947872827, 1800767628, 'info@bupa.com.au', 'https://www.bupa.com.au/', 'Australia', 'Bupa Vehicle Division', 'Bupa Insurance Company');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Aviva Insurance Company Limited','Aviva plc, St Helens, 1 Undershaft, EC3P 3DQ, London', 1800897388, NULL, 'contact@aviva.co.uk', 'https://www.aviva,co.uk', 'United Kingdom', 'Aviva Vehicles Inusrance', 'Aviva Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Birkshire Hathaway Inc.','Kiewit Plaza, 3555 Farnam St., Omaha, NE', 4023461400, NULL,'berkshire@berkshirehathaway.com', 'https://www.berkshirehathaway.com/', 'Nebraska', 'BH Vehicles','BH Insurance');
INSERT INTO T11_INSURANCE_COMPANY VALUES('The Hartford Financial Services Group, Inc.','The Hartford Financial Services Group, Inc., 690 Asylum Avenue, Hartford, CT', 8605475000, 08492145766, 'insurances@thehartford.com','https://www.thehartfors.com/','United States','Hartford Vehicles Division','The Hartford');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Bharti AXA General Insurance Company Limited', 'First Floor Hosto Centre, No. 43, Millers Road, Vasanth Nagar', 1800975658,9685852555,'contact@bhartiaxa.com', 'https://www.bhartiaxa.com', 'Banglore', 'Bharti Vehicles','Bharti Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('PNB Insurance Company Limited','Unit No. 701, 702 & 703, 7th Floor, West Wing, Raheja Towers, 26/27 M G Road', 1800786668, 02241790000, 'indiaservice@pnbmetlife.co.in','https://www.pnbmetlife.co.in/', 'Mumbai','PNB Vehicles Division','PNB Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('AAR Insurance, Kenya','Real Tower, Upperhill, Kenya', 18006757383, NULL, 'info@aar.co.ke', 'https://www.aar.co.ke', 'Nairobi', 'AAR Veh Ins', 'AAR Insurance Solutions');
INSERT INTO T11_INSURANCE_COMPANY VALUES('American International Group, Inc.', '175, Water Street, New York', 1800498592, 0236645788,'info@aig.com', 'https://www.aig.com/', 'New York','AIG Vehicle Solutions', 'AIG Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('SBI Insurance Company Limited', 'SBI Corporate Solutions. 4th Floor, MV Road, Andheri (East)', 1899983766, NULL, 'info@sbiinsurance.com', 'https://www.sbiinsurance.com/', 'Mumbai', 'SBI Vehicle Solutions', 'SBI Insurance Company');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Tata Insurance Company Limited', 'Tower A, Peninsula Business Park, Senapati Bapat Marg, Lower Parel', 1088997755, 0234888829,'info@tata.com', 'https://www.tata.com', 'Mumbai', 'Tata Vehicle Insurances','Tata Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Reliance Vehicle Insurance Company Limited','Reliance Centre, 5th floor, Off Western Express Highway, Santacruz East', 1899007777, NULL, 'info@reliancelife.com','https://www.reliancelife.com', 'Mumbai','Reliance Vehicles','Reliance Solutions');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Aegon Insurance Company Limited','2nd Floor, Aditya Trade Center, 7-1-618, Hyderabad', 1800977678, NULL, 'help@aegon.com','https://www.aegon.com/', 'Hyderabad','Aegon Vehicle Solutions','Aegon Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Sharma Insurance Company Limited','4th Floor, Commerce Enclave, Financial District, Gachibowli', 1800976749, NULL, 'info@sharmainsurances.com','https://www.shramainsurances.com', 'Hyderabad','Sharma Insurances','Sharma Solutions');
INSERT INTO T11_INSURANCE_COMPANY VALUES('DP International Vehicle Insurance Limited','3rd Floor, RajMandir Bhavan, Begumpet', 1800678692, NULL, 'info@dpinternational.com', 'https://www.dpinternational.com', 'Kolkata','DP Vehicle Insurance','DP Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('DLF Pramerica Insurance Company Limited','5th floor, Bezzola Complex Ltd., Sion Trombay Road,', 18000784677, NULL, 'info@dlfpi.com','https://www.dlfpi.com/', 'Sion','DLF Vehicle Division', 'DLF Insurances');
INSERT INTO T11_INSURANCE_COMPANY VALUES('IDBI Insurance Company Limited','Office Building Near Narayanaguda Flyover, Hyderabad, Telangana', 1866798288, NULL,'contact@idbi.com', 'https://www.idbi.com/', 'Hyderabad','IDBI Vehicles Division','IDBI Insurace Office');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Vehicles Association of India','5th Floor, VAI Complex, Industrial Estate, Mumbai', 18099489288, 028887927,'info@vai.com','https://www.vai.com','Mumbai','VAI Vehicles','VAI Solutions');
INSERT INTO T11_INSURANCE_COMPANY VALUES('Life Insurance Corporation of India Limited','3rd Floor, BSE Building, New Okhla Industrial Development Authority', 1804489999, NULL, 'info@lic.com','https://www.lic.com', 'Noida','LIC Vehicle Insurance','LIC Office');
-- SELECT * FROM T11_INSURANCE_COMPANY;
-- table 5
INSERT INTO T11_DEPARTMENT VALUES
('Dun & Bradstree Vehicle Insurance Division', '501', 'Kendra Castillo' ,'Dun & Bradstreet Private Limited','Dun & Bradstreet Private Limited'),
('Reliance Vehicle Insurance Division', '502', 'Elana Tyson', 'Reliance Life Insurance Corporation Limited','Reliance Life Insurance Corporation Limited'),
('Bupa Vehicle Division', '503', 'Hawa Ferrell', 'Bupa Insurance Group','Bupa Insurance Group'),
('Aviva Vehicles Inusrance', '504', 'Addie Estes', 'Aviva Insurance Company Limited','Aviva Insurance Company Limited'),
('BH Vehicles', '505', 'Pranav Gupta', 'Birkshire Hathaway Inc.','Birkshire Hathaway Inc.'),
('Hartford Vehicles Division', '506', 'Cinar Ratcliffe', 'The Hartford Financial Services Group','The Hartford Financial Services Group, Inc.'),
('Bharti Vehicles', '507', 'Elara Doyle','Bharti AXA General Insurance Company Limited','Bharti AXA General Insurance Company Limited'),
('PNB Vehicles Division', '508', 'Christine Smith', 'PNB Insurance Company Limited','PNB Insurance Company Limited'),
('AAR Veh Ins', '509', 'Benas Vinson', 'AAR Insurance, Kenya','AAR Insurance, Kenya'),
('AIG Vehicle Solutions', '510', 'Anabella Dickson','American International Group, Inc.','American International Group, Inc.'),
('SBI Vehicle Solutions', '511', 'Arnav Singh', 'SBI Insurance Company Limited','SBI Insurance Company Limited'),
('Tata Vehicle Insurances', '512', 'Sharon Lyon', 'Tata Insurance Company Limited','Tata Insurance Company Limited'),
('Reliance Vehicles', '513', 'Malikah Frederick', 'Reliance Vehicle Insurance Company Limited','Reliance Vehicle Insurance Company Limited'),
('Aegon Vehicle Solutions', '514', 'Connah Knight', 'Aegon Insurance Company Limited','Aegon Insurance Company Limited'),
('Sharma Insurances', '515', 'Jagoda Copeland', 'Sharma Insurance Company Limited','Sharma Insurance Company Limited'),
('DP Vehicle Insurance', '516', 'Kylo Vang', 'DP International Vehicle Insurance Limited','DP International Vehicle Insurance Limited'),
('DLF Vehicle Division', '517', 'Kobi Stott', 'DLF Pramerica Insurance Company Limited','DLF Pramerica Insurance Company Limited'),
('IDBI Vehicles Division', '518', 'Naseem Coleman', 'IDBI Insurance Company Limited','IDBI Insurance Company Limited'),
('VAI Vehicles', '519', 'Angelo Kouma', 'Vehicles Association of India','Vehicles Association of India'),
('LIC Vehicle Insurance', '520', 'Jo Schultz', 'Life Insurance Corporation of India Limited','Life Insurance Corporation of India Limited'),
('Dun & Bradstree Vehicle Insurance Division2', '501', 'Kendra Castillo' ,'Dun & Bradstreet Private Limited','Dun & Bradstreet Private Limited');
-- SELECT * FROM T11_DEPARTMENT;
-- table 6
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Reliance Vehicle Insurance Division','AB','Valencia','9933786475','Kendra Castillo','part-specific-service', 'Reliance Life Insurance Corporation Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Hartford Vehicles Division','CD','Shahkot','8977476654', 'Cinar Ratcliffe','full-service','The Hartford Financial Services Group, Inc.');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Bharti Vehicles','EF','Paris','9088997266','Elara Doyle','minor-service', 'Bharti AXA General Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('SBI Vehicle Solutions','GH','Germany','9083686266','Arnav Singh','part-specific-service', 'SBI Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Reliance Vehicles','IJ','California','9098287767', 'Malikah Frederick','full-service', 'Reliance Vehicle Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('PNB Vehicles Division','KL','Dallas','9093874666','Christine Smith','half-service', 'PNB Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Bupa Vehicle Division','MN','California','9093874666', 'Hawa Ferrell','full-major-service', 'Bupa Insurance Group');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Dun & Bradstree Vehicle Insurance Division','OP','Mumbai','9090938888', 'Kendra Castillo','half-service','Dun & Bradstreet Private Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Aviva Vehicles Inusrance','QR','Nairobi','8902667477','Addie Estes','partial-service', 'Aviva Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('DLF Vehicle Division','ST','California','8978889978','Kobi Stott','full-service', 'DLF Pramerica Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('IDBI Vehicles Division','UV','Taiwan','9093875995','Naseem Coleman','partial-service','IDBI Insurance Company Limited');
-- INSERT INTO T11_VEHICLE_SERVICE VALUES ('IDBI Vehicles Division','WX','Hooghly','9094978577','Angelo Kouma','minor-service', 'Vehicles Association of India');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Tata Vehicle Insurances','YZ','Pennsylvania','9095999954','Sharon Lyon','major-service', 'Tata Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('AAR Veh Ins','AA','Paris', '9094877758','Benas Vinson','full-service', 'AAR Insurance, Kenya');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('AIG Vehicle Solutions','BB','Mumbai','9093875766', 'Anabella Dickson','half-service', 'American International Group, Inc.');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Aegon Vehicle Solutions','CC','Monaco','9093875893', 'Connah Knight', 'part-specific-service', 'Aegon Insurance Company Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('DP Vehicle Insurance','DD','Hyderabad','9080949898','Kylo Vang', 'full-service', 'DP International Vehicle Insurance Limited');
INSERT INTO T11_VEHICLE_SERVICE VALUES ('Sharma Insurances','EE','Lousiana','8989488849', 'Jagoda Copeland','minor-service', 'Sharma Insurance Company Limited');
-- SELECT * FROM T11_VEHICLE_SERVICE;
INSERT INTO T11_VEHICLE VALUES
('101', '1101', 'UP 11 MZ 8709', 302002, 'Car', 20, 6, 'Corolla', 454545, 858585, 652, 'A2020', 202),
('102', '1102', 'UP 14 AM 8222', 50000, 'Bike', 10, 2, 'Honda', 654556, 858586, 856, 'B2020', 203),
('103', '1103', 'HR 04 KT 8975', 20000, 'Bike', 8, 2, 'Tata', 854545, 65857, 362, 'C2020', 202),
('104', '1104', 'KX 45 JG 8754', 100000, 'Truck', 40, 2, 'Mahindra', 954545, 968585, 123, 'D2020', 204),
('105', '1105', 'UP 14 GS 5729', 600000, 'Car', 23, 4, 'Hyundai', 104545, 63524, 124, 'E2020', 205),
('106', '1106', 'MH 25 OF 4587', 52300, 'Bike', 11, 2, 'Corolla', 114545, 09645, 125, 'F2020', 206),
('107', '1107', 'HR 56 GH 4568', 800000, 'Car', 25, 4, 'Tata', 124545, 123561, 126, 'G2020', 207),
('108', '1108', 'TD 21 LK 8976', 456220, 'Car', 24, 4, 'Mahindra', 134545, 74864, 127, 'H2020', 204),
('109', '1109', 'MH 23 DC 7412', 40000, 'Bike', 10, 2, 'TVS', 144545, 12345, 128, 'I2020', 202),
('110', '1110', 'PB 89 CD 1234', 60000, 'Bike', 10, 2, 'BAJAJ', 154545, 54321, 129, 'J2020', 208),
('111', '1111', 'HP 14 KL 5678', 2000000, 'Truck', 35, 2, 'TATA', 164545, 12534, 223, 'K2020', 203),
('112', '1112', 'AP 53 HG 7777', 55000, 'Bike', 9, 2, 'Honda', 174545, 56325, 224, 'L2020', 209),
('113', '1113', 'KA 74 LM 5698', 450000, 'Car', 22, 6, 'Mahindra', 184545, 32561, 225, 'M2020', 210),
('114', '1114', 'KA 35 MN 6325', 6500000, 'Car', 21, 4, 'Corolla', 194545, 63522, 226, 'N2020', 211),
('115', '1115', 'UP 96 PQ 7845', 563300, 'Car', 20, 4, 'Hyundai', 204545, 23652, 227, 'O2020', 212);
-- SELECT * FROM T11_VEHICLE;
-- Table-8
INSERT INTO T11_PREMIUM_PAYMENT VALUES
('1001', '78901', 10000, '2021-11-22', '901', 201),
('1002', '78902', 100000, '2022-09-12', '902', 202),
('1003', '78903', 3256, '2021-06-30', '903', 203),
('1004', '78904', 10, '2022-10-16', '904', 204),
('1005', '78905', 6598, '2022-02-21', '905', 205),
('1006', '78906', 7000, '2022-03-19', '906', 206),
('1007', '78907', 8000, '2020-04-15', '907', 207),
('1008', '78908', 9031, '2020-05-29', '908', 208),
('1009', '78909', 1235, '2017-09-12', '909', 209),
('1010', '78910', 9696, '2020-07-09', '910', 210),
('1011', '78911', 3500, '2020-10-07', '911', 211),
('1012', '78912', 4500, '2020-11-01', '912', 212),
('1013', '78913', 5000, '2019-03-03', '913', 213),
('1014', '78914', 6000, '2020-10-05', '914', 214),
('1015', '78915', 7500, '2018-03-29', '915', 215),
('1016', '78916', 9900, '2020-04-22', '916', 216),
('1017', '78917', 10000, '2020-10-11', '917', 217),
('1018', '78918', 1000, '2019-10-12', '918', 218),
('1019', '78919', 6666, '2019-06-14', '919', 219),
('1020', '78920', 9450, '2020-05-23', '920', 220);
-- SELECT * FROM T11_PREMIUM_PAYMENT;
-- Table-9
INSERT INTO T11_RECEIPT VALUES
('901', '2020-11-22', 1000, '1001', 201),
('902', '2019-09-12', 2000, '1002', 202),
('903', '2020-06-30', 3256, '1003', 203),
('904', '2018-10-16', 235, '1004', 204),
('905', '2019-02-21', 6598, '1005', 205),
('906', '2020-03-19', 7000, '1006', 206),
('907', '2020-04-15', 8000, '1007', 207),
('908', '2020-05-29', 9031, '1008', 208),
('909', '2017-09-12', 1235, '1009', 209),
('910', '2020-07-09', 9696, '1010', 210),
('911', '2020-10-07', 3500, '1011', 211),
('912', '2020-11-01', 4500, '1012', 212),
('913', '2019-03-03', 5000, '1013', 213),
('914', '2020-10-05', 6000, '1014', 214),
('915', '2018-03-29', 7500, '1015', 215),
('916', '2020-04-22', 9900, '1016', 216),
('917', '2020-10-11', 10000, '1017', 217),
('918', '2019-10-12', 1000, '1018', 218),
('919', '2019-06-14', 6666, '1019', 219),
('920', '2020-05-23', 9450, '1020', 220);
-- SELECT * FROM T11_RECEIPT;
-- Table-10
INSERT INTO T11_APPLICATION VALUES
('701', '801', 'Accepted', 'Collision Coverage', 201),
('702', '802', 'Pending', 'Personal Injury Coverage', 202),
('703', '803', 'Rejected', 'Uninsured Motorist Coverage', 203),
('704', '804', 'Accepted', 'Comprehensive Coverage', 204),
('705', '805', 'Pending', 'Liability Coverage', 205),
('706', '806', 'Pending', 'Bodily Injury Liability Coverage', 206),
('707', '807', 'Accepted', 'Liability Coverage', 207),
('708', '808', 'Accepted', 'Comprehensive Coverage', 208),
('709', '809', 'Pending', 'Personal Injury Coverage', 209),
('710', '810', 'Accepted', 'Personal Injury Coverage', 210),
('711', '811', 'Accepted', 'Collision Coverage', 211),
('712', '812', 'Pending', 'Liability Coverage', 212),
('713', '813', 'Pending', 'Bodily Injury Liability Coverage', 213),
('714', '814', 'Accepted', 'Personal Injury Coverage', 214),
('715', '815', 'Rejected', 'Liability Coverage', 215),
('716', '816', 'Accepted', 'Collision Coverage', 216),
('717', '817', 'Pending', 'Comprehensive Coverage', 217),
('718', '818', 'Rejected', 'Personal Injury Coverage', 218),
('719', '819', 'Pending', 'Bodily Injury Liability Coverage', 219),
('720', '820', 'Rejected', 'Personal Injury Coverage', 220);
-- SELECT * FROM T11_APPLICATION;
-- Table-11
INSERT INTO T11_INSURANCE_POLICY VALUES
('601','Dun & Bradstree Vehicle Insurance Division' ,'78901','2016-11-22', '2026-07-30', 'Covers the damage or loss to the insured vehicle along with 3rd party liability for property damage, injury or death.','701' ,201),
('602','Reliance Vehicle Insurance Division' ,'78902','2015-12-23', '2022-12-31', 'This coverage pays for any damage to 3rd party property, vehicle, or person. This cover does not benefit the car owner in any way.','702' ,202),
('603','Bupa Vehicle Division' ,'78903','2019-02-24', '2027-10-25', 'Coverage includes an explosion, fire, lightning, earthquake, riot, landslide, terrorist activity, and much more.','703' ,203),
('604','Aviva Vehicles Inusrance' ,'78904','2020-01-08', '2028-01-23', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','704' ,204),
('605','BH Vehicles' ,'78905','2018-02-07', '2022-05-09', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same is 70% of the expenses, market value of vehicle if stolen.','705' ,205),
('606','The Hartford Financial Services Group, Inc.' ,'78906','2010-03-06', '2021-06-07', 'Covers the damage or loss to the insured vehicle along with 3rd party liability for property damage, injury or death.','706' ,206),
('607','Bharti Vehicles' ,'78907','2012-05-05', '2021-04-11', 'Coverage includes an explosion, fire, lightning, earthquake, riot, landslide, terrorist activity, and much more.','707' ,207),
('608','PNB Vehicles Division' ,'78908','2013-07-15', '2023-05-13', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','708' ,208),
('609','AAR Veh Ins' ,'78909','2014-08-08', '2024-07-14', 'Covers the damage or loss to the insured vehicle along with 3rd party liability for property damage, injury or death.','709' ,209),
('610','AIG Vehicle Solutions' ,'78910','2015-06-13', '2030-11-17', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','710' ,210),
('611','SBI Vehicle Solutions' ,'78911','2019-09-09', '2031-03-15', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','711' ,211),
('612','Tata Vehicle Insurances' ,'78912','2020-10-29', '2027-02-22', 'Coverage includes an explosion, fire, lightning, earthquake, riot, landslide, terrorist activity, and much more.','712' ,212),
('613','Reliance Vehicles' ,'78913','2018-11-30', '2023-09-21', 'This coverage pays for any damage to 3rd party property, vehicle, or person. This cover does not benefit the car owner in any way.','713' ,213),
('614','Aegon Vehicle Solutions' ,'78914','2016-06-02', '2020-10-27', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same is 70% of the expenses, market value of vehicle if stolen.','714' ,214),
('615','Sharma Insurances' ,'78915','2009-04-03', '2024-12-01', 'Coverage includes an explosion, fire, lightning, earthquake, riot, landslide, terrorist activity, and much more.','715' ,215),
('616','DP Vehicle Insurance' ,'78916','2008-02-08', '2026-11-02', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','716' ,216),
('617','DLF Vehicle Division' ,'78917','2014-12-06', '2028-10-29', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same.','717' ,217),
('618','IDBI Vehicles Division' ,'78918','2017-04-01', '2025-02-08', 'Covers the damage or loss to the insured vehicle along with 3rd party liability for property damage, injury or death.','718' ,218),
('619','VAI Vehicles' ,'78919','2019-03-24', '2022-02-04', 'This coverage pays for any damage to 3rd party property, vehicle, or person. This cover does not benefit the car owner in any way.','719' ,219),
('620','LIC Vehicle Insurance' ,'78920','2020-05-25', '2024-01-08', 'In case if you do not file any claim throughout the period of the insurance, you receive a bonus for the same is 70% of the expenses, market value of vehicle if stolen.','720' ,220);
-- SELECT * FROM T11_INSURANCE_POLICY;
-- Table-12
INSERT INTO T11_POLICY_RENEWABLE VALUES
('201','2025-11-11', 'Offline', '601','701' ,201),
('202','2026-07-30', 'Online', '602','702' ,202),
('203','2022-12-31', 'Online', '603','703' ,203),
('204','2027-10-25', 'Online', '604','704' ,204),
('205','2028-01-23', 'Offline', '605','705' ,205),
('206','2022-05-09', 'Offline', '606','706' ,206),
('207','2021-06-07', 'Online', '607','707' ,207),
('208','2021-04-11', 'Online', '608','708' ,208),
('209','2023-05-13', 'Offline', '609','709' ,209),
('210','2024-07-14', 'Online', '610','710' ,210),
('211','2030-11-17', 'Offline', '611','711' ,211),
('212','2031-03-15', 'Online', '612','712' ,212),
('213','2027-02-22', 'Online', '613','713' ,213),
('214','2023-09-21', 'Offline', '614','714' ,214),
('215','2020-10-27', 'Offline', '615','715' ,215),
('216','2024-12-01', 'Offline', '616','716' ,216),
('217','2026-11-02', 'Online', '617','717' ,217),
('218','2028-10-29', 'Online', '618','718' ,218),
('219','2022-02-04', 'Online', '619','719' ,219),
('220','2024-01-08', 'Offline', '620','720' ,220);
-- SELECT * FROM T11_POLICY_RENEWABLE;
-- Table-13
INSERT INTO T11_MEMBERSHIP VALUES
('301', 'LMBNG1245600', '9658615469', 202),
('302', 'LMBNG1245601', '9874589898', 203),
('303', 'LMBNG1245602', '9856315478', 204),
('304', 'LMBNG1245603', '7584898987', 205),
('305', 'LMBNG1245604', '6547898745', 206),
('306', 'LMBNG1245605', '9874114789', 207),
('307', 'LMBNG1245606', '6547887456', 208),
('308', 'LMBNG1245607', '8741214785', 209),
('309', 'LMBNG1245608', '8963236985', 210),
('310', 'LMBNG1245609', '8585874747', 211),
('311', 'LMBNG1245610', '9696985748', 212),
('312', 'LMBNG1245611', '8574365987', 213),
('313', 'LMBNG1245612', '9654785236', 214),
('314', 'LMBNG1245613', '9685123647', 215),
('315', 'LMBNG1245614', '9654785236', 216),
('316', 'LMBNG1245615', '3698745632', 217),
('317', 'LMBNG1245616', '9658745632', 218),
('318', 'LMBNG1245617', '9654774569', 219),
('319', 'LMBNG1245618', '9658412365', 220),
('320', 'LMBNG1245619', '6987458963', 201);
-- SELECT * FROM T11_MEMBERSHIP;
-- Table-14
INSERT INTO T11_QUOTE VALUES
('401', '2016-11-22', '2016-11-22', '2026-07-30', 'Honda Civic', 'KLMA2564', '12666', '701', 201),
('402', '2015-12-23', '2015-12-23', '2022-12-31', 'Buggati Veyron', 'KLMA6589', '23666', '702', 202),
('403', '2019-02-24', '2019-02-24', '2027-10-25', 'Honda City', 'KLMA2365', '69555', '703', 203),
('404', '2020-01-08', '2020-01-08', '2028-01-23', 'McLaren V5', 'KLMA9874', '70000', '704', 204),
('405', '2018-02-07', '2018-02-07', '2022-05-09', 'Chevrolet Cruze', 'KLMA2365', '666000', '705', 205),
('406', '2010-03-06', '2010-03-06', '2021-06-07', 'Activa 5G', 'KLMA6655', '69585', '706', 206),
('407', '2012-05-05', '2012-05-05', '2021-04-11', 'Chevrolet Covette', 'KLMA5641', '12000', '707', 207),
('408', '2013-07-15', '2013-07-15', '2023-05-13', 'McLaren Senna', 'KLMA3322', '99663', '708', 208),
('409', '2014-08-08', '2014-08-08', '2024-07-14', 'Aston Martin Vanquish', 'KLMA6699', '20000', '709', 209),
('410', '2015-06-13', '2015-06-13', '2030-11-17', 'Volkswagen Beetle', 'KLMA6325', '200000', '710', 210),
('411', '2019-09-09', '2019-09-09', '2031-03-15', 'Ford Raptor', 'KLMA4586', '63000', '711', 211),
('412', '2020-10-29', '2020-10-29', '2027-02-22', 'Triumph SpitFire', 'KLMA3625', '360000', '712', 212),
('413', '2018-11-30', '2018-11-30', '2023-09-21', 'AMC Gremlin', 'KLMA2525', '990000', '713', 213),
('414', '2016-06-02', '2016-06-02', '2020-10-27', 'Bentley Mulsanne', 'KLMA2222', '330000', '714', 214),
('415', '2009-04-03', '2009-04-03', '2024-12-01', 'Ford Thunderbird', 'KLMA3636', '690000', '715', 215),
('416', '2008-02-08', '2008-02-08', '2026-11-02', 'Porsche Carrera', 'KLMA2658', '100000', '716', 216),
('417', '2014-12-06', '2014-12-06', '2028-10-29', 'Dodge Viper', 'KLMA2659', '100000', '717', 217),
('418', '2017-04-01', '2017-04-01', '2025-02-08', 'Ferrari Testarossa', 'KLMA6984', '3600000', '718', 218),
('419', '2019-03-24', '2019-03-24', '2022-02-04', 'Rolls-Royce Silver Cloud', 'KLMA2569', '30000', '719', 219),
('420', '2020-05-25', '2020-05-25', '2024-01-08', 'Ford Mustang', 'KLMA6698', '101000', '720', 220);
-- SELECT * FROM T11_QUOTE;
-- Table-15
INSERT INTO T11_STAFF VALUES
('501','Deepanshu','Sachdeva','Ghaziabad',7126589754,'M','Unmarried','Indian','B.Tech',125000, 665897, 'Dun & Bradstreet Private Limited' ),
('502','Harley','Mcquiene','Hyderabad',9784632589,'F','Married','Indian','B.Sc',170000, 568947, 'Reliance Life Insurance Corporation Limited' ),
('503','Pranjal','Aggarwal','Varanasi',9874535698,'M','Unmarried','Indian','B.Tech',200000, 365478, 'Bupa Insurance Group' ),
('504','Shubham','Sharma','Gwalior',8974632859,'M','Unmarried','Indian','B.Tech',300000, 698421, 'Aviva Insurance Company Limited' ),
('505','Nikita','Reddy','Lucknow',8974536254,'F','Unmarried','Indian','B.Tech',50000, 369857, 'Birkshire Hathaway Inc.' ),
('506','Vinita','Yadav','Hyderabad',8945623485,'F','Unmarried','Indian','MBA',90000, 321457, 'The Hartford Financial Services Group, Inc.' ),
('507','Arjun','Gupta','Delhi',8974536589,'M','Unmarried','Indian','B.Tech',658000, 321123, 'Bharti AXA General Insurance Company Limited' ),
('508','Raksha','Saxena','Bhopal',5647896325,'F','Married','Indian','BCom',456000, 987789, 'PNB Insurance Company Limited' ),
('509','Rohan','Jain','Indore',8974569354,'M','Married','Indian','B.Tech',985000, 369852, 'AAR Insurance, Kenya' ),
('510','Tauheed','Ahmed','Srinagar',8974652389,'M','Unmarried','Indian','B.Tech',23000, 123854, 'American International Group, Inc.' ),
('511','Rohit','Maheshwari','Ludhiana',9635478512,'M','Married','Indian','BCom',990000, 369159, 'SBI Insurance Company Limited' ),
('512','Vikas','Singh','Mumbai',6578963245,'M','Married','Indian','B.Tech',569800, 987412, 'Tata Insurance Company Limited' ),
('513','Raghav','Jain','Patna',8974563287,'M','Unmarried','Indian','B.Sc',695000, 366221, 'Reliance Vehicle Insurance Company Limited' ),
('514','Kaustub','Rawat','Mirzapur',8974563287,'F','Married','Indian','B.Tech',50000, 125698, 'Aegon Insurance Company Limited' ),
('515','Malay','Sharma','Ghaziabad',8974562375,'M','Married','Indian','B.Com',70000, 363363, 'Sharma Insurance Company Limited' ),
('516','Kratika','Parashar','Pune',8974563874,'M','Married','Indian','B.Tech',690000, 984562,'DP International Vehicle Insurance Limited' ),
('517','Sameer','Verma','Gangtok',9874563285,'M','Unmarried','Indian','B.Tech',658000, 321111, 'DLF Pramerica Insurance Company Limited' ),
('518','Hritika','Sharma','Chennai',8974563278,'F','Married','Indian','MBA',63000, 156987, 'IDBI Insurance Company Limited' ),
('519','Sonalika','Bhide','Pune',8974563874,'F','Married','Indian','MBA',650000, 235694, 'Vehicles Association of India' ),
('520','Ayush','Khanna','Hubballi',9857463248,'M','Married','Indian','B.Tech',56000, 123123, 'Life Insurance Corporation of India Limited' );
-- SELECT * FROM T11_STAFF;
INSERT INTO T11_PRODUCT values
(500000, 'Car','101' ,'Dun & Bradstreet Private Limited'),
(65322, 'Bike','102' ,'Dun & Bradstreet Private Limited'),
(1000000, 'Truck','103' ,'Dun & Bradstreet Private Limited'),
(800000, 'Car','101' ,'Reliance Life Insurance Corporation Limited'),
(9600000, 'Car','101' ,'The Hartford Financial Services Group, Inc.'),
('50000', 'Bike','102' ,'Bharti AXA General Insurance Company Limited'),
('350000', 'Car','101' ,'AAR Insurance, Kenya'),
('42000', 'Bike', '102' ,'American International Group, Inc.'),
('30000', 'Bike', '102' ,'SBI Insurance Company Limited'),
('100000', 'Truck', '103' ,'Tata Insurance Company Limited'),
('96000', 'Bike', '102' ,'Reliance Life Insurance Corporation Limited'),
('22000', 'Bike', '102' ,'Aegon Insurance Company Limited'),
('1200000', 'Car', '101' ,'Sharma Insurance Company Limited'),
('3200000', 'Truck', '103' ,'DP International Vehicle Insurance Limited'),
('6600000', 'Car', '101' ,'DLF Pramerica Insurance Company Limited'),
('35000', 'Bike', '102' ,'IDBI Insurance Company Limited'),
('360000', 'Car', '101' ,'Vehicles Association of India'),
('520000', 'Car', '101' ,'Life Insurance Corporation of India Limited');
-- SELECT * FROM T11_PRODUCT;
INSERT INTO T11_NOK VALUES
('101','Deepanshu Sachdeva','Uttar Pradesh','999663552','Male', 'Married','601' ,'702' ,201),
('102','Pranjal Aggarwal','Andhra Pradesh','9253641112','Male', 'Single','602' ,'702' ,202),
('103','Arrohi Shindey','Himachal pradesh','8569452361','Female', 'Married','603' ,'703' ,203),
('104','Vinita Yadav','Uttarakhand','9632584113','Female', 'Married','604' ,'704' ,203),
('105','Shubham Sharma','Madhya Pradesh','7459632145','Male', 'Single','605' ,'705' ,203),
('106','Virat Kohli','Hyderabad','6569658475','Male', 'Married','606' ,'706' ,204),
('107','Rajeev kumar','Banglore','8456974125','Male', 'Single','607' ,'706' ,205),
('108','Rakesh Roshan','Kolkata','8569745896','Male', 'Divorced','608' ,'706' ,206),
('109','Babu Bhaiya','Jaipur','9685741256','Male', 'Divorced','609' ,'706' ,207),
('110','Rajeev Aggarwal','Mussorie','7458963256','Male', 'Single','607' ,'707' ,210),
('111','Shilpa Shetty','Mysore','9658632569','Female', 'Married','608' ,'710' ,211),
('112','Arvind Kumar','Hyderabad','9685741256','Male', 'Divorced','609' ,'710' ,212),
('113','Riya Sharma','Banglore','8536952145','Female', 'Single','610' ,'711' ,213),
('114','Simran Sachdeva','Himachal Pradesh','8542369685','Female', 'Married','612' ,'711' ,214),
('115','Divyanshi Lal','Kolkata','6352968574','Female', 'Single','612' ,'712' ,215),
('116','Tannu Mehta','Ghaziabad','7425369854','Male', 'Divorced','612' ,'713' ,213),
('117','Sonu Yadav','Meerut','7456985632','Male', 'Married','615' ,'713' ,214),
('118','Hitesh Chauhan','Hyderabad','8569632541','Male', 'Single','614' ,'715' ,213);
-- SELECT * FROM T11_NOK;
INSERT INTO T11_OFFICE VALUES
('Central Perk', 'Bimad Ranar', '1212121212', 'Beirut', '1205000','201', 'Dun & Bradstree Vehicle Insurance Division','Dun & Bradstreet Private Limited'),
('VIP Lane', 'Taimur', '2323232323', 'Dehradun', '5300000','202','Reliance Vehicle Insurance Division', 'Reliance Life Insurance Corporation Limited'),
('CentralPerk', 'Rai Chand', '5858585858', 'Bangalore', '6600000','203', 'Bupa Vehicle Division','Bupa Insurance Group'),
('Gandhi Marg', 'Tej Bahadur', '3131311333', 'Dehradun', '95060000','204','Aviva Vehicles Inusrance','Aviva Insurance Company Limited'),
('Central', 'Danni', '4747474747', 'Beirut', '1600000','205', 'BH Vehicles', 'Birkshire Hathaway Inc.'),
('KM Office', 'Danzzongpa', '3245678541', 'Beirut', '10099000','206', 'Hartford Vehicles Division','The Hartford Financial Services Group, Inc.'),
('SR marg', 'Rawat', '8769543211', 'Raichur', '1800000','207', 'Bharti Vehicles','Bharti AXA General Insurance Company Limited'),
('OP chaudhary', 'KR Bhatt', '2341675897', 'Dehradun', '61900000','208', 'PNB Vehicles Division', 'PNB Insurance Company Limited'),
('Taj', 'Kotwal', '9876987652', 'Raichur', '1100000','209', 'AAR Veh Ins', 'AAR Insurance, Kenya'),
('Perk', 'Uma shankar', '4356273891', 'Delhi', '10008000','210', 'AIG Vehicle Solutions','American International Group, Inc.'),
('Centrol', 'Sherry Y', '678781155', 'Raichur', '7770000','211', 'SBI Vehicle Solutions','SBI Insurance Company Limited'),
('Hatti', 'Phulwa', '98483356733', 'Lucknow', '1340000','212', 'Tata Vehicle Insurances','Tata Insurance Company Limited'),
('Swoosh', 'Reena Devi', '8900678456', 'Beirut', '1780000','213', 'Reliance Vehicles','Reliance Vehicle Insurance Company Limited'),
('CCD', 'Phoebe', '5678904357', 'Capetown', '560000','214', 'Aegon Vehicle Solutions','Aegon Insurance Company Limited'),
('KFC', 'Margaret', '9090887766', 'Bangalore', '150000','215', 'Sharma Insurances','Aegon Insurance Company Limited'),
('Express', 'Hitler', '142543678', 'Hyderbad', '1870000','216', 'DP Vehicle Insurance', 'DP International Vehicle Insurance Limited'),
('TeaState', 'Kim Jong Yun', '7117171717', 'Dehradun', '1540000','217', 'DLF Vehicle Division', 'DLF Pramerica Insurance Company Limited'),
('ChaiShai', 'Ashton', '8484884484', 'Capetown', '1670000','218', 'IDBI Vehicles Division','IDBI Insurance Company Limited'),
('RK puram', 'Jaya', '9801111111', 'Delhi', '1900000','219','VAI Vehicles', 'Vehicles Association of India'),
('Moti bagh', 'Bahaduri', '6666000222', 'Beirut', '850000','220', 'LIC Vehicle Insurance','Life Insurance Corporation of India Limited'),
('Bakshi', 'B Birla', '6666000222', 'Dehradun', '150000','220', 'IDBI Vehicles Division','IDBI Insurance Company Limited');
-- ('Talab', 'B Birla', '6666000222', 'Pune', '185678','20', 'Audit Department','Future Generali India Insurance'),
-- ('MK gandhi', 'Mk gandhi', '6666000222', 'Dehradun', '8850000','51520', 'Legal Department','Geico'),
-- ('Nehru Marg', 'Satyam', '6666000222', 'Dehradun', '1850000','51520', 'Audit Department','Geico');
-- SELECT * FROM T11_OFFICE;
INSERT INTO T11_COVERAGE VALUES
('1301', '4010000', 'Personal Injury Coverage', 'HIGH', 'SUV1201', 'Personal injury protection will cover all the costs associated with the accident', '1 Year', 'Dun & Bradstreet Private Limited'),
('1302', '2520000', 'Liability Coverage', 'HIGH', 'SUV1202', 'Covers the medical bills of the third party due to hospitalization or medical treatment', '8 Months', 'Reliance Life Insurance Corporation Limited'),
('1303', '350000', 'Personal Injury Coverage', 'LOW', '1203', 'Personal injury protection will cover all the costs associated with the accident', '8 Months', 'Bupa Insurance Group'),
('1304', '409000', 'Personal Injury Coverage', 'LOW', 'TS1204', 'Personal injury protection will cover all the costs associated with the accident', '2 Years', 'Aviva Insurance Company Limited'),
('1305', '180000', 'Liability Coverage', 'MEDIUM', 'TRYU1205', 'Covers the medical bills of the third party due to hospitalization or medical treatment', '8 Months', 'Birkshire Hathaway Inc.'),
('1306', '660000', 'Personal Injury Coverage', 'HIGH', 'SUV1206', 'Personal injury protection will cover all the costs associated with the accident', '13 Months', 'Aviva Insurance Company Limited'),
('1307', '970000', 'Collision Coverage', 'MEDIUM', 'TSC1207', 'the insurance company will bear your car repair expenses after the accident.', '18 Months', 'Birkshire Hathaway Inc.'),
('1308', '800000', 'Liability Coverage', 'MEDIUM', 'TRS1208', 'Covers the medical bills of the third party due to hospitalization or medical treatment', '15 Months', 'Birkshire Hathaway Inc.'),
('1309', '190000', 'Personal Injury Coverage', 'LOW', 'TFGH1209', 'Personal injury protection will cover all the costs associated with the accident', '5 Months', 'Aviva Insurance Company Limited'),
('1310', '150000', 'Comprehensive Coverage', 'LOW', 'YUHG1210', 'The comprehensive policy will cover various aspects which are outside the purview of the collision of the vehicle.', '8 Months', 'Birkshire Hathaway Inc.'),
('1311', '987000', 'Uninsured Motorist Protection', 'MEDIUM', 'SUV1211', 'If your vehicle is hit by another vehicle which is not covered by any insurance policy', '1 Year', 'Aviva Insurance Company Limited'),
('1312', '231000', 'Collision Coverage', 'MEDIUM', 'SUV1212', 'the insurance company will bear your car repair expenses after the accident.', '1 Months', 'Birkshire Hathaway Inc.'),
('1313', '553000', 'Personal Injury Coverage', 'HIGH', 'SUV1213', 'Personal injury protection will cover all the costs associated with the accident', '3 Years', 'Birkshire Hathaway Inc.'),
('1314', '700500', 'Personal Injury Coverage', 'MEDIUM', 'NX1214', 'Personal injury protection will cover all the costs associated with the accident', '1 Year', 'Aviva Insurance Company Limited'),
('1315', '659000', 'Liability Coverage', 'MEDIUM', 'NX1215', 'Covers the medical bills of the third party due to hospitalization or medical treatment', '18 Months', 'Aviva Insurance Company Limited'),
('1316', '504000', 'Comprehensive Coverage', 'LOW', 'NX1216', 'The comprehensive policy will cover various aspects which are outside the purview of the collision of the vehicle.', '8 Months', 'Birkshire Hathaway Inc.'),
('1317', '777000', 'Liability Coverage', 'LOW', 'LA1217', 'Covers the medical bills of the third party due to hospitalization or medical treatment', '8 Months', 'Aviva Insurance Company Limited'),
('1318', '111000', 'Collision Coverage', 'HIGH', 'TSV1218', 'the insurance company will bear your car repair expenses after the accident.', '15 Months', 'Birkshire Hathaway Inc.'),
('1319', '999000', 'Personal Injury Coverage', 'LOW', 'SUV1219', 'Personal injury protection will cover all the costs associated with the accident', '1 Year', 'Birkshire Hathaway Inc.'),
('1320', '1009000', 'Uninsured Motorist Protection', 'LOW', 'SUV1220', 'If your vehicle is hit by another vehicle which is not covered by any insurance policy', '1 Year', 'Birkshire Hathaway Inc.');
-- SELECT * FROM T11_COVERAGE;
#11_INSURANCE_POLICY_COVERAGE
INSERT INTO T11_INSURANCE_POLICY_COVERAGE VALUES
-- ( '601','701', '201',1311,"Dun & Bradstreet Private Limited" );
( '601','701', 201,1301,"Reliance Life Insurance Corporation Limited"),
( '602','702', 202,1307,"Bupa Insurance Group"),
( '603','703', 203,1320,"Aviva Insurance Company Limited"),
( '604','704', 204,1316,"Birkshire Hathaway Inc."),
( '605','705', 205,1310,"Aviva Insurance Company Limited"),
( '606','707', 207,1312,"Birkshire Hathaway Inc."),
( '607','708', 208,1314,"Birkshire Hathaway Inc."),
( '608','709', 209,1317,"Aviva Insurance Company Limited"),
( '609','710', 210,1318,"Birkshire Hathaway Inc."),
( '610','711', 211,1319,"Aviva Insurance Company Limited"),
( '611','711', 211,1306,"Aviva Insurance Company Limited"),
( '612','712', 212,1308,"Birkshire Hathaway Inc."),
( '613','714', 214,1301,"Birkshire Hathaway Inc."),
( '614','714', 214,1302,"Aviva Insurance Company Limited"),
( '615','715', 215,1304,"Aviva Insurance Company Limited"),
( '616','716', 216,1315,"Birkshire Hathaway Inc."),
('617' ,'717', 217,1305,"Birkshire Hathaway Inc."),
( '618','717', 217,1313,"Birkshire Hathaway Inc.");
-- SELECT * FROM T11_INSURANCE_POLICY_COVERAGE;
INSERT INTO T11_CLAIM VALUES
('1401','601' ,'650000','50101' ,'Windshield damage','1979-12-20','Approved',202),
('1402','602' ,'400000','50102' ,'Animal collisions','1999-02-27','Approved',204),
('1403', '603','2000','50103' ,'Accident','1983-01-12','Approved',208),
('1404', '604','180000','50104' ,'Windshield damage','2019-02-23','Rejected',212),
('1405', '605','185000', '50105','Vandalism','1986-08-10','Approved',214),
('1406', '606','270000','50106' ,'Animal collision','2024-08-23','Pending',217),
('1407', '607','1255000','50107' ,'Accident','2005-10-04','Pending',219),
('1408','608' ,'400500','50101' ,'Windshield damage','1990-01-10','Rejected',202),
('1409','609' ,'270000','50102' ,'Animal collisions','1989-11-27','Rejected',204),
('1410', '610','50000','50103' ,'Accident','1990-06-13','Approved',208),
('1411', '611','65000000','50104' ,'Windshield damage','2018-09-19','Approved',205),
('1412', '612','1200000', '50105','Vandalism','2001-02-05','Approved',214),
('1413', '613','270000','50106' ,'Animal collision','2024-08-20','Pending',216),
('1414', '614','197800','50107' ,'Accident','2002-10-15','Pending',219),
('1415', '615','450000', '50105','Vandalism','2019-03-09','Approved',214),
('1416', '616','108000','50106' ,'Animal collision','1989-01-09','Approved',216),
('1417', '617','450000','50107' ,'Accident','2019-12-19','Rejected',219),
('1418', '618','4005500', '50105','Vandalism','2010-02-11','Rejecetd',214);
-- ('1419', '619','270000','50106' ,'Animal collision','2024-08-23','Rejected','50216'),
-- ('1420', '620','350000','50107' ,'Accident','2010-04-12','Rejected','50219');
-- SELECT * FROM T11_CLAIM;
INSERT INTO T11_CLAIM_SETTLEMENT VALUES
('1501','108','1980-12-23','650000', '1301', '1401', 204),
('1502','105','1983-05-02','200500', '1302', '1403',208),
('1503','102','1987-08-10','185000', '1313', '1405',214),
('1504','114','1989-04-29','108000', '1304', '1416',219),
('1505','119','1990-10-25','400500', '1315', '1408',202),
('1506','116','1990-09-17','270000', '13014', '1409',204),
('1507','113','1990-11-30','50000', '1307', '1410',208),
('1508','102','1999-07-09','400000', '1308', '1402',214),
('1509','111','2004-11-03','197800', '1309', '1414',219),
('1510','113','2004-02-18','1200000', '1310', '1412',214),
('1511','107','2005-11-24','1255000', '1311', '1407',219),
('1512','120','2010-08-01','4005500', '1312', '1418',214),
('1513','117','2011-04-12','350000', '1305', '1418',219),
('1514','111','2019-09-09','65000000', '1320', '1411', 202);
-- SELECT * FROM T11_CLAIM_SETTLEMENT;