Database Systems Design, Implementation, and Management course, Design, before

et1984

Anyone studied this course or book before? or maybe now ? ^_^

ACC-HE

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

et1984

hahah....>.<" I guess you are good that's why you said shouldn't be hard I just started it....not into SQL yet but starting with the basic of PK, FK, 1NF, 2NF, 3NF but too much terms that's messing me up hahahah

rainbow-davie

still SQL... omg...  just wondering what programming language does university teaching now?

et1984

still SQL... omg...  just wondering what programming language does university teaching now?
rainbow-davie 發表於 2012-2-9 04:02

I think there should be quite a few programming languages hehe

et1984

Just wondering if I can get some help here.

Between the  current address entity and student entity what's the best relationship between them? 1:1 or 1:M?

ACC-HE

depends.

but 1:1 seems ok.

et1984

depends.

but 1:1 seems ok.
ACC-HE 發表於 2012-2-10 11:17

1:1 seems ok but I mentioned 1:M because what if the students live together in the same address then an address will have one or more students >.<"

actually the part I'm having headache with is the prof is asking us to make the diagram so that students with their pass 10 addresses so if it is 1:M for current address to  students then it'll be M:N for past addresses to students.  But I don't know what composite entity I should use in between past addresses to students.

Prelude

In real application, it's 1:M.

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.