create table PERSON(
Driver_id varchar(10),
Name varchar(20),
Address varchar(20),
primary key(Driver_id));

create table CARRRR(
Reg_no varchar(10),
Model varchar(10),
Year int,
primary key(Reg_no));

create table Accident00(
Report_number int,
Dat date,
Location varchar(20),
primary key(Report_number));

create table Owns(
driver_id varchar(10),
Reg_no varchar(10),
foreign key(driver_id) references Person(driver_id),
foreign key(Reg_no) references CARRRR(Reg_no));

create table Participated(
driver_id varchar(10),
Reg_no varchar(10),
Report_number int,
damage_amount int,
foreign key(driver_id) references Person(driver_id),
foreign key(Reg_no) references CARRRR(Reg_no),
foreign key(Report_number) references Accident00(Report_number));


INSERT INTO PERSON VALUES('DID123','SHASHANK','BENGALURU');
INSERT INTO PERSON VALUES('DID124','SHREYAS S','BENGALURU');
INSERT INTO PERSON VALUES('DID125','SHREYAS A','BENGALURU');
INSERT INTO PERSON VALUES('DID126','SRIVATSA','BENGALURU');
INSERT INTO PERSON VALUES('DID127','SRINIVAS KJ','BENGALURU');


INSERT INTO CARRRR VALUES('A54698','AUDI',2012);
INSERT INTO CARRRR VALUES('5D4656','MERCEDES',2011);
INSERT INTO CARRRR VALUES('5S4687','POLO',2005);
INSERT INTO CARRRR VALUES('H54696','ALTO',2001);
INSERT INTO CARRRR VALUES('R50214','SCORPIO',2010);


INSERT INTO Accident00 VALUES(15,'4-JAN-2012','BENGALURU');
INSERT INTO Accident00 VALUES(16,'5-JAN-2012','CHENNAI');
INSERT INTO Accident00 VALUES(21,'15-JAN-2012','PUNE');
INSERT INTO Accident00 VALUES(25,'16-JAN-2012','MUMBAI');
INSERT INTO Accident00 VALUES(30,'25-JAN-2012','DELHI');


INSERT INTO Owns VALUES('DID123','A54698');
INSERT INTO Owns VALUES('DID124','5D4656');
INSERT INTO Owns VALUES('DID125','5S4687');
INSERT INTO Owns VALUES('DID126','H54696');
INSERT INTO Owns VALUES('DID127','R50214');


INSERT INTO Participated VALUES('DID123','A54698',15,15000);
INSERT INTO Participated VALUES('DID124','5D4656',16,15500);
INSERT INTO Participated VALUES('DID125','5S4687',21,5000);
INSERT INTO Participated VALUES('DID126','H54696',25,4000);
INSERT INTO Participated VALUES('DID127','R50214',30,8000);