Summary
Liberty Bookstore gives you an online shopping for your desired books. Online shoppers can browse and purchase books via the book storewebsite or via Buy Now links for individual items embedded on other sites. The book sales can be handled using cash on delivery. On the back end, you can oversee stock and process online requests.
Conceptual Model
Stakeholders
- Bookstore Admin:Bookstore Admin gives a book and orders read/write access to all components of Bookstore, including settings. You'll need this role in order to set up Bookstore, together with Financial Admin to set up the Chart of Accounts.
- Bookstore Customers:Bookstore gives a user the ability to run day-to-day operations in Liberty Bookstore—processing orders (Online) and viewing reports. They do not have access to Bookstore Settings.
Business Rules:
- History of book purchases would be maintain like information is recorded that on which date book is purchased and how many items are remaining of that purchases.
- Order List will be maintain against unique id.
- Each order unique list id contains the information about quantity, price and no of books that purchases.
- Employees of the bookstore are responsible to manage the assign order details for example when order is delivered to the customer and also cash on delivery detail would be maintain by the employee.
- This is an online book store that handles order only online.
- There is cash on delivery system.
- Order could be cancel by the customer within 2 days.
- Delivery of the order would be handled by third party.
- Randomly orders are assigned to the employee of the online book store.
- Customer can order multiple item in one order list but he/she would not be able to place another order until the previous order list is delivered and cash is received from the customer.
Online Book Store Management System Harvard Case Solution & Analysis
Entity Relationship Diagram
Data Dictionary
Customer:
cus_id:CustomerID representsPrimary Key, data type is int
cus_firstname: Customer First Name, data type is varchar(255)
cus_lastname: Customer Last Name, data type is varchar(255)
cus_contactNo: Customer Contact Number, data type is varchar(15)
cus_email: Customer Email Address, data type is varchar(255)
cus_address: Customer Address, data type is varchar(255)
Orders:
ord_id:Order ID represents Primary Key, data type is int
cus_id:Customer ID represents Foreign Key from Customer Table, data type is int
order_date:Order Date, data type is datetime
order_status:Order Status, data type is varchar(20)
Order_Detail:
od_id: Order Detail ID represents Primary Key, data type is int
ord_id: Order ID represents Foreign Key from Orders Table, data type is int
quantity:Order Quantity, data type is int
price:Book Order Price, data type is int
bok_isbn:International Standard Book Number represents Primary Key, data type is varchar(13)
emp_id: Employee ID represents Foreign Key from Employee, data type is int
Category:
cat_id: Category ID represents Primary Key, data type is int
cat_name:Category Name, data type is varchar(255)
Author:
aut_id:Author ID represents Primary Key, data type is int
aut_firstname:Author First Name, data type is varchar(255)
aut_lastname:Author Last Name, data type is varchar(255)
aut_contactNo:Author Contact Number, data type is varchar(15)
aut_email:Author Email Address, data type is varchar(255)
aut_address:Author Address, data type is varchar(255)............
This is just a sample partical work. Please place the order on the website to get your own originally done case solution.
