database exam questions thx

用戶132831

2007-05-08 10:21 pm

database

1)Hierarchical Database Model
Network Dasebase Model
Relational Database Model
呢3個model有咩好重要ge野要記住的?ex好處與壞處?

2)data security & recoevery
裡面ge checkpoint點解?
係咪=auto save?

3)最難就係唔明以下呢d
1NF: first normal form
2NF: second normal form
3NF: third normal form
裡面又提到full dependency...partial dependency...transitive dependency 都唔太明白

4)components of dasebase design =steps in data modeling ?
我見佢地d steps都幾似

回答 (1)

用戶4673

2007-05-08 10:44 pm

✔ 最佳答案

參考以下文章, 個人認為首先要了解了三種model的結構, 便能知道其好處與壞處, 而現時的資料庫, 都會使用rdm的, 當然進階的就是oodm (object oriented database model).
http://www.databasejournal.com/sqletc/print.php/26861_1428721_3

參考以下文章, 雖然是oracle所使用, 但理念是一樣,
http://www.akadia.com/services/ora_checkpoint_tuning.html

參考以下文章,
http://www.phlonx.com/resources/nf3/

可以這樣說, 個人認為不太會問這些無聊東西.

參考: me

👍 0 👎 0