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 - 1 of 1 Answers


  • 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