The general public library needs to store information pertaining to its customers, its workers, the physical locations of its branches, and the media stored in those locations.

It specializes in lending out two types of media: books and videos. The library must keep track of the attributes of each media item: its location, status, descriptive attributes, and cost for losses and late returns.

Books will be identified by their ISBN, and videos by their title and year. In order to allow multiple copies of the same book or video, each media item will have a unique ID number.

The following diagram shows a basic E-R diagram for the Library Management System:

The library customers will provide their name, address, phone number, and date of birth when signing up for a library card. They will then be assigned a unique ID number. Checkout operations will require an UID number, as will requests to put media on hold. Each library card will store its own dues. The late fees of returning the media items will be stored in a separate penalty object. These penalties will be summed up for the master object.

Employees will work at a specific branch of the library. They receive a pay check, but they can also have library cards, therefore, the same information that is collected about customers should be collected about employees.

If you did not understand the problem statement, please go back to the two paragraphs and read it again.