Q1. Describe the three level schema architectures for DBMS?
Q2. Illustrate the differences between the ROLAP and MOLAP.
Q3. Distinguish between the relationship instance, relationship type and relationship set?
Q4. Prove the statement “A relation in 4NF is as well in BCNF”.
Q5. The projection operation of relational algebra is termed as Redundancy Elimination Operation? Explain why?
Q6. Prove that any relation schema having two attributes is in BCNF.
Q7. Distinguish between the strict and conservative two phase locking protocol.