This will be achieved by creating a simple reservation system for the local library by using Microsoft Access to produce a database. This work will be useful to other students who might be creating a database on a particular subject, as they will be able to gain ideas from the database that will be created.
In this paper following sections will cover the topic as problem definition and scope, database design analysis, methodology, modeling tools and language and technology which can be used for reservation systems.
Scope: This database system will be used by librarians to manage books, articles and also to keep track of borrowed books and any fines for the late return of the books. The user can use this system for the purpose of online reservation when it will be integrated with any web interface technology. So this will eliminate the procedure of traditional reservation (manually) that is employed by the library.
Database Design: Database design refers to the tables, columns, relationships, keys and indices of which a database is comprised. The process of designing a database begins with an analysis of the business requirements that must be met.
It is the process of producing a detailed data model of a database. This model contains all the needed physical design choices and physical storage parameters needed to generate DDL1 which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.
Logical Design: It is a process of designing a logical path to achieve the objectives, done in implementation, and an independent way. Here SQL2 will be not referenced much because logical database design is independent of physical database design.