Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    database of hotel

    Hello i have to do a database of an hotel but i need help because it looks wrong and i dont know how to connect the different tables. this is what i have done so far, the names with underlines are keys. I need help because im kind of stuck so any help would be appreciated.


    COSTUMER
    costumerid
    firstname
    lastname
    adress
    email
    phonenr

    STAFF
    staffid
    firstname
    lastname
    socialsecuritynumber
    shift

    ROOM
    roomid
    roomtype

    SALES
    articlenr
    articlename

    DINNERORDERING
    orderingid
    amount
    date

    BOOKING
    bookingid
    costumerid
    roomid
    fromdate
    todate

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    What a invoice table
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Nov 2011
    Posts
    2
    ok i will try and do that, thank you for the help.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    costumer presumably should read customer

    a specific booking will have a specific (agreed) rate which may or may not be the same as the scheduled rate for that room or room type for that period

    Id expect a table of rates
    eg a single night, multiple night, weekend.
    I'd expect rooms to be banded
    ie
    type 1 rates
    type 2 rates

    Id probably want to store the cusotmers credit details for a booking, or against damages / other charges

    Id probably want some form of mechanism to store extra items such as food, drinks, whatever against a customer booking
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •