Vishal Mega Mart

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Vendor

Purchase

Product
Department
Vishal Mega

Mart

Salary
Customer Sell
epartment

Employee

Salary
SUPPLIER$
sup_id(int)
INVENTORY$ supplier_k
inv_id(int) f_name(varchar 50)
sup_id(int) l_name(varchar 50)

SupProduct_id(int) Email(varchar 20)


SupProd_UnitCost(double) Ph_no(int)

Recv_qty_in_stock(int) loc_id(int)

qty_out_from_stock(int) street
remaining_stock(int)

INVENTORY DETAILS$ stock_location(varchar)

inv_detail_id(int) category SUPPLIED_PRODUCT$


inv_id(int) descrip SupProduct_id(int)

prod_id(int) ord_id(int)
emp_id(int) SupProduct_name
date_id(int) SupProd_UnitCost(double)
quantity (int) quantity(int)

dat_id(int)
loc_id(int)

CATEGORY$ PRODUCT$
cat_id(int) prod_id(int)
cat_name cat_id(int)
sub_category prod_type
prod_name
p_unit_price(double)

supplier_cost(double)
margin
list price

brn_id
LOCATION $ *PK
loc_id(int) *FK
city
state

ORDER_to_SUPPLIER$
ord_id (int)

prod_id(int) CUSTOMER$
sup_id(int) cus_id(int)
quantity(int) f_name

weight(varchar) l_name

height(varchar) PURCHASE$ Email


pur_id(int) Ph_no(int)

prod_id(int) street Billing


ord_id(int) loc_id(int) billing_id(int)
sup_id(int) loc_id(int)
dat_id(int) cus_id(int)
DATE$ tim_id(int) prod_id(int)
dat_id(int) quantity(int) tim_id(int)
delivery_dt pur_amount(double) dat_id(int)

receive_dt quantity(int)
billing_amount (double)

emp_id
Brn_id

Sell amount = unit price of product table * quantity of sell table


cost(double)
Purchase amount = unit price of supplier product * quantity of or

Unit price of Products = supplier product price *30%


DEPARTMENT$
dep_id(int)
brn_id(int)

dep_name
sub_dep

TIME$ EMPLOYEE
tim_id(int) emp_id(int)

full_date BRANCH$ brn_id(int)

day brn_id(int) dep_id(int)


month brn_name f_name

year loc_id(int) l_name


Email
Ph_no(int)
street

loc_id(int)

SALARY$
brn_id(int)

emp_id(int)
dep_id(int)
amount(double)

table * quantity of sell table

pplier product * quantity of order

oduct price *30%

You might also like