GUI & Database Management Semster III (December 2011)
Con.6771-11. MP-4180
(3 Hours) [Total Marks:100]
N.B: (1) Question No. 1 is compulsory.
(2) Solve any four question out of remaining six questions.
| 1.(a) | Discuss the main categories of data models. | 5 |
| (b) | State five main advantages of using a DBMS. | 5 |
| (c) | Explain ACID properties of transactions. | 5 |
| (d) | Explain with examples the decision making statement and loop structures | 5 |
| statement in VB. | ||
2.(a) | What are the different types of database system users ? | 5 |
| (b) | List the functions of a databse administrator (DBA). | 5 |
| (c) | Draw an E-R diagram which models an online bookstore. List entity sets and | 10 |
| primary keys. | ||
| 3.(a) | What are the conditions for the schedules S & S' to be view equivalent ? When do we say a schedule S is view serializable ? | 10 |
| (b) | Why transaction processing system usually allow concurrent executions ? Give reasons. | 10 |
4.(a) | Brief about validation based concurrency control scheme. | 10 |
| (b) | Explain deadlock prevention in detail. | 10 |
5.(a) (a) | For the following relations for a book club :- | 10 |
| (i) Members (Member-id, Name, Designation, Age). | ||
| (ii) Book (Bid, Btitle, BAuthor, Bpublisher and Bprice are book identification, booktitle, | ||
| book author, book publisher and book price respectively. | ||
| Write the following queries in SQL.339 | ||
| (1) Find the names of members who are professors older than 45 years. | ||
| (2) List the titles of books reserved by professors. | ||
| (3) Find IDs of members who have reserved books that cost more than Rs.500. | ||
| (4) Find the authors and tilles of books reserved on 11-11-2011. | ||
| (5) Find the names of members who have reserved all books. | ||
| (b) | Describe two-phase locking protocols and graph based protocols. | 10 |
6.(a) | Write a note on relational algebra. | 10 |
| (b) | Describe the use of logs and check points in a database. | 10 |
7. | Wrte short notes on (any four):- | 20 |
| (a) DDL and DML | ||
| (b) Transaction support in SQL | ||
| (c) Features of GUI | ||
| (d) Activex data objects (ADO) | ||
| (e) Extended E-R features | ||
| (f) Shadow paging recovery technique. |
No comments:
Post a Comment