Q1. Describe the merits of Database Management System over the file system.
Q2. Describe the roles of the database administrator.
Q3. State the term entity, entity set, relationship and relationship set.
Q4. What do you mean by Functional Dependency? Distinguish between the full functional dependency and partial functional dependency.
Q5. Describe the recoverable and cascadeless schedules with the help of an illustration.
Q6. State the 3NF. Decompose the relation SUPPLIER (SNAME, STREET, CITY, STATE, TAX) to 3NF relations for the given set of the functional dependencies.
SNAME → STREET, CITY, STATE,
STATE → TAX,
SNAME → STATE →TAX
Q7. Distinguish between the Tuple Relational Calculus and the Domain Relational Calculus.