Database Essay

2410 Words Mar 29th, 2015 10 Pages
Project on Database Design for College Library

Index: 1. Introduction............................................................................ 3 2. Requirement Analysis ..............................................................4 3. Defining Entitiy and Attribute...................................................5 4. Entity Relationship Diagram......................................................6 5. Non- Technical overview of Entity Relationship Diagram..........7 6. User Applications...................................................................... 7 7. ER
…show more content…
Any DBMS will be recommended and used for developing the prototype of the system. I will use Create tables to represent the relation between assets of library which will shows the data library holds.

Requirement Analysis defining entities and their attributes.

The expected Library database system must provide cost effective and efficient way to maintain data of library. The database need to store every transaction that happens in the the library. The database system should store details of Employee,Student, books, journals details in the database.

Every student must poses a valid student ID to borrow books from the Library.
Library can issue any category of books irrespective to the department or course student studies.
Library adiministrator can able to track the book availability when requested by a student.
A student is eliigible to take only three book at a time.

When a student Access a book an entry of his name is entered in database by librarian and return date is automatically comes up in system. It also shows how many books are issued to one member. They can only borrowed maximum of three books at a

Related Documents