Question: Given the tables assuming the relationship is now a MANY - to - MANY relationship, which of the following would represent the correct placement of
Given the tables assuming the relationship is now a MANYtoMANY relationship, which of the following would represent the correct placement of foreign keys?
PRODUCT ProductID Description, Cost
SUPPLIER SupplierID ContactName, PhoneNumber
PRODUCT can have MANY SUPPLIERS
SUPPLIER can have MANY PRODUCTS
PRODUCT ProductID Description, Cost
SUPPLIER SupplierID ContactName, PhoneNumber
PRODUCTSUPPLIER ProductID SupplierID
PRODUCT ProductID Description, Cost, SupplierID
SUPPLIER SupplierID ContactName, PhoneNumber
PRODUCT ProductID Description, Cost
SUPPLIER SupplierID ContactName, PhoneNumber
PRODUCT ProductID Description, Cost, SupplierID
SUPPLIER SupplierID ContactName, PhoneNumber, ProductID
PRODUCT ProductID Description, Cost
SUPPLIER SupplierID ContactName, PhoneNumber
PRODUCTSUPPLIER ProductID SupplierID, PhoneNumber
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
