Task 1. 1.. [pic]. 2.. Mapping of ER diagram to the rel
Added on -2019-09-23
| 2 pages
| 184 words
| 320 views
Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
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
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan