Hi techyv,
How to create restaurant table in access?
I am using Microsoft access as the main database of my restaurant reservation table system using visual basic programming language.
I am not sure on how am I going to arrange those tables.
Can you also give me some overview of all the important categories in the table?
Hoping for your help.
Thanks.
I assume that your application is only focusing on room reservation and you have the basic knowledge on how to create tables in access. Basic database structure should consider the items customer, Room and the bill.
Relationship between above mentioned entities would be as follows
Customer > Room: 1:M
Customer > Bill: 1:1
Room > Bill: M:1
Customer table can have the below fields
[CustomerID],[Name],[NIC],[Address],[FromDate],[ToDate],[Telephone],[Code] ,[Status],[Type]
Room table can have below fields
[RoomID],[RoomNumber],[LocalPrice],[ForeignPrice],[NoOfBeds],[RoomType],[Status],[AssignTo]
Bill table
[BillID],[CustomerID],[RoomID],[Type],[Cost],[Payment],[TimeStamp]
Intermediate table between Customer and Room
[CustomerID],[RoomID]
