返回列表 發帖

Database Systems Design, Implementation, and Management

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

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

TOP

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

TOP

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?

TOP

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.

TOP

Ya, but think in real application, they should not be FK to the same address 'cause what if o ...
ACC-HE 發表於 2012-2-10 17:19



    oh ya true!!!! ah ha!

TOP

In real application, it's 1:M.
Prelude 發表於 2012-2-10 17:15



    but as ACC-HE said...it does make sense though

TOP

if not SQL, then NoSQL?

回復  rainbow-davie
yuusaku 發表於 2012-2-10 18:50



haha...but anyways I'm still studying the I guess this is still called the theory part.  SQL starts next week but I have a project to hand  in

TOP

返回列表