Table for restaurant

[chanlongs]

I'm beginner in database.I want to create a database for manage stock of beer in restaurant, when receive from order it update to stock and sale all so. In restaurant have food , beer ..
How should i do for design table for?

[maximus]

Hi i am maximus I work as a database administrator and designer. i have seen what you want can design it for you if i get some more details like:

more information regarding the products that you are selling. e.g. beer do have different brands or only one. e.g food can be categorised too like snaks, main courses so on so if you provide some more details i will do it for you and completely free thanx.

[maximus]

does any body require a database to be build please let me know i will do it for u

[chanlongs]

Hi i am maximus I work as a database administrator and designer. i have seen what you want can design it for you if i get some more details like:

more information regarding the products that you are selling. e.g. beer do have different brands or only one. e.g food can be categorised too like snaks, main courses so on so if you provide some more details i will do it for you and completely free thanx.

sorry i am late to reply to you.
we have different brands(beer like tiger beer, heineshi).
now i have one problem,i have counter that has 15 chairs, and when someone has 3 people come to sit, i want to give only one bill and the chair that their sit can't select until they paid.

[maximus]

Well I have gone through your requirements and can suggest the following Solution:-


Create Tables


Create Table category (CatagoryID{Primary Key, Auto Number},Catagory)


Create Table items (ItemID{Primary Key, Auto Number},Items,CatagoryID{Linked to CatagoryID in the category table using the lookup wizard,Price,Description)


Create Table Table_des(TableID{Primary Key, Auto Number},TableNO, Table_Des{e.g Counter,Two Seater, Three Seater, Four Seater}, No_seats{must be a number field to record the maximum no of chairs in the table})


Create Table Bill(BillID{Primary Key, Auto Number},Date{Set Default value to Date()},TableID{Linked to Table_des use lookup wizard},Chair1,Chair2,Paid{Yes/No})


Create Bill_items(Record_id{Primary Key, Auto Number}


this will help to solve the problem of the data structure but to record bills u need to add constraints in your data entry form. I will upload a database for you on friday 22/08/2009 DD/MM/YYYY.

[chanlongs]

Thank for your reply.

Can you analyst my table,I have table like this:

tblcategory (categoryid,name)

tblbeer (beerid,name,qtyonhand,price,categoryid)

tblfood (foodid,name,price)

tblinvoice (invoiceno,date,tableno or {chair (counter)})

tblinvoicedetail (invoiceno,foodid and beerid,qty,price)

tblpurchasedetail (beerid,purchaseno,qty,price)

tblpurchase (purcahseno,date,invoiceno,supplierid)

tblsupplier (supplierid,name,phone,address)

tblreceivedetail (beerid,receiveno,qty,price)

tblreceive (receiveno,purchaseno,date)

i do like this because i want to update stock tblbeer. what do you think?