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$.$

Extra requirement

$1-$ Based on the proposed specification Design the conceptual data model $($ERD$)$ with its related Logical data model $($database schema$)$ after applying the mapping algorithm, then create the physical data model based on Oracle $11$g DBMS