Map the ER diagram into a RELATIONAL SCHEMA. Specify all primary keys and foreig

Question

Map the ER diagram into a RELATIONAL SCHEMA. Specify all primary keys and foreign keys.

email contact_name company_na booking id me destination no_of_passen ger custumer id address_cust booking does customer driver_require date_required contact no hires is handled by vehicle_i salary employ_id vehicle colour national insurance nu name vehicle_owne mber employee reg istrat ion_ no address_ emp job_desription make date_of_reg tration home no model hourly rate gender can be DOB takes driver test river Test_results Test id Test date Test_type icense no CPC_expiry_date PVC_expiry_d ate CPC_no expiry_date PVC_no

Explanation / Answer

Following are primary keys :

1) customer id

2) booking id

3) vehicle id

4) Test id

5) driver id

6) contact no

7) registration no

8) license no

Following are foreign keys :

1) expiry_date

2) driver required

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---