Using the following business rules, illustrate an extended entity-relationship (EER) model. Any assumptions necessary to support your model are required. · A large company has several parking lots which are used by staff. · Each parking lot has a unique name, location and capacity. · Each parking lot has parking spaces, and each parking space is uniquely identified by a space number. · Members of staff can request the use of a parking space. · Each member of staff has a unique staff number, name, telephone extension number and vehicle registration number. · The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly fee. · One parking space can be allocated to only one staff. · Parking spaces that are not under cover are free to use when available. · Up to 20 covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. · There is no charge for this type of booking but the member of staff must provide the visitor’s vehicle registration number. You may draw the EER using Crow’s Foot. Show clearly all the entities, attributes, relationship labels, cardinalities, including primary key and foreign key as well as the disjoint and completeness constraints, if applicable.
Oh no! Our experts couldn't answer your question.
Don't worry! We won't leave you hanging. Plus, we're giving you back one question for the inconvenience.
Using the following business rules, illustrate an extended entity-relationship (EER) model. Any assumptions necessary to support your model are required.
· A large company has several parking lots which are used by staff.
· Each parking lot has a unique name, location and capacity.
· Each parking lot has parking spaces, and each parking space is uniquely identified by a space number.
· Members of staff can request the use of a parking space.
· Each member of staff has a unique staff number, name, telephone extension number and vehicle registration number.
· The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly fee.
· One parking space can be allocated to only one staff.
· Parking spaces that are not under cover are free to use when
available.
· Up to 20 covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit.
· There is no charge for this type of booking but the member of staff must provide the visitor’s vehicle registration number.
You may draw the EER using Crow’s Foot. Show clearly all the entities, attributes, relationship labels, cardinalities, including primary key and foreign key as well as the disjoint and completeness constraints, if applicable.
