Design a database for an online shop. There are many buyers buying some goods on certain day. We are interested in the b
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Design a database for an online shop. There are many buyers buying some goods on certain day. We are interested in the b
Design a database for an online shop. There are many buyers buying some goods on certain day. We are interested in the buyers' identifier (b_id), name, and address; we are interested in g_id, price and producer for the goods. Every buyer buys quantity pieces of certain goods on certain date, we use a buying relationship to represent this. Please answer the following questions. (14 points) (2) According to the E-R diagram, turn the E-R model into three relations; make sure to give the relation name, column name, primary key (underlined), and foreign key (italicized) if any. Answer:
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!