Creating a Table for Books Acquisition

This tutorial is part of How to Make Library System.

Books Acquisition is where you save the information of a Book. In this tutorial I will explain to you the importance of parent/child form to grand child. Since there could be more than one copyright in a book all we have to do is normalize our table into three separate table called Books, Books Copyright, and Books Accession.

Books table will include fields that the data does not repeat so we can about duplication of record. Books Copyright will separate the copyright year of a book into multiple records. Books Accession will save the control number of a book use for borrowing and returning of books based on the copyright year.

The relationship would be:

One-to-many relationship

[inline:One to Many Relationship.jpg=Table Relationship]

In addition to three tables, we will also include Subject table. Books table will have a SubjectID field to lookup for values from subject table. This is also one of the features of a relational database to eliminate data redundancy.

The first thing to do in making a library system is to create a table. Follow the steps provided in the video below.

Books Acquisition Table

Books Copyright Table

Books Accession

Subject Table

Since the purpose of this tutorial is to teach you on how to make a library system in step by step manner take note that only these four tables are added to the Library System.mdb database for the meantime.