Unformatted text preview: Chapter 15.7 Query processing: know how to use relational algebra transformation rules to build a query tree and optimize the tree. Chapter 10 Understand and explain update anomalies caused by bad relational design Understand and use the concept of functional dependencies Be prepared to demonstrate the attribute closure procedure. Understand the concepts of 1NF, 2NF, 3NF, and BCNF. Determine if a relation is in one of these forms. Chapter 11 (11.1 only) Understand and demonstrate dependency preservation. Know how to use the lossless join algorithms for 2 relations. Know how to use the lossless join algorithms for > 2 relations. From Dietrich: Chapter 1 and Chapter 2 should be studied as supplemental material to the relational model and the relational algebra topics above....
View Full Document
This note was uploaded on 02/27/2011 for the course CSE 412 taught by Professor Davulcu,h during the Spring '08 term at ASU.
- Spring '08