can someone check my relationships

FullAdder · #1 (**permalink**) 01-20-11, 09:09

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

r937 · #2 (**permalink**) 01-20-11, 10:04

Quote:

Originally Posted by FullAdder

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?

corncrowe · #3 (**permalink**) 01-20-11, 11:38

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?

FullAdder · #4 (**permalink**) 01-20-11, 12:28

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?

dportas · #5 (**permalink**) 01-20-11, 18:28

Quote:

Originally Posted by FullAdder

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?

Internet Services

Web Development

Digital Marketing

Consumer Tech