Scribd
Upload
2 views3 pages

Simple Database Online Bookstore

The document outlines the design and implementation of a simple database-driven online bookstore using Oracle 21c. Key features include user account management, book searching by ISBN or title, and order placement, along with administrative capabilities for managing customer and book data. Both customers and administrators have distinct functionalities to enhance user experience and data management.

Uploaded by

JemilaRazak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views3 pages

Simple Database Online Bookstore

The document outlines the design and implementation of a simple database-driven online bookstore using Oracle 21c. Key features include user account management, book searching by ISBN or title, and order placement, along with administrative capabilities for managing customer and book data. Both customers and administrators have distinct functionalities to enhance user experience and data management.

Uploaded by

JemilaRazak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

A SIMPLE DATABASE-DRIVEN ONLINE BOOKSTORE

Objectives

The objective of this exercise is to design and implement a simple database-


driven online bookstore by using Oracle 21c, an object-relational database,
from group up.

The Main Features

 Searching - the user can search for a unique ISBN (10 characters), a
title and the price
 Confirming orders – the user can create an account to include the total
amount spent on the purchased
 Place an order - the user can create an account including a list of
purchased unique books with an accumulative quantity each

The Customer Features

 Signing up, in and out


Customers can sign up, in and out using multiple browsers, tabs, or
computers
 Searching for books
List a book if its title includes any of the case-insensitive keywords in a
query, where the keywords are separated by spaces. If the query is
empty, list all books. The search results are a list of hyperlinked book
titles, checkbooks, and input fields for quantities
 Purchasing books
After searching, purchase all checked books at the same time. The
quantities and amount in the account are accumulative

Administrator Features

 Listing all data


Display all hyperlinked book titles and customer names. The system
administrator can list all customers, but a customer can only list
her/his hyperlinked name
 Listing book data
List all data of a specific book by clicking on its hyperlinked title
(including an ISM, a title, a price, and a quantity sold)
 Listing customer data
List all data of a specific customer by clicking on her/his hyperlinked
name (including an ID, a name, the titles of the purchased books, an
accumulated quantity for each book, and the total amount spent
User
Administrator
-User ID: Int
-Password: string -Admin ID: Int
-Log in Status: Book
-Password: string
string -Name: string
+verify login() -book ID: Int
-Address: string
-book name:
-Email: string
string
+add member()
-price: float
+add book()
-author name:
+delete book()
string
+delete
-ISBN: string
member()
-image URL:
string
Customer
-Quantity: float
-Cust ID: Int
-Password: string
-Name: string
-Address: string
-Email: string
+register()
+login()

Books Order

-Order ID: Int


-Price: float
-Cust ID: Int
-Quantity: Int
+place Order()
SEARCH

MAIN PAGE SIGN UP, IN

PURCHASE

MANAGE
CART
CUSTOMER

MANAGE ACCOUNT
LOG IN

PLACE
ORDER
LOG OUT

LIST ALL
USER
DATA

LIST BOOK

LIST CUSTOMER

ADMINISTRAT
OR

You might also like