CST2355 - Lab05 - Case Study
docx
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
CST2355
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by ChefWaterOyster28
CST2355 Database System
Assessment: Lab assignment 05
Student Name: Tri Le
Lab Professor Name: Sapinderjit Kaur
Online Bookstore Order Management
Aim:
The aim of this database is to create a system for a small online bookstore that sells
books, eBooks, and audiobooks. The database should be able to store and manage information
about the bookstore's inventory, customers, and orders. The database should allow customers
to create an account, make purchases, and keep track of their orders.
Description:
The bookstore is a small online business that sells books in various formats. The primary focus
of the bookstore is on eBooks and audiobooks, but they also have a small inventory of physical
books. Customers can browse the website and purchase books in the format of their choice.
Customers can create an account on the website to make purchases and keep track of their
orders. The website should allow customers to view their order history, track the status of their
current orders, and make changes to their account information.
The database should store information about the bookstore's inventory, including physical
books, eBooks, and audiobooks. Each item in the inventory should have information about the
title, author, publisher, narrator (for audiobooks), file size (for digital formats), and price.
The database should also store information about each customer who has created an account
on the website. This information should include the customer's name, email address, and
password.
Finally, the database should store information about each order that a customer has placed on
the website. This information should include the order date, total amount, and the items that
were purchased as part of the order.
The overall goal of the database is to provide a simple and efficient system for the bookstore to
manage its inventory and orders, and for customers to make purchases and keep track of their
orders.
List and description of the tables:
Customers:
This table contains information about the customers who have created an
account on the website. The table has columns for customer ID, name, email address, and
password.
Columns:
customer_id: integer (primary key)
name: varchar(50)
email: varchar(50)
password: varchar(50)
Orders:
This table contains information about each order that a customer has placed on
the website. The table has columns for order ID, customer ID (foreign key), order date, and
total amount.
Columns:
order_id: integer (primary key)
customer_id: integer (foreign key)
order_date: date
total_amount: decimal(10, 2)
Books:
This table contains information about the physical books that the bookstore sells.
The table has columns for book ID, title, author, publisher, and price.
Columns:
book_id: integer (primary key)
title: varchar(100)
author: varchar(100)
publisher: varchar(100)
price: decimal(10, 2)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
eBooks:
This table contains information about the eBooks that the bookstore sells. The
table has columns for eBook ID, title, author, publisher, file size, and price.
Columns:
ebook_id: integer (primary key)
title: varchar(100)
author: varchar(100)
publisher: varchar(100)
price: decimal(10, 2)
Audiobooks:
This table contains information about the audiobooks that the bookstore
sells. The table has columns for audiobook ID, title, author, narrator, file size, and price.
Columns:
audiobook_id: integer (primary key)
title: varchar(100)
author: varchar(100)
narrator: varchar(100)
price: decimal(10, 2)
E-R Diagram