Top Posters
Since Sunday
w
3
w
3
e
3
3
r
3
b
2
M
2
V
2
f
2
c
2
c
2
K
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
pagnor pagnor
wrote...
Go to Answer
Posts: 1540
Rep: 12 0
7 years ago
Given the tables

PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)

as shown in the figure below, which of the following would represent the correct placement of foreign keys?   

 
A) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
B) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
C) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
D) PRODUCT (ProductID, Description, Cost, ContactName)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 30 times
1 Reply
Genuine Coder
Replies
Answer verified by a subject expert
ade9jaade9ja
wrote...
#1
Top Poster
Posts: 690
Rep: 4 0
7 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

pagnor Author
wrote...

7 years ago
Brilliant ツ
SUmmerPeople
wrote...

Yesterday
You make an excellent tutor!
SupremeDJ
wrote...

2 hours ago
Good timing, thanks!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  494 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 1691
  
 678
  
 145
Your Opinion
Previous poll results: Which is the best fuel for late night cramming?