Unit 3: Database Design and Normalization previously asked questions

  1. Write a short note on decomposition.
  2. Write a note on Normalization.
  3. What do you mean by lossless join? Explain.
  4. What do you mean by dependency preservation?
  5. Define Functional Dependency ? What do you mean by Lossless Decomposition? Explain with a suitable example how functional dependencies can be used to show that decomposition are lossless.
  6. What is functional dependency? Explain its role in database design. Describe the inference rules for functional dependencies.
  7. Write the process of normalization.
  8. Define Normal forms. List the definitions of First, Second and Third normal forms.
  9. Define and explain BCNF. How it is more strict than 3 NF?
  10. Explain 4th normal form. When it is violate. Why it is useful?
  11. What do you mean by soundness? Prove soundness of inference axioms for functional dependencies.
  12. Differentiate between full functional dependency and partial functional dependency.