Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. Draw an entity-relationship diagram for the following situation: Many students play many different sports. One person, called the head coach, assumes the role of
5. Draw an entity-relationship diagram for the following situation: Many students play many different sports. One person, called the head coach, assumes the role of coaching all these sports. Each of the entities has a number and a name. (Make any assumptions necessary to complete a reasonable diagram. List your assumptions.) 7. Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from many vendors. The bakery has commercial customers, such as schools and restaurants, that regularly place orders for baked goods. Each baked good has a specialist that oversees the setup of the bakery operation and inspects the finished product. 9. Draw an E-R diagram for the ordering system in Figure 13.24 10. Draw a data flow diagram for placing an order. Base your data flow diagram on the E-R diagram in Problem 9. 17. Leon \& Lim, a Milan-based Chinese fashion design company run by business partners Daiyu and Muchen, would like to use data analytics to understand their customers better through their database. In two paragraphs, discuss how you can help Daiyu and Muchen approach the use of data analytics for this application. Include a list of six questions you will ask them about their needs for data
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started