What is DBA? Explain the role and responsibilities of a DBA in a DBMS.
[5 marks]Explain Selection and Projection operations in Relational Algebra with examples.
[5 marks]Explain different aggregate functions with examples.
[5 marks]Draw E-Rdiagram for Library Management System.
[5 marks]How is an entity represented in an ER diagram? Differentiate ate between strong and weak entities.
[5 marks]A What is normalization? List out the different forms of normalization. Explain anyone with an example.
[5 marks]What is Mapping Cardinality? Explain in detail.
[5 marks]Write a short note on Materialized view.
[5 marks]Consider the following relational database schema consisting of the four relation schemas: passenger ( pid, pname, pgender, pcity) agency ( aid, aname, acity) flight (fid, fdate, time, src, dest) booking (pid, aid, fid, fdate) Answer the following questions using relational algebra queries. a. Get the details about all flights from Chennai to New Delhi. b. Get the complete details of all flights to New Delhi. c. Find the passenger names for passengers who have bookings on at least one flight.
[5 marks]Differentiate between shared and exclusive locks in a lock-based protocol. Page 1 of
[2 marks]What is Serializability? Explain Conflict Serializability with example schedules.
[5 marks]Explain SQL, DML, DDL, DCL, DQL.
[5 marks]What is System Recovery? Explain it in detail.
[5 marks]List out and Explain ACID properties of transaction.
[5 marks]What is Data Aggregation? Explain Generalization and Specialization with suitable examples.
[5 marks]What do you mean by transaction? explain the following transaction control commands: Commit, Rollback and Savepoint.
[5 marks]Explain cursors with its types. Page 2 of
[2 marks]