DATABASE ch4 Database Design.ppt

* * * * * * * * 2) Second Normal Form (2NF) A relation R is in second normal form (2NF) if and only if it is in 1NF and every non-key attribute is fully dependent on the primary key. 3) Third Normal Form (3NF) A database schema in Third Normal Form(3NF) did not allow a dependency to be trivial. 4) Boyce-Codd Normal Form?(BCNF) A relation R is in Boyce-Codd normal form (BCNF) if and only if every determinant is a candidate key. 4.3 Normal Forms Relational Schema Design Start with some relational schema Find out its FD’s Use them to design a better relational schema Example of 3NF Decomposit