Problem statement Workflow

Draw suitable ER$-$diagram for the previous scenario, don't forget to cover

types of attributes, entities and relationships

choose suitable attributes for each entity as you like

Use a participation relationship $($total$-$partial$)$ only if the relationship is $1$:$1$

make sure you cover the scenario in the ER$-$Diagram

Draw the relational schema by Mapping the previous ER$-$diagram

Build your relational schema using SQL server

Build relational schema with DDL without DML

The required constraints are Primary Key and Foreign Key

Daraghmeh is Trading establishment that has several branches around Jordan!

It is selling clothes online by application for the whole family

The branch has numbers of service and packing staff in addition to a manager who is

responsible for the branch and number of cashiers, cleaners and delivery men.

Each branch has multiple departments containing many different products and each

branch has own inventory which has the required products for different departments

that branch needed.

If the quantity of any type of product become low in the inventory, the suppliers

replenish the inventory with required products then service and packing personnel feed

the departments with required!

The cleaner is responsible for cleaning specific department as shift system.

This application will show the available products in each department for each branch,

each product will be under specific category and has a brief description and price.

Any customer can register to the application and put his information like his name, phone

and address and another information.

The customer can purchase many products from the store use the application to request

order from the service and packing staff, after the customer finishes shopping, he pays to

the cashier, and the cashier will give the bill with details to the customer

After that, the delivery man will deliver the order to him

The order consists many products, minimum $5$ products

After the customer finishing, he gives a report or feedback which reaches to the manager

of the branch through the application