logo

Task 1. 1.. [pic]. 2.. Mapping of ER diagram to the rel

   

Added on  2019-09-23

2 Pages184 Words320 Views
Task 11.2.Mapping of ER diagram to the relational schemaMapping of 1:n relationshipsa.In the relation has we include the primary key company_id of company relation as foreign key in the customer service personnel relation and call it cidb.In the relation manages we include the primary key login_id of company service personnel as foreignkey in the customer relation and call it lidc.In the relation books we include the primary key login_id of company service personnel as foreign key in the package relation and call it lidd.In the relation tracks we include the primary key customer_id of customer as foreign key in the shipment relation and call it cust_ide.In the relation update shipping information the primary key login_id of company service personnel as foreign key in the shipment relation and call it lidf.In the relation generates the primary key login_id of company service personnel as foreign key in thereport relation and call it lid

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Normalization & Customer Service Professional
|3
|690
|381

Assignment On Customer Service Professional | Normalization Assignment
|3
|690
|400

Manufacturing and Service Process Maps | Operation Maps
|6
|1048
|26

(PDF) Database Management System
|24
|1258
|484

Information System: Repair-Made Easy
|14
|911
|412

Individual Project on Burger Space Limited
|16
|3362
|185