The Cheesy Deli Co-op sells cheese via their website direct to the public, shipping from their warehouses located in Sydney, Melbourne, and Adelaide.

The cheeses they offer are supplied from cheesemakers ranging from hobbyist to medium-sized dairies, who may not have their own distribution networks. In order to help customers keep track of which cheeses they enjoyed, and may wish to purchase again, The Cheesy Deli's customers can give a rating from 1 to 5 stars for each cheese they have purchased.

All sell prices and purchase costs are on a per unit basis.

 

Two fields of the Rating entity are missing; what should they be? Explain with reference to the diagram.

Questions:

The ERD is only a partial extract of the full database. Propose one other entity that could also have been included in the ERD? What would be the role of this entity (the kind of information stored)? What would the cardinality between this entity and the entity (or entities) it is related to in the ERD be (please state direction of cardinality) and why?

Question:

The purchasing manager of The Cheesy Deli is reviewing which cheeses to purchase for the upcoming period. Which entities and fields from the ERD might he find useful in determining which cheeses and in what quantities to purchase?

Question:

To encourage sales, the warehouse manager suggests that The Cheesy Deli should provide a discount to specific batches of cheese. Is this possible? Explain why with reference to the ER Diagram.

Cheese PK Cheese ID Name Description Sell price Cheesemaker ID is made in is made for Batch PK Batch Number PK Cheese ID Purchase Cost Quantity on Hand Quantity Reserved Use-by date Storage Location popularity from popularity for included in includes Rating PK ??? PK ??? Stars PK PK Order Line Order ID Item Number Cheese ID Quantity given by part of gives consists of PK Customer Customer ID Name Address E-mail Address Password PK places Order PK Order ID placed by confirmed by Customer ID Date Total Amount Ship Date received for Payment Order ID Amount Date Credit Card Number Confirmation Code