Normalization Problem Solving

This app is developed by Mrs. Sunita Milind Dol (e-mail ID: [email protected]), Assistant Professor at Walchand Institute of Technology, Solapur.

Topics covered in this mobile app are –

1. Find if a given functional dependency is implied from a set of Functional Dependencies

2. Find Candidate Key using Functional Dependencies Relational Model

3. Find Super Key using Functional Dependencies

4. Find Prime and Non Prime Attributes using Functional Dependencies

5. Check the Equivalence of a Pair of Sets of Functional Dependencies

6. Find the Minimal Cover or Irreducible Sets or Canonical Cover of a Set of Functional

7. Check if the decomposition of R into D is lossless

8. Check whether the decomposition of R into D is preserving dependency

9. BCNF Decomposition

10. Practice Problem for 3NF Decomposition

For each topic, problem statements and answers are provided. Also this app contains the quiz and “Test your knowledge” part.