The Cheesy Deli Co-op sells cheese via their website direct to the public, shipping from their warehouses
Question:
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.