How to create restaurant table in access?

Asked By Emaily Rawa 10 points N/A Posted on - 11/19/2012

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.

• Status: Open
• Question Views: 787
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Toni Linscomb 5 points N/A #179531

How to create restaurant table in access?

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]

About Toni Linscomb

Questions
0

Answers
197

Best Answers
86

• Vote Up 0 Vote Down

• Posted on - 11/20/2012
• Question Category: MS Access