Task 1
Draw an EER diagram that shows entities, a comprehensive list of attributes, relationships, and assumptions using MS Visio.
Apple stores would like to keep track of sales, product, and inventory information. Assume you have been asked to design a database to achieve this goal. Additionally, consider what potential sales reports an executive may want from this database and write one example of the report. Make any assumptions you deem necessary. Based on the given receipt, answer the following questions:
Task 2
Draw an EER diagram that shows entities, a comprehensive list of attributes, relationships, and assumptions using MS Visio.
Apple stores would like to keep track of sales, product, and inventory information. Assume you have been asked to design a database to achieve this goal. Additionally, consider what potential sales reports an executive may want from this database and write one example of the report. Make any assumptions you deem necessary. Based on the given receipt, answer the following questions:
1. List all possible entities and a comprehensive list of attributes for each entity.
2. Explain why you selected these entities.
3. Draw an EER diagram and their relationships. Make sure you pay attention to ERD notations and naming conventions.
4. Describe the report the sales executive may want to see. Make sure these additional entities and attributes are included in your diagram.