How many tables are needed to create and their relationships ?

Supplier Name
Supplier Site
Supplier Street
Supplier Contact Person
Supplier City
Supplier State
Supplier Phone number
Business requirement is : One Supplier can have multiple ( n number of
Sites ), One Supplier Site can have Multiple Contacts Persons ( n
number of Contact persons ), One Supplier Contact Person can have
multiple phone numbers ( n number of Phone numbers ) .

Showing Answers 1 - 0 of 0 Answers

ashadevi21

  • Oct 5th, 2011
 

Supplier Table
Columns : Supplier id , supplier name
(Supplier ID, supplier name as Primary Key)
Supplier Site Details
Columns : Supplier name , site, street, city, state
(Supplier name as foreign Key)
Supplier Contact Person Details
Columns : Supplier name, contact person, contact person phone no
(Supplier name as foreign Key)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions