1) Explain why you would choose the database system in place of simply storing data within the operating system files? Explain when would it make sense not to use the database system?
2) Describe the different relational algebra operations. Explain what are the General Transformation Rules for the Relational Algebra Operations?
3) Describe about the security, authorization and security in the SQL.
4) Describe the domain and tuple relational calculus. Explain in detail.
5) Explain how the Relational Calculus is different from the Relational Algebra?
6) Describe what do understand by the TRC queries and the DRC queries?
7) Explain what is meant by the normalization? Describe the first, second and third normal forms with the help of an example, explaining the benefits of the normalization.
8) Describe about the Armstrong rules on functional dependency and write down the algorithm for computing the functional dependency closure.
9) Write differences between the network and hierarchical model. Describe it with the help of an example?
10) Specify and describe about the Object Oriented Data Model in detail.