Unit 3

Topics

• Normalization Theory and Database methodologies →
• Relation Schemas →
• Functional Dependencies Definition and rules of axioms →
• Dependency preservation →
• Properties and loss less join decomposition →
• Query Processing and Optimization →
• Complexity measures →
• Normal forms 1NF →
• 2NF →
• 3NF and BCNF →
• Various algorithms to implement select →
• project and join operation of relational algebra →