Staff staffNo name extensionTelNo A E TI B F Covered monthly Rate Space spaceNo {PK} G C Uncovered D Parking Lot parking
Posted: Thu May 05, 2022 1:33 pm
Figure. Parking lot ER model
The above ER model is supposed to be created for each of the
following descriptions:
(a) A large organization has several parking lots, which are
used by staff.
(b) Each parking lot has a unique name, location, capacity, and
number of floors (where appropriate).
(c) Each parking lot has parking spaces, which are uniquely
identified using a space number.
(d) Members of staff can request the sole use of a single
parking space. Each member of staff has a unique number, name,
telephone extension number, and vehicle license number.
(e) The majority of parking spaces are under cover and each can
be allocated for use by a member of staff for a monthly rate.
(f) Parking spaces that are not under cover are free to use and
each can be allocated for use by a member of staff.
(g) 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.
1..0
1..*
1..1
0..1
Staff staffNo name extensionTelNo A E TI B F Covered monthly Rate Space spaceNo {PK} G C Uncovered D Parking Lot parking LotName location capacity noOfFloors
The above ER model is supposed to be created for each of the
following descriptions:
(a) A large organization has several parking lots, which are
used by staff.
(b) Each parking lot has a unique name, location, capacity, and
number of floors (where appropriate).
(c) Each parking lot has parking spaces, which are uniquely
identified using a space number.
(d) Members of staff can request the sole use of a single
parking space. Each member of staff has a unique number, name,
telephone extension number, and vehicle license number.
(e) The majority of parking spaces are under cover and each can
be allocated for use by a member of staff for a monthly rate.
(f) Parking spaces that are not under cover are free to use and
each can be allocated for use by a member of staff.
(g) 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.
1..0
1..*
1..1
0..1
Staff staffNo name extensionTelNo A E TI B F Covered monthly Rate Space spaceNo {PK} G C Uncovered D Parking Lot parking LotName location capacity noOfFloors