Top Posters
Since Sunday
s
3
v
3
p
3
m
2
s
2
d
2
N
2
d
2
e
2
s
2
s
2
e
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, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
C) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID)
D) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID)
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 37 times
1 Reply
Genuine Coder
Replies
Answer verified by a subject expert
jeckojecko
wrote...
#1
Top Poster
Posts: 690
Rep: 7 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
this is exactly what I needed
bahajo
wrote...

Yesterday
Good timing, thanks!
lierac00
wrote...

2 hours ago
You make an excellent tutor!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  950 People Browsing
 115 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 313
  
 1685
  
 198
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 436
Previous poll results: Who will win the 2024 president election?