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.
