Please convert figure 9.9 in p305 into relational schemas. In the table, the primary key and...

Question

Question

Please convert figure 9.9 in p305 into relational schemas.

In the table, the primary key and foreign keys (arrows) must be identified.

Answer 1

Answer #1

VEHICLE(Vin,Price,Model)

CAR(Vin,References VEHICLE(Vin),Engine_Size)

TRUCK(Vin ,References VEHICLE(Vin),Tonnage)

SUV(Vin ,References VEHICLE(Vin),No_seats)

SALE(Vin,Sid,Ssn,Date)

SALESPERSON(Sid,Name)

CUSTOMER(Ssn,Name,City,Street,State,Vin References VEHICLE(Vin),Sid References SALESPERSON(sid))

underlined are primary keys and italicised are foreign keys. Some tables have attributes that are both PK and FK.

> in which book is the exercise

GeorgeAnd899 Tue, Oct 19, 2021 7:26 AM

Answer 2

Similar Homework Help Questions

Database Schemas: Please draw the schemas like the example and not just list the entities and attributes! Thanks in adva...

Database Schemas: Please draw the schemas like the example and not just list the entities and attributes! Thanks in advance! Convert the E-R diagrams to relational schema and show Primary Keys (using underline) Foreign Keys (using dotted underline) .Referential Integrity Your schema should look similar to the example below: CUSTOMER CustName ORDER OrderDate dob admitdate D,C gradstudent advisor major mimor class person phone D,C home homeid street buyer city ssn state ssn address zip nobedrms spousename profession spouseprofess minprice bdrms...
Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational s...

Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...