Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

A project is proposed to design a database for shops selling dairy products. Each shop has a unique ID, name, address and owner. Different shops

A project is proposed to design a database for shops selling dairy products. Each shop has a unique ID, name, address and 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

NOTE IN CASE OF ANY QUERY FEEL FREE TO ASK IN COMMENT ANYTIMEHAPPY LEARNING AND KEEP Homework H... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

Students explore these related Databases questions

Question

=+b) Create a p chart for these samples.

Answered: 3 weeks ago