Database Management System (DBMS) Previous question Paper (UTU)-2013
B.Sc. (IT) Third Semester Examination, 2013-14
Database Management System (DBMS)
Note: Attempt five question in all. all question carry equal marks.
1. (a) Explain the role and responsibility a database administrator?
(b) Describe various component of database system?
2. Write notes on with example :
(a) Query processor
(b) Tupple variable
(c) Degree of a relation
(d) Super key
3. (a) Explain the following general integrity rules of relation model :
(i) Entity integrity
(ii) Referential integrity
(b) Design a relational database to E-R diagram given
below:
4. Differentiate the following :
(a ) DD L ( Data Definition language ) and D ML
( DATA manipulation language ) .
(b) Weak entity set and strong entity set
5. (a ) Why we need normalization ?
(b) Define the following :
(i ) Fully function dependency
(ii) Multivalued dependency
(iii ) Trivial dependency.
6. (a) Define 3NF (III Normal form ) and BCNF (Boyee codd's Normal )
form with example ?
form with example ?
(b) Justify that 3NF is stronger than 2 NF ?
7. (a ) Briefly discuss various data type in SQL or PL/SQL ?
(b ) Explain laxative statements used in SQL or PL/SQL.
Give example of all types.
