How to create restaurant table in access?

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #179531

How to create restaurant table in access?

qa-featured

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]

Login/Register to Answer

Related Questions