Please use a drawing tool to draw ERD. No hand drawing assignment will be accepted. You can insert your diagram in this document and submit it as word.doc format.

Missing/Incorrect entity :-5 per each

Missing/Incorrect relationship :-5 per each

Missing/Incorrect attribute :-1 per each

Missing/Incorrect cardinality : -2 per each

*Note: Do not collaborate the assignment with your fellow students

Do not copy and paste the work from other sources

will get zero for the assignment grade

1. Create an ER model to represent the data use by the library.

The library provides books to borrowers. Each book is described by title, edition and year of publication and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan and the allowable loan period for a given copy. A borrower may loan one or many books and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

2. Create an EER model for each of the following descriptions:

A large organization 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.

The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly rate.

Parking spaces that are not under cover are free to use and each can be allocated for use by a member of staff.

Up to twenty 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 visitors vehicle license number