Table design with time

  • Thread starter Thread starter Andrew Smith
  • Start date Start date
A

Andrew Smith

Hey, I am new to databasing and I'm trying to design a database for a friend
of the family. He owns a small bed and breakfast and right now his whole
business is on paper. I told him that I would help him put it on the
computer. I have a good idea of what I want on the table, for example: Room
identification, etc. But I do not know how to incorporate the date. For
example, if someone wants to reserve Room A on December 12th. I don't know
how to put the date in the table. Each room needs its own calendar. Can
someone help point me in the right direction with this? Your help will be
very appreciated. Thanks

Andrew Smith
 
But I do not know how to incorporate the date. For
example, if someone wants to reserve Room A on December 12th. I don't know
how to put the date in the table.
Click to expand...

There's a Date/Time datatype you can choose for a field. I'd suggest
having two Date/Time fields, StartDate and EndDate.

Room reservation systems are pretty common, and not trivial to
implement well; you may want to run a search of these newsgroups on
http://groups.google.com to find previous discussions of the issue.
 
Understand that there will be a bit more to this than just "putting it on
the computer"!

For a start, you will need to learn about database design - a whole topic of
its own. Perhaps start here:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

The exact issue of room reservation systems was discussed by me & others, a
few weeks ago. Do some googling, you should be able to find it.

HTH,
TC
 
Back
Top