Responsive image

Unit 4: Normalization and Indexing Structures for Files

Unit 4: Normalization and Indexing Structures for Files(15 hrs.)

Normalization: Informal Design Guidelines for Relational Schemas - Functional Dependencies - Normal forms : First Normal Form, Second Normal Form, Third Normal Form - General Definitions of Second and Third Normal Forms - BCNF.

Indexing Structures for files: Types of Single-Level Ordered Indexes: Primary Indexes, Clustering Indexes, and Secondary Indexes.