LSP4YOU - Learner's Support Publications

DBMS BCA Unit-4 Theory of Normalization Need of Normalization Constraints Relational State Redundancy of Data Update, Insert, Delete Anomalies Functional Dependance Decomposition First Normal Form (1NF) Second Normal Form (2NF) Dependency Diagram - 2NF Now Relation is in 2NF Student Relation 2NF to 3NF Student Relation 2NF to 3NF Continue Dependency Diagram - 3NF Third Normal Form (3NF) BCNF with Example Dependency Diagram - BCNF Normalization Data Redundancy Update Anomalies Desirable Decomposition Functional Dependency Process of Normalization Unnormalized Form First Normal Form (1NF) UNF to 1NF Second Normal Form (2NF) 1NF to 2NF Third Normal Form (3NF) 2NF to 3NF BCNF 3NF to BCNF Normalization Process Example Normalization - Functional Dependencies Database File Indexing Techniques Types of Single-Level Ordered Indexes Primary Indexes Clustering Indexes Secondary Indexes

Secondary Indexes

A Secondary Index is an ordered file with two fields. The first is of the same data type as some nonordering field and the second is either a block or a record pointer.

If the entries in this nonordering field must be unique this field is sometime referred to as a Secondary Key.