1) Explain what is the data dictionary? Explain about the information that are stored in the data dictionary?
2) Write differences between the stored and the derived attributes.
3) Explain the facilities which are available in the SQL for Database recovery?
4) Explain what do you understand by the referential integrity? Describe with the help of example.
5) Explain what is meant by the embedded SQL? Specify the benefits of the embedded SQL programs?
6) Write down the Tuple relational calculus expression for determining the number of the employees working within the Sales department in the given relation
Employee. Employee (SSN-No, Name, Department)
7) Explain the condition when the functional dependency is said to be the trivial?
8) Define the term: “Canonical cover”.
9) Explain about the object oriented databases? Specify some of its characteristics.
10) Explain the chief difference between the read-only and update methods?