Question
Download Solution PDFThe process to properly define the database tables to provide flexibility, minimized redundancy and data integrity is called ______
This question was previously asked in
HTET PGT Official Computer Science Paper - 2016
Answer (Detailed Solution Below)
Option 3 : Data normalization
Free Tests
View all Free tests >
HTET PGT Official Computer Science Paper - 2019
4.5 K Users
60 Questions
60 Marks
60 Mins
Detailed Solution
Download Solution PDFNormalization is used for Eliminating redundant(useless) data and Ensuring data dependencies.
First Normal Form (1NF)
- It should only have a single value for attribute and values stored in it should be of the same domain
- All the columns in a table should have unique names.
Second Normal Form (2NF)
- It should be in the First Normal form.
- It should not have Partial Dependency.
Third Normal Form (3NF)
- It is in the Second Normal form.
- it doesn't have Transitive Dependency.
Boyce and Codd Normal Form (BCNF)
BCNF is an Advance version of the 3NF
- The relation must be in 3rd Normal Form
- and, for each functional dependency ( X → Y ), X should be a super Key.
Fourth Normal Form (4NF)
- It is in the Boyce-Codd Normal Form.
- it doesn't have Multi-Valued Dependency.
Last updated on Jul 12, 2025
-> HTET Exam Date is out. HTET Level 1 and 2 Exam will be conducted on 31st July 2025 and Level 3 on 30 July
-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.
-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.
-> Enhance your exam preparation with the HTET Previous Year Papers.