Vishal Mega Mart
Vishal Mega Mart
Vishal Mega Mart
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)
Recv_qty_in_stock(int) loc_id(int)
qty_out_from_stock(int) street
remaining_stock(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
receive_dt quantity(int)
billing_amount (double)
emp_id
Brn_id
dep_name
sub_dep
TIME$ EMPLOYEE
tim_id(int) emp_id(int)
loc_id(int)
SALARY$
brn_id(int)
emp_id(int)
dep_id(int)
amount(double)