Introduce specialization/generalization concepts into the ER model shown in Figure 13.11 and described in Exercise 12.13 to show the following:
(a) The majority of parking spaces are under cover and each can be allocated for use by a
member of staff for a monthly rate.
(b) Parking spaces that are not under cover are free to use and each can be allocated for use
by a member of staff.
(c) Up to twenty covered parking spaces are available for use by visitors to the company.
However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle
license number.
The final answer to this question is shown as Figure 17.11.
This figure takes the original Figure 13.11 and adds the additional requirements described
above (a) to (c) using enhanced EER concepts.
You might also like to view...
Going from lower to higher levels in the memory hierarchy, ________.
a) storage access time decreases b) storage cost per bit increases c) storage capacity increases d) both a and b
Explain Mean Time Between Failures (MTBF).
What will be an ideal response?
The function Current Date allows you to add an interval to a date
Indicate whether the statement is true or false
Entering an IF in the Value_if_true box or in the Value_if_false box, creates a(n) ________ function
A) compound B) nested C) embedded D) complex