database for lodging

[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

 

[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

 

[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

 

[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...

 

[John... Visio MVP]

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

R

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

 

[Arno R]

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...

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

(e-mail address removed)
Indeed, indeed! Hilarious!!


He is switching accounts like a maniac (Maybe he *is* a maniac?)
A while ago he used:
(e-mail address removed)
Last weeks he used:
(e-mail address removed)
Now he is switching from:
(e-mail address removed) and (e-mail address removed) to
(e-mail address removed)


What is he trying to hide ??

Arno R