Home > University > Computer science > Database system for college library

Database system for college library

You can download this essay for free. All you need to do is register and submit at least one of your essays to us.

Or you can purchase this essay for just $2 instantly without registering

Downloads to date: N/A | Words: 3716 | Submitted: 17-Oct-2011
Spelling accuracy: 94.9% | Number of pages: 40 | Filetype: Word .doc

Description

Library management system

Preview

A Database for a College Library


Contents
Abstract 3
Chapter 1 4
Introduction 4
1.1 Background & Context 4
1.2 Aim 4
1.3 How does it Work? 4
1.4 Rationale of the project 5
1.5 Barriers of database System 5
1.6 Systems Development Phases 6
Chapter 2 7
2.1 Entity Relationship Diagram (ERD) 7
2.1.1 What is Entity Relationship Diagram (ERD) 7
2.1.2 Components of ERD 7
2.1.3 History of ERD 8
2.2 Unified Modeling Language (UML) 8
2.2.1 What is Unified Modelling Language (UML) 8
2.2.2 History UML 8
2.3 Database (MySql) 9
2.3.1 Why MySql 9
2.4 ERD of the Database of College Library 10
2.5 Data Dictionary 11
2.6 Normalization 17
2.6.1 The Normal Forms 17
2.6.2 The 1st Normal Form 17
2.6.2 The 2nd Normal Form 18
2.6.3 The 3rd Normal Form 18
2.7 Create Database 19
2.7 Create Database 19
CREATE DATABASE library_management 19
2.7.1 Create Tables 19
2.7.1 Relationship 26
2.8 SQL Statement for Required Functions 29
2.7.1 Student Join the Library 29
2.7.2 Lecturer Join the Library 29
2.7.3 Member Leave the Library 29
2.7.4 Member Borrow Book 29
2.7.5 Member Return Book 30
2.7.6 Member Check Book: is Available or not 30
2.7.8 Librarian Search for Book those are Overdue 30
2.8 Conclusion 31
2.9 Reference 31



Abstract
One of the technologies that most people have become familiar with either at work or while studying in School/College/University is Database. The word Database in an extremely technical term, however because of essentiality of information technology in our daily life, the Database has become one of the important part of our life.
A Database for a College Library is an enterprise resource planning system for a library, used to track books owned, person who have borrowed. It is a very useful system for any library to serve the customer better and mange books.
I have designed this Database to:
Store Book’s information
Student/Lecturer Information
Receipt and issuance of books borrowed by the members
Collect fine from those members who are failed to return books in the given time.


Chapter 1
Introduction
1.1 Background & Context
Before invention of computer libraries were used to use card catalogue to index their holdings. But later, when computer becomes available card catalogue system replaced by automated system which called library automation. Automation of the library saves labour and time in resort the catalogue and keeping it up-to-date.
As a result of high traffic in libraries it is very difficult to track the books while it is required by reader/member. So the demand of database system is increasing day by day. Therefore a database is very essential for library to store the information of Book, distributing them on demand and collect them in proper time. A good database helps a library to trail towards its goal and make sure the member’s satisfaction.
1.2 Aim
The main aim of this proposal is to develop a database for college library. The aims of the database system are as below:
To develop the service quality
To make the information available to librarian and member of library
To ...

Download this essay in full now!

Just upload at one of your essays to our database and instantly download your selection! Registration takes seconds

Or you can download this essay for $2 immediately without registering

---

Comments and reviews

Reviews are written by members who have downloaded the essay

No comments yet. If you download the essay you can review it afterwards.