Question 1: What are the different guidelines which require to be taken care of while designing a relational schema?
Question 2: Explain update, insert and delete anomalies with the aid of illustrations.
Question 3: Define the term functional dependencies?
Question 4: Describe the inference rules?
Question 5: Describe the concept of multi valued dependency?
Question 6: What does the term un-normalized relation signify to? How did the normal forms build up historically?
Question 7: Write down all the rules for the normalization and describe with illustration.
Question 8: Define first, second and third normal forms when just primary keys are considered. How do the general definitions of 2NF and 3NF, which consider all keys of a relation, distinct from those that, consider just primary keys?