Represent the above as a single Entity Relation model. Provide any assumptions necessary to support your model
Tairiq Mines
Error! Bookmark not defined.Tairiq Mines in Glen Austin has several parking lots, which are used by
staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).
Each parking lot has parking spaces, which are uniquely identified using a space number. 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.
Source: Connolly, T & Begg, C (2015), A Practical Approach to Design, Implementation and Management, Pearson
Question 5
5.1 Represent the above as a single Entity Relation model. Provide any assumptions necessary
to support your model
5.2 Write an SQL query that displays the parking space number, location as well as the name
of the staff member to whom the parking space has been allocated.
Step by step
Solved in 3 steps with 1 images