Wine Dealer management System Project Database Tables

The below added Counter Details MS Access table provides details about item (food, wine), number,  date of purchase, stock details and total quantity of each item for Wine dealer Project.

Counter_Detail
ITem_No	Date	Stock	Qty

 Employee Salary Management MS access database table explains how staff salary calculates, it includes advance taken, advance date, reason for advance, amount paid, remarks, employee number.

Emp_Sal_Det
ADV_Taken	ADv_Date	Reason	Amt_Paid	Remark	Eno	Amt_taken	Fine

 Employee information MS access table explains about how total employee details can be stored in the database. Here Employee name, Employee attendance, dates of joining, employee phone number, employee salary, and others.

Employee_Information
Ename	ET_Add	D_O_J	Remark	Eno	ph_no	E_sal	et_no

 Employee Job table explains you about the employment name, duties, number, duties and amount.

Employee_Job
ET_Name	ET_Duties	Et_no	Et_period	Et_amt

 Employee Expenses Table Below

Expenses
Particular	Date	total_amt	amt_paid

 Hotel Registration MS access table provides total information about the hotel includes Hotel name, place, Licensee number, etc.

H_Registration
H_Name	H_add	H_city	H_state	Licence_No	Type	Remark	Pincode	Ph_No	Fax_No	H_No

 

Hotel_Part_Det
Part_Name	H_Add	Cit	State	Pager_No	Per_Buss	Comment	part_no

Hotel_no	pincode	ph_no	fax_no	Mobile

Item Information table provides item names and numbers.

Item_Information
Item_Name	Item_no

 Item Stock table provides total Item stock, renew items, remarks.

Item_Stock
Item_No	Total_Stock	Re_Level	Remark

Purchase Item table provides item number, bill number, transaction type, transaction date, Total amount.

Purchase_Item
SNo	Item_No	Bill_No	Transe_Type	Paid	Transition_Date

 

Total_Amt	Last_Pay_Date	Check_Cash	order_qty	Receive_qty

 

Shop Information database table below:

Shop_Information
Shop_No	Shop_Name	Owner_Name	Address	Mobile_No	Fax	Remark	ph_no

 Wine dealer information provides below details:

Wine_Dealer_Information
D_COmp_Name	D_Add	City	State	License_No	Mobile_No

 

Pager_No	Fax_No	Remark	D_No	pincode	ph_no

 

Wine Item Order details below:

Wine_Item_Information
Item_No	Item_Name	company_Name	QTY

 Wine Stock details below:

Wine_Main_Stock
T_Stock	DT_Purchase_Ord	Sell_Price	Cost_Price	Remark	I_No	D_NO	BROKAGE

 Download Wine Dealer management System Project Database Tables.