Explain the architecture of DBMS and describe the main components.
Differentiate between DBMS and traditional file systems. Explain how DBMS offers data independence with examples.
Draw and explain an ER diagram for a Hospital Management System with entities like Patients, Doctors and Appointments, including relationships and constraints.
Describe different types of relational keys. What is the importance of primary and candidate keys in relational databases?
Write SQL queries to perform the following tasks on a student database:
i) Retrieve all students who scored above 85 in Mathematics.
ii) Find the names of students who are enrolled in both Math and Science courses.
Define triggers in SQL. Write a trigger that updates the total order amount in an "Orders" table whenever a new order is added in an "OrderItems" table.
Define functional dependencies with examples. Explain the importance of functional dependencies in achieving database normalization.
Normalize the following relation to 2NF and 3NF: Employee(SSN, EmpName, DeptID, DeptName, DeptLocation, ProjectID, ProjectName)
Define deadlock in the context of databases. Describe one technique each for deadlock prevention, detection and resolution.
Discuss two-phase locking protocol. Explain its role in maintaining serializability in concurrent transactions.
Differentiate between serial and non-serial schedules. Test if the following schedule is serializable or not: T1 : R(X), W(X), R(Y), W(Y) T2 : R(X), R(Y), W(Y) T3 : R(Y), W(X)
Explain the purpose of indexing in database. How does a primary index differ from a clustering index?
Describe the different phases of query processing in DBMS. How does query optimization contribute to the efficiency of database systems?
Given a database of student records, explain how a hash function can be used for quick data retrieval.
Write short notes on (any two):
i) Relational integrity constraints and their importance in databases
ii) Entity-Relationship (ER) model
iii) Lossless Join and Dependency Preserving Decomposition
iv) Serializability and its types
