資料庫管理正規化 >< - 考試
By Edith
at 2013-01-10T23:06
at 2013-01-10T23:06
Table of Contents
請問下列符合第幾正規化?
(1)
----
| ↓
A | B 答案:3NF,BCNF
(2) -----
| |
--- |
| | ↓
A | B | C 答案:3NF,BCNF
(3)
----------
| | |
--- | |
| | ↓ ↓
A | B | C | D 答案:3NF,但不符合BCNF
↑ |
---
(4)
----------
| | |
--- | |
| | ↓ ↓
A | B | C | D 答案:2NF
| ↑
----
第(3)跟第(4)我覺得有問題,
(3) (A,B) -> C
C -> B
這樣不是遞移相依嗎?
所以我覺得應該是2NF @@"
(4) (A,B) -> C
B -> C
這樣不是部分功能相依嗎?
所以我覺得是1NF
請各位替我解惑!
順便請各位大大推薦一下資料庫的書籍 我覺得我快要被老師搞混了 :s
(實作希望不要是Excel的 @@" )
--
Tags:
考試
All Comments
By Susan
at 2013-01-15T05:20
at 2013-01-15T05:20
By Joe
at 2013-01-19T18:12
at 2013-01-19T18:12
By Olive
at 2013-01-23T19:01
at 2013-01-23T19:01
Related Posts
初等公民 2題
By Vanessa
at 2013-01-10T22:46
at 2013-01-10T22:46
法學大意題目怎麼做都無法破90分
By Frederica
at 2013-01-10T22:31
at 2013-01-10T22:31
考IELTS口說如何準備?
By Genevieve
at 2013-01-10T22:10
at 2013-01-10T22:10
小弟成立的免費線上測驗網站
By Olga
at 2013-01-10T21:50
at 2013-01-10T21:50
警特與警專...
By Frederic
at 2013-01-10T21:16
at 2013-01-10T21:16