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.http://en.wikipedia.org/wiki/Database_design

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

Screenshots:

Relationships

Relationships

Data

SQL/Queries

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:

WordPress.com Logo

You are commenting using your WordPress.com 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