Answered step by step
Verified Expert Solution
Link Copied!

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 n/mbers 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.
image text in transcribed

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

More Books

Students also viewed these General Management questions

Question

Why do students fall prey to late-payment fees?

Answered: 1 week ago