Database Management System · Unit 5
Normalization and Database Design
Exam-focused notes for Normalization and Database Design (Database Management System, BIT202): what the TU syllabus asks and how it has actually been tested, with 6 solved past questions from this unit.
What this unit covers
- Normalization purpose and need
- Functional dependencies
- First normal form
- Second normal form
- Third normal form
- Quality measures for relational schema design
Normalization purpose and need
Why is normalization required? Define 1NF, 2NF and 3NF with suitable examples.[10]
--- Normalization is the process of organizing a relational database to reduce data redundancy and improve data integrity by decomposing large, poorly structured tables into smaller, well-structured ones. Consider the following unnormalized table: StudentID...
Full solved answer →Why normalization is needed in database design? Describe third normal form with an example. [5]
--- Normalization is the process of organizing a relational database to reduce data redundancy and improve data integrity. It is needed because poorly designed tables suffer from the following problems (called update anomalies): Anomaly Description ------ I...
Full solved answer →Second normal form
What is Normalization? Explain the 2NF with Examples. [5]
Normalization is the process of organizing the attributes and tables of a relational database to minimize data redundancy and improve data integrity. It involves decomposing a large table into smaller, well-structured tables and defining relationships betwe...
Full solved answer →What is normalization? Explain 2NF with example. [5]
Normalization is the process of organizing the attributes and tables of a relational database to reduce data redundancy and improve data integrity. It involves decomposing a large, poorly structured table into smaller, well-structured tables while preservin...
Full solved answer →Quality measures for relational schema design
What is a functional dependency? What are the four informal measures of quality for relational schema design? Explain.[10]
--- A functional dependency (FD) is a constraint between two sets of attributes in a relation. It describes the relationship between attributes in a relational schema. Formally, a functional dependency is denoted as: $$X \rightarrow Y$$ This is read as "X f...
Full solved answer →Third normal form
What is Functional Dependency? Explain 3NF with Examples. [5]
--- A functional dependency is a constraint between two sets of attributes in a relation. If attribute B is functionally dependent on attribute A, then for each value of A, there is exactly one corresponding value of B. Notation: A → B (A functionally deter...
Full solved answer →Make Unit 5 stick
Practice BIT202 with flashcards & quizzes