You are consultant that is responsible for building a database for a coffee company that sells whole bean coffee online. To ensure the database captures all of the required elements for the business, you are going to build a data model first. To build your data model you first collect details on the business operation, their workflow, and what data they want to store/track. Double T Roasters is a coffee company that roasts only the finest of arabica coffee. They started off by selling their whole bean coffee to their friends and family, but have expanded to selling through their website. It is important that they keep track of all their new customers, the orders placed, and the different coffees available. The owner of Double T Roasters tells you the following details: - At a minimum we need to track our customer's name (first and last), and their address information. It would be nice to also have additional contact information as well. A customer can have any number of orders (including zero). - We would like to track the order date, the quantity of items ordered, and the total for every order. An order must have at least one coffee involved, but can have any number greater than that. - For our coffees we would like to track the coffee description, the processing method, the bag size, and the price. A coffee can be affiliated with any number of orders (including zero). - Once you build the database we would like to know where our orders are generally goi file preview ich of our coffees are ordered most often. We would also like to know what times of year are more popular, and if there are specific coffees that are subject to seasonality. - Create a data model that represents the given business situation. (50\%) - Be sure to include the following (where necessary): Entities, Unique Identifiers, Relationships, Foreign Keys, and Attributes. - Show the relationships between the entities, using the standard notation we have adopted for our course. - A write-up explaining your reasoning for each of the Entities, Unique Identifiers, Relationships, Foreign Keys, and Attributes. (50\%) - This does not need to be a long write-up. Simply have a paragraph per entity, and explain your logic on all the things contained within that entity, and how that entity interacts with any other entity(s). - I will be evaluating the write-up on your general understanding of the data modeling terms we have discussed in this course, and how they relate to this specific business case
