GTU previous years question papers
GUJARAT TECHNOLOGICAL UNIVERSITY
B.E. Sem-III Examination December 2009
Subject code: 130703
Subject ame: Database Management System
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (a) (i) Explain the purpose of the database system.
(ii) Explain different database users.
(b) (i) What are the responsibilities of a DBA?
(iii) Explain three level architecture of database system
Q.2 (a) (i)Explain candidate key, primary key and foreign key
(ii)Explain following relational algebra operation
(i)Natural join operation
(ii) Selection and projection operation
(b) (i) Explain specialization and generalization feature of ER diagram with example.
(ii) Construct E-R diagram for a hospital with a set of patients and medical doctors. Associate with each patient a log of various tests and examinations conducted.
(b) (i) Explain aggregation operation of ER diagram.
(ii) Construct E-R diagram of the bank. It provides different kinds of
bank accounts. And loans. It operates number of branches.
Q.3 (a) (i) What are anomalies in database design? How can we solve it?
(ii) Explain BCNF with example.
(b) (i) Explain how to find closure of a set of attributes?
(ii) Explain query optimization process.
Q.3 (a) (i) What is normalization? What is the need for normalization?
(ii) Explain 3NF with example
(b) (i) What is non-loss decomposition in database? How it is useful in database?
(ii) Explain evaluation of expression process in query optimization.
Q.4 (a) (i) Why concurrency control is needed?
(ii) Explain Two phase commit protocol
(b) (i) Explain shadow paging 04
(ii) Explain mandatory access control of database security.
Q.4 (a) (i) Explain ACID properties of transaction.
(ii) Explain Two phase locking. 0
(b) (i) Explain deadlock detection mechanism
(ii) Explain Data encryption in brief.
Q.5 we have following relations:
Answer the following queries in SQL.
(a) (i) Find name of supplier for city = ‘Delhi’.
(ii) Find suppliers whose name start with ‘AB’
(iii) Find all suppliers whose status is 10, 20 or 30.
(iv) Find total number of city of all suppliers.
(v) Find s# of supplier who supplies ‘red’ part.
(vi) Count number of supplier who supplies ‘red’ part.
(vii) Sort the supplier table by sname.
(b) (i) Delete records in supplier table whose status is 40.
(ii) Add one field in supplier table.
(iii) Explain commit command
Q.5 (a) (i) Find name of parts whose color is ‘red’
(ii) Find parts name whose weight less than 10 kg.
(iii) Find all parts whose weight from 10 to 20 kg.
(iv)Find average weight of all parts.
(v) Find S# of supplier who supply part ‘p2’
(vi) Find name of supplier who supply maximum parts.
(vii) Sort the parts table by pname.
(b)(i) Delete records in parts table whose color is ‘blue’. 01
(ii) Drop one field in parts table. 01
(iii) Explain rollback command. 02
(iv) Explain stored procedure in PL/SQL.
To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit www.kopykitab.com