BookTown Store’s Relational Database Creation

Introduction

The relational database simplifies storage, manipulation, and retrieval of information from diverse sets of tables. The relational database comprises tables, forms, reports, and queries. This report explains the creation and the use of the relational database in tracking books, customers, and shipments of BookTown, a book retail store.

We will write a
custom essay
specifically for you

for only $16.05 $11/page
308 certified writers online
Learn More

Database Creation

To create tables, the excel files for Books, Customers, and shipments were imported into access using the import wizard.

Entity-Relationship Diagram

The snapshot below displays the entity-relationship diagram created by dragging primary keys into secondary keys.

Entity-Relationship Diagram

Query Construction

The queries were constructed using a simple query wizard located in the query wizard in the create tab.

Query 1- Stock levels

The query was created by selecting Book_title, Edition, and Current_Stock in the table of Books.

Query 2-Orders by Customer

  • In the simple query wizard, the table of customers was selected and fields of their first name, last name, shipment id, and the retail price was selected.
  • In the design view, the total record was added, the count was selected in the shipments field, and the sum was selected in the retail prices field as shown below.

Orders by Customer

Get your
100% original paper
on any topic

done in as little as
3 hours
Learn More

Query 3-Books Shipped with Total

The query was created by selecting the Book_title, ISBN, Retail Price, and Book-id as a link between tables of shipment and books.

Books Shipped with Total

Query 4-Books Published Before 1990

  • Using a simple query wizard, the Book_title, Edition, and publication date.
  • In the design view, the publication data was typed <#01-Jan-90# on the criteria record and the field of the publication date as indicated below.

Books Published Before 1990

  • The outcome of the query of books published before 1990 are shown below

Query 5-Customers by Book

In the design view of the query, [Enter Book Title] was entered in the criteria field on the field of Book_Title as depicted below, and “unique values” were indicated “yes” in the properties sheet.

Customers by Book

Creation of Forms

  • Using form wizard, all fields of Books, Customers, and Shipments’ tables were selected in respective steps.
  • Colored backgrounds were used to enhance the appeal of the forms

Books Form

Books Form

Customers Form

Customers Form

We will write a custom
essays
specifically
for you!
Get your first paper with
15% OFF
Learn More

Shipments Form

Shipments Form

Creation of Reports

Reports of Books, Customers, Shipments, and Stock levels were created using report wizard by selecting appropriate fields.

Book report

Book report

Stock Levels Report

Stock Levels Report

Conclusion

Tables, forms, reports, and queries are different parts of a relational database. They are very important in database management because they ease the storage, manipulation, and retrieval of data. The use of referential integrity in entity-relationships avoids redundancy of data entry, and thus, improving the accuracy and integrity of data.

Print Сite this

Cite this paper

Select style

Reference

StudyCorgi. (2021, March 31). BookTown Store's Relational Database Creation. Retrieved from https://studycorgi.com/booktown-stores-relational-database-creation/

Work Cited

"BookTown Store's Relational Database Creation." StudyCorgi, 31 Mar. 2021, studycorgi.com/booktown-stores-relational-database-creation/.

1. StudyCorgi. "BookTown Store's Relational Database Creation." March 31, 2021. https://studycorgi.com/booktown-stores-relational-database-creation/.


Bibliography


StudyCorgi. "BookTown Store's Relational Database Creation." March 31, 2021. https://studycorgi.com/booktown-stores-relational-database-creation/.

References

StudyCorgi. 2021. "BookTown Store's Relational Database Creation." March 31, 2021. https://studycorgi.com/booktown-stores-relational-database-creation/.

References

StudyCorgi. (2021) 'BookTown Store's Relational Database Creation'. 31 March.

Copy to clipboard

This paper was written and submitted to our database by a student to assist your with your own studies. You are free to use it to write your own assignment, however you must reference it properly.

If you are the original creator of this paper and no longer wish to have it published on StudyCorgi, request the removal.

Psst... Stuck with your
assignment? 😱
Susan
Online
Psst... Stuck with your assignment? 😱
Do you need an essay to be done?
Yes
What type of assignment 📝 do you need?
Yes
How many pages (words) do you need? Let's see if we can help you!
Yes