Question
Generate an ER model for each of following descriptions-
(a) a large organization has some parking lots that are used by staff.
(b) Every parking lot has a unique name, location, capacity, and number of floors (where appropriate).
(c) Every parking lot has parking spaces, that are uniquely identified using a space number.
(d) Members of staff can apply for the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.
Characterize all the ER models described in parts (a), (b), (c), and (d) as a single ER model. Provide any assumptions compulsory to support your model.