$($a$)$ Draw a logical level ER diagram based on the following scenario. Indicate

clearly any assumptions that you make.

$(15$ Marks$)$

$"$In a library, there are several copies of each book and members can borrow

several books each time. For members, the library needs to record their

membership number, name, address, contact number, their date of birth and

qualification. Some of the members may have more than one qualification. For

each book, the library records the ISBN number, title, author, publisher, print date

and number of copies. It is important to record which member of staff loaned a

book to a member. The due back date of borrowed books needs also to be

recorded."

b$)$ Convert this ERD into Relational Model.

$(15$ Marks$)$