((( I Need Assignment 2 And 3 Only ))) Car Insurance Assignment #1 ·        Create tables based on the below given relational model.  ·        Define your own data type to the attributes and apply your own constraints to the attributes  ·        Identify the primary, foreign keys apply it to the attributes. ·        Populate the data in all the tables using SQL commands/queries. Car insurance tables: person (driver-id, name, address) car (license, year, model) accident (report-number, date, location) participated(driver-id, license, report-number, damage-amount) ------------------------------------------------- ------------------------------------------------- Assignment #2 Function: ·        Create a function which accepts driver id and display the total number of accidents. Sample output is: The total number of accidents are: 20 Procedure Write a Procedure that accepts driver id and list the damaged amount, date and location.  Package ·        Create a package which contains the above created procedure in the specification. ·        Create package body of the above given procedure. And finally call the procedure created above by passing the driver id then display the output as shown below: Sample Output:   Driver id is: D1020 Accident Date is: 22-Dec-2018 Location is: Muscat Damaged Amount is: 200 Omani Riyal Assignment #3 ·        Create a row level trigger which insert a tuple into the accident_audit (driver-id, license, report-number, damage-amount, name) table whenever a record is added to the participated table.  ·        Draw an ERD diagram for the above tables with appropriate entities, attributes, constraints, participants, relationships using any online tool such as draw.io

 ((( I Need Assignment 2 And 3 Only ))) Car Insurance Assignment #1 ·        Create tables based on the below given relational model.  ·        Define your own data type to the attributes and apply your own constraints to the attributes  ·        Identify the primary, foreign keys apply it to the attributes. ·        Populate the data in all the tables using SQL commands/queries. Car insurance tables: person (driver-id, name, address) car (license, year, model) accident (report-number, date, location) participated(driver-id, license, report-number, damage-amount) ------------------------------------------------- ------------------------------------------------- Assignment #2 Function: ·        Create a function which accepts driver id and display the total number of accidents. Sample output is: The total number of accidents are: 20 Procedure Write a Procedure that accepts driver id and list the damaged amount, date and location.  Package ·        Create a package which contains the above created procedure in the specification. ·        Create package body of the above given procedure. And finally call the procedure created above by passing the driver id then display the output as shown below: Sample Output:   Driver id is: D1020 Accident Date is: 22-Dec-2018 Location is: Muscat Damaged Amount is: 200 Omani Riyal Assignment #3 ·        Create a row level trigger which insert a tuple into the accident_audit (driver-id, license, report-number, damage-amount, name) table whenever a record is added to the participated table.  ·        Draw an ERD diagram for the above tables with appropriate entities, attributes, constraints, participants, relationships using any online tool such as draw.io