Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009

    Database structure

    Hi everybody!!
    i must create a database for a bed and breakfast!!!!!!
    - there are different types of rooms : family, double & simple
    - In certains rooms, the client can smoke but not in all rooms
    - there is a breakfast on a print car and clients can choose what they want
    - There are different kind of menus : Vegans, vegetarians, nut allergies
    - In menu, we also can find juice, coffee, tea
    - Clients can order menu if there are not expensive
    - For foreign clients, the passeport number must be asked
    - For the booking, clients choose the type of room, type of menu
    - le B&B récompense les fidèles clients

    Table Client (ClientId , FirstName, lastName, Adress, Postal Code, Country, Phone, PaiementId)
    Table Room (RoomNumber, TypeRoom, Price)
    Table BookingRoom(RoomNumber,CLientId, DateBeginning, DateEnd,)
    Table Paiment (PaimentId, Type, Date,)
    Table BreakfastList?
    Table BreakfastClient?
    table Price?? I am not sur

    What do you think about a such database??
    Do you see any problems in this structure?
    anything I should have done differently?
    anything I could do to improve database performance?

    All comments will be appreciated!!

  2. #2
    Join Date
    Jul 2009
    The Room table needs a smoking/non-smoking attribute.
    The Client table needs a passport number attribute.
    Tied to BookingRoom you will need a table that holds what type of menus they have chosen (since multiple people can stay in each room).

Posting Permissions

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