Answer Happy

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: