What is DBMS and differentiate between DBMS and traditional file Storage System?
Explain different types of data models in DBMS?
State and Explain various features of E-R models?
What are the statements in SQL for destroying and altering tables. Explain with examples?
Discuss about different types of Integrity Constraints?
Write Relational Algebra Queries for the following for (Sailor Database). Sailors(Sid, Sname, Rating, Age), Boats(Bid, Bname, Color), Reserves(Sid, Bid, Day)
i) Find the following id's with age over 20 and who have not reserved a red boat.
ii) Find the names of Sailors who reserved boat 103.
What do you understand by a Functional Dependencies. Explain?
State and Explain Lossless join decomposition?
Explain in detail about Relation Schemas with suitable examples?
What is a transaction and explain its properties and States?
What is Schedule? Explain about Serial and Non Serial Schedule?
How the Lock Manager implements lock and Unlock request? Explain.
Explain extendable hashing techniques for indexing data records. Consider your Class students data records and roll numbers as index attribute and show the Hash directory?
Explain Static Hashing? What are the advantages of static hashing in DBMS?
Write short notes on any two:
i) Query Processing
ii) Data independence
iii) Union and Intersection
iv) Dependency Preservation
