Exam 98-364: Database Fundamentals/Understanding Data Storage

From Wikiversity
Jump to navigation Jump to search

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

Activity 1 - Understand Normalization[edit | edit source]

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[edit | edit source]

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[edit | edit source]

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.

References[edit | edit source]