Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Common Properties design

    Matt Miller (1/16/2008)

    It doesn't keep cascading, since cascades flow from parent to child. Since FacilityAddress is a "child" to BOTH Address and to Facility, it's not going to keep cascading,...

    January 16, 2008 at 10:12 am

    #768801

  • RE: Common Properties design

    Loner (1/16/2008)

    I don't understand one thing. You said 'Address' could be used for facility, department of user, so why did you have foreign key to facility table only?...

    January 16, 2008 at 10:00 am

    #768795

  • RE: Common Properties design

    Grant Fritchey (1/16/2008)

    However, what happens if an address is used more than once? Two of the faculty live at the same address (husband & wife), then one leaves (divorce), you...

    January 16, 2008 at 7:20 am

    #768637

Viewing 3 posts - 1 through 3 (of 3 total)

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy