数据库系统概念中文课件第7章).pptVIP

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */137 3NF (Cont.) cp180 Example R = (J, K, L), F = {JK ? L, L ? K} Two candidate keys: JK and JL R is in 3NF 已经是3NF JK ? L JK is a superkey 州官点的灯 L ? K K is contained in a candidate key 点到州官家里的灯 BCNF decomposition has (JL) and (LK) BCNF把J和K分开了 所以不保持依赖 JK ? L BCNF把J和K分开了 ，所以不保持依赖 JK ? L Equivalent to example in book: 书上另一例等价 Banker-schema = (branch-name, customer-name, banker-name) banker-name ? branch name branch name customer-name ? banker-