Q1. Write down the difference between the Database system and the File system.
Q2. In brief describe the Heuristics based optimization.
Q3. Define the term Super key, Candidate key, Primary key and the foreign key.
Q4. List out at least two reasons why database systems support data manipulation by using a declarative query language such as SQL, rather than just providing a library of C or C++ functions to carry out the data manipulation.
Q5. Represent the natural join operation of relational algebra as a combination of the Cartesian product, selection and the projection operation.
Q6. Define the term domain integrity constraint, entity integrity constraint and the referential integrity constraint.
Q7. Define the term data independence. Distinguish between the logical and physical data independence.