by hand writing
Seve Answer QUESTION 1 18 points A project is proposed to design database for shops selling stairy products. Fach drop has uniqueme, address and an awet (Dame), Different shapes could be wned to the same owner. Each shop selis several dairy products and has a price for cach product. The same product could be sold at different shops, and the price could vary from one shop to another. For each product, the name and expiry date must be recorded. Each product is supplied by a farm, and the product name identities a product uniquely within the farm. Each farm is identified by its unique name, and also has a unique phone number. In addition, some shops may have several contracts with different farms. For each contract, the start and ond dates of the contractare documontod, where the end date can bo always extended during the lifetime of the contract. It is important to keep the number of running contracts for cach farm and cach shop. Dosien an ER diagram for the above scenario, showing all sttributes, kays, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate Hamptions to make the specification exemplete. Do not need my attributes of your own. QUESTION 1 18 points Save Answer A project is proposed to design a database for shops selling dairy products. Each shop has a unique ID, name, address and an owner. Different shops could be owned by the same owner. Each shop sells several dairy products and has a price for each product. The same product could be sold at different shops, and the price could vary from one shop to another. For each product, the name and expiry date must be recorded. Each product is supplied by a farm, and the product name identifies a product uniquely within the farm. Each farm is identified by its unique name. In addition, some shops may have several contracts with different farms. For each contract, the start and end dates of the contract are documented, where the end date can be always extended during the lifetime of the contract. It is important to keep the number of running contracts for each farm and each shop. Design an ER diagram for the above scenario, showing all attributes, keys, cardinalities and participation constraints clearly, Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own. Paste your ER model in the space below, make sure that the image is clear For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac)
