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
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 step
Solved in 2 steps with 1 images
