Question
For each of the following enterprise constraints decide whether itisalreadyexpressedintheEnhancedEntity-Relationshipmodel (EER) of Table 2 on the next page it is not already expressed in the
For each of the following enterprise constraints decide whether
itisalreadyexpressedintheEnhancedEntity-Relationshipmodel (EER) of Table 2 on the next page
it is not already expressed in the EER of Table 2 on the next page but could be expressed using only features of an EER model.
cannot be expressed in the EER of Table 2 on the next page using only features of an EER model.
In each case explain your answer briefly but clearly.
(a) A table order originates from exactly one table of one restaurant.
(b) Two table orders dispatched at (roughly) the same time must originate from different tables.
Receives_by_phone Restaurant hone_line phone num Contains dateTi me billingNo total Order Originates from Table optional.orh number PhoneOrder TableOrder street wai ter deliveryAddress postcode city Receives_by_phone Restaurant hone_line phone num Contains dateTi me billingNo total Order Originates from Table optional.orh number PhoneOrder TableOrder street wai ter deliveryAddress postcode city
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