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 ) .

Interview Candidate
Aug 1st, 2011
3
5048

SQL

Answer

Showing Answers 1 - 3 of 3 Answers

ashadevi21
Profile Answers by 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)