Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A . The system consist from many branches where each branch has ( brancheID , brancheName ) B . Each item belong to specific category

A. The system consist from many branches where each branch has (brancheID, brancheName)
B. Each item belong to specific category where the category information (categoryID, categoryName )
C. The system contain Items where many items belong to one category only and the item information as follow (Id,ItemName,imagePath,price,TotalQuantity,hasDiscount,percentage,description)
Where the hasdiscount store yes or no and the percentage it will be 0 if has discount is no and value >0 and <=1 if it was yes. While the TotalQuantity has default value 0, and the user cannot add or update its value directly to this column
D. The system contain information about Employees(empId,full name,email,profilePath,job,role,activationStatus) where the role of employee either admin or nonadmin .the admin employee supervise many employees ,the activationStatus either active or not active
E. The system contain information about customer(customerId,full name,email,activationStatus) where the activationStatus either active or not active
F. The each employee and customer has user account which conatin(userId,username,password,activationststus) where the username could be the user email
G. The user could be either and employee or customer or both at the same time
H. Each branch identify its related items that store where the item store in different store and the store has many items add to that each item in stor has the following information(branchTotalQuantity,start_date) that will be used to sell items from each specific stor. Add to that an employee add many items to each store
I. Each customer can buy many invoices in specific date from specific branch where many invoices belong to one branch and themain information of invoice Master as follow(invoiceId,invoice date,invoiceAmount,invoicePaidAmount,isinvoiceclosed) where invoiceAmount is calculated by adding itemtotalcost for each item that burchased by the customer exists in the same invoice ,and the invoicePaidAmount is the price that paid by the customer either for the branch cashier or in the online where if that amount equal to the invoiceAmount then the isinvoiceclosed it will be yes else if its not equal it will be remain no as its default value , isinvoiceclosed=no means the customer still has the ability to add new items to his/her current invoice cart
J. Each invoice master has many items will store in invoiceDetail entity which contain item quantity , price , DiscountPercentage, priceAfterDiscount ) while the items could be sell in many invoices . Note that price and DiscountPercentage will be called from item entity and will not be entered by user , where the priceAfterDiscount it will be auto calculated as the following formula (quantity *(price* DiscountPercentage)), aslo the DiscountPercentage it will be 1 if the value of hasDiscount=no in item table.
after priceAfterDiscount has been calculated then it will be added to the invoiceAmount in the invoiceMaster entity for the same invoice
** not that after the invoice is paid the quantity related to each item must decrease from the total quantity related to item in the branch of related invoice and decrease from the total quantity in item entity also .
K. The items in each branch will be increase by the transaction of employee to each branch
Therefor the employee can add many new entry of items to the store by defining inStorMaster entity which contain (InStoreMaster_Id ,storeDate,) which this entry in inStoreMaster related to specific branch where the branch has many inStorMaster Transaction
L. Each inStorMaster transaction contain many items related to that store which stord in InStoreDetail entity that contain the following information(InStoreDetail Id,quantity) while the item could be store in many inStorMaster related to the same branch
** not that after the new item entery inserted to each InStoreDetail entity the new item quantity will be increase to the item in branch related to inStorMaster , also the total quantity in item entity will be increased .
M.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro SQL Server Administration

Authors: Peter Carter

1st Edition

1484207106, 9781484207109

More Books

Students also viewed these Databases questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago

Question

Do you set targets to reduce complaints?

Answered: 1 week ago