Database Plan for Library Records

Running head: DATABASE PLAN FOR LIBRARY RECORDS
DATABASE PLAN FOR LIBRARY RECORDS
Name of the Student
Name of the University
Author Note

1DATABASE PLAN FOR LIBRARY RECORDS
Library management system facilitates the user with maintaining the book details properly.
This ensures proper storage of books and details regarding each customer. With the implementation of
this system the organization can develop a better way that will reduce the data entry and time required
in preparing calculation based on the reports. The main purpose of developing a library management
is to keep tracks related to the information of every books stored within the library, their actual price
and total number of books available in library (Laudon, 2016). User finds it easier to maintain the
records automated instead of having a manual written system. Database system ensures proper safety
towards all the database stored regarding to the library. The main data types that are important while
developing a database system for maintain the library records. These are as follows:
 Integer
 Varchar
 Date
 Time
Data Requirements for Developing A Database for Library Management
Entities
 Employee: this entity aims at storing all the details regarding each employee associated
with the library. This includes details regarding the address of each employee, with their
respective id and name (Coronel & Morris, 2016). This will help to understand which
employee is in charge of the library.
 Customers: this entity stores all the details related to the customer including customer
contact details and book issued by the customer. Once the customer returns the book the
data regarding return date also gets registered. This helps to identify the number of time
one customer borrows the book.
 Branch: branch entity contains the detail regarding each branch and the people registered
in the nearby branch. Each branch contains branch id, manager id and address details.
Address section further helps in organizing details based on branch code and city.

2DATABASE PLAN FOR LIBRARY RECORDS
 Books: books entity contains the ISBN number with the rental price that the customer
needs to pay while issuing the book. The book title needs to be stored properly in order to
have a proper records.
 Issue status: this includes detail regarding each issue including the date of issue and ISBN
number. This also includes book name and date of issue (Arasu et al., 2016). The date
issued an important part for the database.
 Return Status: this includes return date name of the book issued, return id and ISBN
number. Each details need to be filled properly in order to maintain the records properly.
Attribute for Each Entities
Employee
 Employee_name
 Employee_id
 Employee_address
Branch
 Branch_id
 Manager_id
 Address_details
o Contact
o Branch_code
o City
o State
o Zip_code
Customers
 ID