Programming question .?

Question

This is for a school project. Im using Visual Basic and Microsoft Access to store details. Im thinking of designing a hotel system where you can book rooms and so on. The problem is im not sure on how to do the room aspect, do i write the rooms from (say if there are 200 rooms in the hotel) 1 to 200 and put he status on 'Free' wouldent that be wasting space? any other methods !?

thanks loads.

Answer 1

You're on the right track. The yes/no switch would be vacant / reserved / occupied.

Answer 2

hi,
There should be a Room Master form in ur s/w. This form should get room description like Room No, Room Size, Category, Rate, etc. Create a table in database to store this info from master and should has a field status for vacant/Occupied. If occupied then details of customer can store in a different table with the relationship of forienkey of roomid.
Each form in ur s/w should hv facility to add, delete, edit, find, and Print a report for a given criteria.
Add 1-200 rooms in room master and use these rooms for transactions.

Answer 3

Hi,
I feel you need to create a master table of rooms, with a primary key of room no, which should proivde details like no of beds in a room, AC/Non AC, Net Available, Type of Room Luxury / non Luxury etc. This should answer your concern

Nag
(Dont trouble the trouble until the trouble troubles you)

Answer 4

.Good project I am starring your question. Are all the rooms the same size and cost. If not try putting them into size and cost categories. (single, double, suite, etc...) Then you need to decide how far in the future you want your program to go 1 week, 1 month, 1 year, etc... GOOD LUCK

Answer 5

software has grow to be the conventional for computing. Programme is the unique British spelling - the two could be utilized by potential of human beings - different than that bill Gates' spellchecker will stop you.

Answer 6

that would be the thing...may be u can present each room with an icon along with their status and other information.