Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2010
    Posts
    37

    can someone check my relationships

    Can someone check my relationship and suggest if they are correct. Please do not comment on the design just the relationship.

    http://img833.imageshack.us/img833/1504/webaudfinal.jpg

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by FullAdder View Post
    Can someone check my relationship and suggest if they are correct.
    can't tell, not without a clear indication of the FKs

    presumably the PKs are the underlined ones? why are some columns underlined and others bolded?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    I believe the ones in bold are fk's? Looks ok (disclaimer). What is your db defined as? A property db? What does the branch table respresent? How would you summarise this database?

  4. #4
    Join Date
    Oct 2010
    Posts
    37
    underline = pk
    bold = fk

    this is a real estate database. the branch represents a office

    can you check whether the 1.* and 1.1 relationships are correct?

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by FullAdder View Post
    underline = pk
    bold = fk

    this is a real estate database. the branch represents a office

    can you check whether the 1.* and 1.1 relationships are correct?

    Only one viewing per client? No key for branch or registration?

Posting Permissions

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