((( 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

((( 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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions