problem 1: What are the different guidelines which require to be taken care of while designing a relational schema?
problem 2: describe update, insert and delete anomalies with the aid of illustrations.
problem 3: Define the term functional dependencies?
problem 4: Describe the inference rules?
problem 5: Describe the concept of multi valued dependency?
problem 6: What does the term un-normalized relation signify to? How did the normal forms build up historically?
problem 7: prepare down all the rules for the normalization and describe with illustration.
problem 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?