The librarian of a small towns library wants a database for the library that will help it to keep track of its collections (e.g. fiction, non-fiction, and journals), the books or items in those collections, the physical location in the library of these collections, the members of the library and the books they borrow from the various collections. The database must keep track of which book or item belongs to which collection, which collection is located where in the library, and which members borrowed books or items from which collections. Library members and library staff (users) must be able to login to the database to use it to locate books, and the database must keep track of user logins/ logouts. In addition, users must have different levels of access, which will determine their access to different parts of the database. 1. List the entities for the scenario. 2. Assign attributes to each of the entities listed in part 1 above. State any assumptions you make regarding the clients needs. 3. For each of the entities listed in part 1 above, identify the primary key and other keys. State any assumptions you make regarding the clients needs. 4. Use the entities discovered in part 1 above to derive all of the unary and binary relationships between all of the pairs of entities. State any assumptions you make regarding the clients needs. 5. Find the Assertions for each relationship 6. Draw a Detailed ERD

7. Write a report and put all your work for the items above