Create an ER model 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) Represent all the ER models described in parts (a), (b), (c), and (d) as a single ER model.
Provide any assumptions necessary to support your model.
You might also like to view...
The ____ manager is concerned with long-range planning and decisions.
A. operational B. tactical C. strategic D. principle
A technician installed a new 2GB hard drive on a server, but it only shows 1.86GB of unformatted space. Which of the following is a reason for the difference?
A. Manufacturers use base 10 instead of base 2 in advertising disk space. B. A swap file is added to the drive automatically, reducing available disk space. C. The disk controller maps out a section of hard drive space for diagnostics. D. Disk drivers consume space of the hard drive.