Question: task a local public library would like to store information...
Task: A local public library would like to store information about its members, books, employees, branches, etc. Since you are taking a database class, you are asked to assist the library to design a database based on the following specifications.
The library keeps track of each book’s unique ID number, title, year of publishing, location, status, category, publisher, the cost for losses, and cost for late return. If the library has several copies of the same book, each copy has its own ID number. There are two different types of books: print books and audio books. Some books may be available in both types. An audiobook can be further described by its narrator, ASIN, listening length, and language. A print book has an ISBN.
Each book must be written by one or more authors. An author can write more than one book. To be called an author, one, of course, has to write at least one book. Each author is identified by an ID number. The library also keeps track his/her first name, middle name, and last name.
Each member is assigned a unique member ID when s/he applies for a library card. In addition, the library keeps track of its members’ first name, middle name, last name, phone number, address, and date of birth.
Check out operation will require a member to present his/her library card. For each checkout, a member can borrow up to 10 print books and 2 audiobooks for 14 days. The checkout date and due date of every checkout needs to be recorded. When the books are returned, the return date is recorded. If it is past its due date, a fine will be calculated and issued.
The library has several branches in various locations. Each branch is identified by its unique name, address, and phone number. Each branch stores several copies of books and has several employees.
Finally, the library keeps information about its employees. For each employee, the library keeps that person’s unique ID number, first name, middle name, last name, address, SSN, date of birth, phone number, job title, and salary. Specifically, your tasks are:
1) Draw an ER-diagram for the database by identifying the entity sets, relationship sets, and their multiplicity, and the primary key for each entity set (and weak entity set, if any) and each relationship set.