Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started