Normalization - Solved exercises Home

Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? / Sets of examples to find the keys of a tables / Process of finding Key in a database - Examples

INSERT, DELETE, MODIFY Anomalies Identification

• Identify the anomalies present in the given relational table

Primary key / Candidate key identification

• SET 1 - What functional dependencies are hold?

• SET 2 - What functional dependencies are hold?

• Find all the candidate keys 

• Find all the candidate keys - One more method - Solved exercise 

• Find all the candidate keys - Exercise

   

 Primary key / Candidate key identification

• SET 1 - Finding key of a given relation

• SET 2 - Finding key of a given relation

• SET 3 - Finding key of a given relation

• SET 4 - Finding key of a given relation

• SET 5 - Finding key of a given relation

• SET 6 - Finding key of a given relation

• SET 7 - Finding key of a given relation

• SET 8 - Finding key of a given relation

  ads.click()
  Normalization Solved Exercises

• SET 9 - Finding key of a given relation

• SET 10 - Finding key of a given relation

• SET 11 - Finding all candidate keys of a table

  Normalization

• SET 1 - Normalizing upto 3NF - User table

• SET 2 -Normalizing upto BCNF

• SET 3 -Normalizing upto BCNF 2

• SET 4 -Normalizing upto BCNF 3

• SET 5 -Normalizing upto BCNF 4

• SET 6 -Normalizing upto BCNF 5 

• SET 7 - Is this relation in 2NF?

• Exercise 8 - Normalize the table to 3NF

• Exercise 9 - Normalize the table to 3NF

• Exercise 10 - Normalize the table to BCNF

• Exercise 11 - Normalize the table to BCNF 

• Exercise 12 - Normalize the table to 3NF 

Find the functional dependencies that violate a normal form

• Exercise 1 - FDs that violate BCNF 

• Exercise 2 - Find FDs, Keys, and normalize to 3NF

Normalization Solved Questions

• Solved questions - Simple

Decomposition - Lossy or lossless

• Decomposition exercise 1 
• Decomposition exercise 2
• Decomposition exercise 3
•  

Equivalent Functional Dependencies

• Find whether sets of FDs are equivalent or not 01

• Find whether sets of FDs are equivalent or not 02

• Find whether sets of FDs are equivalent or not 03

normalization solved exercises

how to normalize a relation to second normal form (2nf)
how to normalize a relation to third normal form (3nf)
how to normalize a relation to Boyce-code normal form (BCNF)
find minimal cover
find canonical cover
lossless and lossy join decomposition
find candidate keys and super keys
what is candidate key
find functional dependencies
transitive functional dependency
armstrong's axioms