What is DBMS? List and explain on applications of DBMS.
[5 marks]Explain the Cartesian Product operation in relational algebra.
[5 marks]Explain Two Phase Commit Protocol in detail.
[5 marks]Differentiate Data Administrator and Database Administrator.
[5 marks]Explain different aggregate functions with examples.
[5 marks]Compute the closure of the following set Fof functional dependencies for relation schema R = (A, B, C, D, E, F). F = (A → B, A → C, CD → E, CD → F, B → E)
[5 marks]Explain Mapping Cardinality in detail.
[5 marks]What is normalization? List out the different forms of normalization. Explain anyone with an example.
[5 marks]Describe and explain ER-Diagram with its notations.
[5 marks]Differentiate shared lock and exclusive lock in lock-based protocol.
[5 marks]Explain SQL, DML, DDL, DCL, DQL.
[5 marks]What is serializability? Explain view Serializability.
[5 marks]What is System Recovery? Explain it in detail.
[5 marks]Explain Query Processor with a neat and clean diagram.
[5 marks]Explain cursors with its types.
[5 marks]Explain stored procedures in detail.
[5 marks]Describe Join operation in Query Processor.
[5 marks]