logo

ER Diagram to Relational Schema Mapping

   

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
ER Diagram to Relational Schema Mapping_1

End of preview

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

Related Documents