Database Design and Implementation: Personal Library

What is Database Design?

Web definitions
Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.

Our Database:

This database encompasses multiple users’ collections of books, and allows them to have a centralized digital location for this information. It also allows users to keep track of borrowed books. Through premade queries one can see values, locations, authors, and many other aspects of the library.

Microsoft Access Personal Library Database






Elaine's Collection

Elaine's CollectionSQL


Currently Borrowed

Currently BorrowedSQL


Collection Cost and Number of Books

Collection Cost and Number of Books SQL

Imput Forms

Book Imput Form
Book Imput Form2
Book Imput Form3


Borrowing Imput Table





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s