database for lodging

R

Reyna

Hi,

I am trying to set up a database for people going to campsite for the
weekend. I have the client list and info set up. But how do I set up what
cabins they will be staying in? Do I set up a separate table for each cabin
with a list of beds in each cabin?

And how do i set it up so that each bed can only be assigned to one person?

Reyna
 
S

Steve

TblClientID
ClientID
ClientLastName
<Client Fields As Needed>

TblClientMember
ClientMemberID
ClientID
ClientMemberLastName
ClientMemberFirstName
<Client Member Fields As Needed>


TblCabin
CabinID
<Cabin Fields As Needed>

TblBedInCabin
BedInCabinID
CabinID
BedNumber

TblCabinRental
CabinRentalID
CabinID
ClientID
DateStart
DateEnd

TblBedAssignment
BedAssignmentID
CabinRentalID
BedInCabinID
ClientMemberID

Steve
 
R

Reyna

Thank you Steve. I will probably post again. Once I have the tables setup,
I'll be looking for help on ogther issues. : )

R
 
J

John... Visio MVP

Another lousy design by stevie. Nothing was mentioned about membership, but
if it is a requirement, then TblClientID and TblClientMember should be one
table.

Also, you need to clarify your facts before jumping in with a design. Is
Renya concerned about individual bed rentals or making sure that occupancy
does not exceed the cabin's capacity? Are these beds/cabins being rented to
individuals who will share or to families? If a family of four rents a cabin
with five beds, can the fifth bed be rented? You need to check your facts.

John...
 
J

John... Visio MVP

Reyna said:
Thank you Steve. I will probably post again. Once I have the tables
setup,
I'll be looking for help on ogther issues. : )

R
Click to expand...


Be careful working with steve. His only interest is to seperate unknowing
newsgroups poster from their money by providing a less than satisfactory
product.

These newsgroups are provided by Microsoft for FREE peer to peer support and
there are many people who are far more qualified than steve who are more
than willing to help.

Before you go stumbling off and following steve's design, I have a few
comments.

1) The TblClientID and TblClientMember should be one table.

2) Are you concerned about individual bed rentals or making sure that
occupancy does not exceed the cabin's capacity?

3) Are these beds/cabins being rented to individuals who will share or to
families? If a family of four rents a cabin with five beds, can the fifth
bed be rented? You need to check your facts.

These questions will help you get a proper design.

John... Visio MVP
 
A

Arno R

John... Visio MVP said:
Another lousy design by stevie. Nothing was mentioned about membership, but
if it is a requirement, then TblClientID and TblClientMember should be one
table.

Also, you need to clarify your facts before jumping in with a design. Is
Renya concerned about individual bed rentals or making sure that occupancy
does not exceed the cabin's capacity? Are these beds/cabins being rented to
individuals who will share or to families? If a family of four rents a cabin
with five beds, can the fifth bed be rented? You need to check your facts.

John...
Click to expand...

Hi John,
Have you seen the recent account Steve uses?

[email protected]
Indeed, indeed! Hilarious!!


He is switching accounts like a maniac (Maybe he *is* a maniac?)
A while ago he used:
[email protected]
Last weeks he used:
[email protected]
Now he is switching from:
[email protected] and [email protected] to
[email protected]


What is he trying to hide ??

Arno R
 
Top