Q1. What do you mean by the term data redundancy? Illustrate the demerits of having redundancy in a database?
Q2. Illustrate the difference between the logical data independence and physical data independence?
Q3. List all the different cases where use of a NULL value would be suitable.
Q4. When a query language is termed as relationally complete?
Q5. Illustrate the difference between the WHERE and HAVING clause?
Q6. Why must NULLs in a relation be ignored as far as possible?
Q7. Illustrate the transaction commit points and why are they significant?