BCA Database Management System

Explain physical data independence and logical data independence.

What is data model? What are its types?

Describe DDL and DML queries with example. Explain database system architecture.

What is normalization? What are its advantages? Describe its types with appropriate examples.

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 laundary service.

e) Give 10% discount to female guests on the price of service they receive.

What is stored procedure? Describe statement level trigger and multi row enabled triger?

Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.

Define query processing and steps in query processing.

Define transaction. Describe ACID properties with example.

Define schedule and serializability with example. How can you test the serializability?