Garth and Anabelle,
The Case Diagrams are good for an overall picture of the relationship between products and users, but the Entity-Relationship Diagram (ERD) is an repository for that information. I think this Diagram is necessary to keep track of our wine!
An entity-relationship diagram is a
data model that describes a particular database in some abstract way. It uses entities to describe things and the
relationship between those entities. The
reason this database is needed is to store information about wine
Southern Wine produces. As you can see we also need to do an inventory to find out how many bottles we have, the price of those bottles, as well as year, name and description. This will be paramount in order for us to have an accurate count of Southern Wines inventory. The current inventory list is out of date, therefore I think we need to start fresh and gather those numbers soon. I think we should be able to accomplish this task, with the appropriate number of employees, in 1 week.
