Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project management the managerial process

Authors: Eric W Larson, Clifford F. Gray

5th edition

73403342, 978-0073403342

More Books

Students also viewed these General Management questions

Question

3-34. An email message turning down a job applicant

Answered: 1 week ago