A Schema in 3NF means it is already in 2NF and there are no transitive dependencies

Explain any 4 reasons why you need Authorization in DBMS

Explain the anomalies that could manifest in transaction processing with suitable example for each.

Query plan generation and optimization is an iterative process

Describe any 4 concepts associated with Distributed Database systems

Role of a DBA ends when he/she sets up the database

OLAP databases are not necessarily in normalized form

Explain any 4 roles of a DBA   in one or two lines each

List at least 3 other database systems apart from Relational DBMS.

Write their purpose in 2-3 lines each.

Explain the concept of Transaction Processing in a DBMS 

- What is a transaction? Why do you need them?

- How does DBMS handle transactions?

- What is a Schedule ?

- What is 2-Phase Locking protocol