Responsive image

Database Management System - DBMS for BCA

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.