For the first lab you will turn in an ER diagram for one of the following:

Option 1: the set of requirements for a simplified library database system:

The library has a collection of books and periodicals. Only books can be borrowed. Periodicals cannot leave the library.

All items in the library have an identification number, title and publisher. In addition, for books there is also: authors, ISBN, edition and genre.

The library users are identified by user_number, name (first and last), address, tel_number and email_address

A library user may borrow any number of books. When a user borrows or returns a book, the date needs to be recorded.

Since a book can have many authors and an author can have many books published, you may want to treat author as a separate entity type.

Option 2: a set of requirements that you will determine. You will need to turn in the set of requirements along with the ER diagram. It needs to have at least:

4 entities, including a specialization or ganeralization

a composite attribute

a multi-valued attribute

a many-to-many relationship

Unless you already have access to an ER diagram tool that you like, I suggest you use draw.io (Links to an external site.)Links to an external site., which is a free online design tool.