1) Using Oracle DBMS, create tables that represent your schema.

2) Make sure to represent the primary keys/Foreign Keys relationships in your DB

3) Insert few records in each table.

4) Write a select statement that finds rent operations done by customer "Ahmad"

5) Write a select statement that finds who rented the car with number 1 since the car was brought

to agency.

6) Write a select statement that finds all accidents and damages occurred on car number 1 by

customer 8

Part ((1)) : The entities: insuranc, accident, car, customer Explorer rent operation (Ins-No amount) type (report-Ng location date Insurance accident Fnap I name M have home (check Icar rent Costomer year (CNO) Phone cid) adres Job) model noge ome Eld Employee 1 Address) name) manages M rent operation type Part 2 (mapping)) -Relations. -primary key / Forein Key connection customers F.K Id name| Lname phone address clio P.K car: ICNe model name year! (P.Kt Insurance: le F.K Ins-No amount type