Q1. Illustrate the term DBMS? prepare 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. describe 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. prepare down some appropriate illustrations.
Q5. Define with illustrations, the Relation and Relation Schema.
Q6. Describe the general syntax of SELECT command.
Q7. prepare 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.