3. 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.