Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the business rules listed below, label the diagram according to the business rule. For example, for the first business rule, you would
For each of the business rules listed below, label the diagram according to the business rule. For example, for the first business rule, you would put an a next to the word MENU in the diagram.
a A menu consists of a menu ID a description and a type.
b Events consist of an ID date, location and time.
c Events have exactly one menu and the same menu can be served at multiple events.
d A dish has an ID name and time.
e A dish has multiple ingredients.
f Staff members have an ID name and salary.
g Staff members have many skills.
h A work schedule is used to determine which staff nmbers work at which events and consists of a start and end time as well as the position the staff member is working for the specified event.
i A single work schedule corresponds to exactly one event and exactly one staff member. j Staff can work multiple events.
k Staff have exactly one manager that supervises them and that manager is part of the staff.
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