අන්තර්ගතයට යන්න
mcqdinethlive

Unit 8, Database Management

8.7 Normalization

This lesson focuses on Database Normalization to optimize database design and performance. It explains how to systematically organize tables to reduce data redundancy and eliminate anomalies such as insertion, update, and deletion errors. The lesson covers various functional dependencies and the structured transition from Zero Normal Form (0NF) up to Third Normal Form (3NF).

ප්‍රධාන සංකල්ප

Normalization
The process of structuring a relational database in accordance with a series of normal forms in order to reduce data redundancy and improve data integrity.
Anomalies
Inconsistencies or errors that occur in unnormalized databases during data operations, specifically categorized as Insertion, Update, and Deletion anomalies.
Functional Dependency
A relationship between attributes in a table where the value of one attribute uniquely determines the value of another attribute.
Full Functional Dependency
A state where a non-prime attribute is functionally dependent on the entire composite primary key, rather than just a part of it.
Partial Dependency
A condition where a non-prime attribute is functionally dependent on only a part of a composite primary key.
Transitive Dependency
An indirect functional dependency where a non-prime attribute depends on another non-prime attribute, which in turn depends on the primary key.
Zero Normal Form (0NF)
An unnormalized database table configuration containing multi-valued attributes, repeating groups, or lack of defined keys.
First Normal Form (1NF)
A relation in which the intersection of each row and column contains atomic (indivisible) values only, eliminating repeating groups.
Second Normal Form (2NF)
A relation that is already in 1NF and contains no partial dependencies, meaning all non-prime attributes are fully functionally dependent on the primary key.
Third Normal Form (3NF)
A relation that is already in 2NF and contains no transitive dependencies, meaning non-prime attributes depend only on the primary key.

MCQ කට්ටල

MCQ 12

විභාගයේදී

  • Identifying redundancy and database anomalies in a given unnormalized table.
  • Defining types of functional dependencies (Full, Partial, Transitive) with examples.
  • Step-by-step normalization of a given raw table (0NF) to 1NF, 2NF, and 3NF, drawing the resulting database schemas and indicating primary and foreign keys.