Results 1 to 3 of 3

Thread: ER Model

  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: ER Model

    Hi,

    I have created an ER model of my database, can someone please quickly look over it and tell me if I have done it correctly.

    Thank you
    Attached Thumbnails Attached Thumbnails Hotel.JPG  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    is this for an assignment?

    if so, you should probably indicate the primary and foreign keys in each table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2004
    Location
    UK
    Posts
    82
    i think you might need a booking number on the booking table and have this as the primary key.

    i might also add a funtion type table with [ID] as primary key and function type as the field.

    looks good, though i do agree with r937

Posting Permissions

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