ACC-HE

shouldn't be too hard.  PK, FK, 1st, 2nd, 3rd normal form, usually in SQL Server?

ACC-HE

depends.

but 1:1 seems ok.

ACC-HE

1:1 seems ok but I mentioned 1:M because what if the students live together in the same address t ...
et1984 發表於 2012-2-10 17:10

    Ya, but think in real application, they should not be FK to the same address 'cause what if one of them changed his address? then you're changing his roommate's address too.