Normal Forms I

Preparation

Fundamentals of Database Management Systems

• Chapter 7: Logical Database Design

Learning Objectives

• Describe the following terms:
  • data normalization
  • functional dependency
• Define the following normal forms:
  • First (1NF)
  • Second (2NF)
  • Third (3NF)
• Create a normalized relational database schema from an entity-relationship (ER) diagram