Define transaction. Describe ACID properties with example. [1+4]
Explain physical data independence and logical data independence. [2.5+2.5]
What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]
Define schedule and serializability with example. How can you test the serializability? [2+3]
What is data model? What are its types? [1+4]
Define query processing and steps in query processing. [1+4]
Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.
Attempt any TWO questions
[2x10=20]Describe DDL and DML queries with example. Explain database system architecture. [3+7]
What is normalization? What are its advantages? Describe its types with appropriate examples. [2+2+6]
Consider the following schema:
Guest (Gid, Gname, Age, Gender)
STAFF (Sid, Sname, Age, Gender, Roles)
SERVICE (serId, serName, Price)
ASSISTS (Gid, Sid) (Which staff assists which guest)
PROVIDES (serId, Sid) (Which staff provides which service)
Write SQL Queries:
a. Find name of guests who are VIP.
b. Find total number of guests assisted by staff Ram.
c. Find name of staff whose name starts with A and ends with A.
d. Display name of staff who provides laundry service.
e. Give 10% discount to female guests on the price of service they receive. [3+2+2+1+2]