Concept explainers
Please DRAW a normalized ER diagram for the following situation: Unidiner is a university dining service organization that provides dining services to a major university.
The following describes part of the business.
Develop a conceptual ER diagram that captures business facts
● The organization sets up a team of its staff to work on each event. Each staff has a name, salary, and some skills. Each staff can be part of different teams.
● The organization assigns one of the staff as the supervisor of the team who supervises the team during the event.
● Each event has a date, location and time.
● For each staff in a team, there is a working start time, working end time and position defined.
● The organization has menus. For each event, the university chooses one of the menus to be served at the event. Each menu has a description and a type.
● Each menu contains several dishes, and each dish could be included in different menus. Each dish has a name, preparation time and some ingredients.
Please draw it out
Step by stepSolved in 2 steps with 1 images
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education