[考題] 98調查局資料庫
[考題] 國考歷屆考題與考題觀念討論(書裡看到的選這個)請附上想法、出處
請問一下
98年調查局
第一大題第二小題
R2(G,H,I,J,K)
關係如下:
{G,H}->I, {G,H}->J, {G,H}->K, H->G
請問R2不滿足哪個正規化?
看過二種解法:
<解1>
可以推出主鍵為H
不滿足2NF:因為 I,J,K 部分相依於主鍵H
<解2>
可以推出主鍵為H
不滿足BCNF:因為 {G,H} 為非候選
不知道哪一種想法才對
謝謝!!
--
自信是成功的第一要訣
--Self-trust is the first secret of success--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 1.165.121.219
推
06/13 19:14, , 1F
06/13 19:14, 1F
推
06/13 19:18, , 2F
06/13 19:18, 2F
推
06/13 19:55, , 3F
06/13 19:55, 3F
→
06/13 20:42, , 4F
06/13 20:42, 4F
推
06/13 21:06, , 5F
06/13 21:06, 5F
→
06/13 21:26, , 6F
06/13 21:26, 6F
推
06/13 21:27, , 7F
06/13 21:27, 7F
→
06/13 21:29, , 8F
06/13 21:29, 8F
推
06/13 21:56, , 9F
06/13 21:56, 9F
推
06/13 22:00, , 10F
06/13 22:00, 10F
→
06/13 22:08, , 11F
06/13 22:08, 11F
推
06/13 22:11, , 12F
06/13 22:11, 12F
推
06/13 22:15, , 13F
06/13 22:15, 13F
推
06/13 22:16, , 14F
06/13 22:16, 14F
→
06/13 22:18, , 15F
06/13 22:18, 15F
→
06/13 22:19, , 16F
06/13 22:19, 16F
→
06/13 22:21, , 17F
06/13 22:21, 17F
→
06/13 22:22, , 18F
06/13 22:22, 18F
→
06/13 22:26, , 19F
06/13 22:26, 19F
→
06/13 22:27, , 20F
06/13 22:27, 20F
→
06/13 22:29, , 21F
06/13 22:29, 21F
→
06/13 22:30, , 22F
06/13 22:30, 22F
推
06/13 23:18, , 23F
06/13 23:18, 23F
→
06/13 23:31, , 24F
06/13 23:31, 24F
→
06/14 16:16, , 25F
06/14 16:16, 25F