Profile

e-Catalog

Contact

Search

Cart

Normalization and Physical Database Design

Audience

Analysts, programmers, database designers, and database administrators working in a relational environment

Prerequisites

The courses Relational Principles and Database Fundamentals

Course Aim

To describe the process of relational database design using appropriate modeling tools and techniques

Learning Objectives

Use primary and foreign keys. Explain the different types of data integrity. ormalize entities to the appropriate level. Understand the issues of physical database design and database optimization. Show how physical and logical independence at the conceptual level facilitates dynamic database evolution.

Topics Covered

Logical design - Design considerations - Primary and foreign keys - Exercise: Using keys - Data integrity The process of normalization - Normalization and 1NF - Partial dependency and 2NF - Transitive dependency and 3NF - Exercise: Normalizing data - Boyce-Codd Normal Form Performance and physical design - Optimization - Data allocation Database independence - File-based independence - Logical and physical independence