Q1. Illustrate the term DBMS? Write down the merits and demerits offered by such systems as compared to the file processing systems? Describe.
Q2. Describe the different levels of abstraction in the DBMS with the help of a diagram. Explain why do we require mappings between various schema levels?
Q3. Distinguish between the DBMS and RDBMS.
Q4. Describe the distinctions between the words primary key, candidate key and super key. Write down some appropriate illustrations.
Q5. Define with illustrations, the Relation and Relation Schema.
Q6. Describe the general syntax of SELECT command.
Q7. Write down the properties of a transaction which are enforced by the concurrency control and recovery methods of DBMS?
Q8. The following set of functional dependencies on schema R (A,B,C,D,E,F,G)
A → B,
ABCD → E,
EF → G,
Determine if ACDF → G holds on R.