Question: Problem 2 . ( 3 0 points ) Consider the following specification of requirements, for a database that will be recording the use of parking
Problem points Consider the following specification of requirements, for a database that will be recording the use of parking spaces by staff members for a calendar year:
a A large organization has several parking lots, which are used by staff. Each member of the staff has a unique ID number, name, telephone extension number, and vehicle license number.
b Each parking lot has a unique name, location, capacity, and number of floors.
c Each parking lot has parking spaces, which are identified using a space number that is unique in each parking lot only, ie the same space number can be used in multiple parking lots. Each parking space is either covered or uncovered.
d Members of staff can be assigned the sole use of a single parking space; each parking space will not be shared throughout the year, even if the staff member will only use it part of the year. Not everyone will request and be assigned a parking space, and some parking spaces may remain unused. The use period start month to end month must be recorded for each parking space.
From the previous specification, identify and represent in a single ER diagram:
The strong and weak entity types and their attributes; identify their PKs discriminators in the diagram.
The relationship types and their attributes if any.
The cardinality and participation constraints.
Provide any additional assumptions to support your model if necessary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
