Guru Nanak Dev University 2007-5th Sem B.E Computer Science DATABASE MANAGEMENT SYSTEM (CS - 305) (-2k7) - Question Paper
Tuesday, 22 January 2013 07:30Web
2117
B.Tech (comp. Sc. & Engg.)/M.Tech (Computer Science and Engineering) V-Semester
RELATIONAL DATABASE MANAGEMENT SYSTEM
Paper - CS-305
Time Allowed - 3 Hours
Maximum Marks : 60
Note : Attempt any 5 ques.. All ques. carry equal marks.
1. (a) What do you understand by a database system ? what are the 3 schema architecture of a database system. (6)
(b) discuss the characteristics and advantages of SQL.
2. (a) Distinguish ranging from :-
(i) Logical and Physical data independence
(ii) Entity and Referntial Integrity. (6)
(b) What is Relational algebra ? elaborate its uses ? (6)
3. (a) What is E-R modelling ? discuss the functions of the components of an E-R model. (6)
(b) explain the responsibilities of DBA.
4. (a) What do you mean by database integrity ? explain the different integrity rules. (6)
(b) describe BCNF. How does it differ from 3NF? Why is it considered stronger form of 3NF ? (6)
5. (a) What do you mean by data recovery ? How recovery is performed ? discuss. (6)
(b) describe functional dependency. discuss the different kinds of functional dependencies with examples.
6. elaborate the issues arising out of concurrent data access ? How serializability can be guaranteed ?
7. What is query optimization ? At what point during query processing does optimization occur ? Briefly explain cost based optimization. (12)
8. Write short notes on :-
(a) Distributed databases
(b) Object-oriented databases.
Earning: Approval pending. |