- Write a short note on decomposition.
- Write a note on Normalization.
- What do you mean by lossless join? Explain.
- What do you mean by dependency preservation?
- 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.
- What is functional dependency? Explain its role in database design. Describe the inference rules for functional dependencies.
- Write the process of normalization.
- Define Normal forms. List the definitions of First, Second and Third normal forms.
- Define and explain BCNF. How it is more strict than 3 NF?
- Explain 4th normal form. When it is violate. Why it is useful?
- What do you mean by soundness? Prove soundness of inference axioms for functional dependencies.
- Differentiate between full functional dependency and partial functional dependency.
What did you think?