Exam 98-364: Database Fundamentals/Understanding Data Storage

This lesson covers Understanding Data Storage. It looks at normalization, keys and indexes.

Activity 1 - Understand Normalization
This objective may include but is not limited to: understanding the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form.
 * 1) Read Chapter 4: Database Design Principles.
 * 2) Read Database Normalization Tips.

Activity 2 - Understand Primary, Foreign, and Composite Keys
This objective may include but is not limited to: understanding the reason for keys in a database, choosing appropriate primary keys, selecting appropriate data type for keys, selecting appropriate fields for composite keys, understanding the relationship between foreign and primary keys.
 * 1) Read PRIMARY KEY Constraints.
 * 2) Read FOREIGN KEY Constraints.

Activity 3 - Understand Indexes
This objective may include but is not limited to: understanding clustered and non-clustered indexes and their purpose in a database.
 * 1) Read Tables and Index Data Structures Architecture.
 * 2) Read Indexes.