Here we are provided Previous Year Question Paper Conducted by professional courses BCA, BBA, BSc(IT), HM, BHM, B.Tech, etc. Last year question paper for B.Sc.(IT) Third semester subject is Database Management system (DBMS).Last year paper of (DBMS) for B.Sc.(IT) 2013-14.University is Uttarakhand Technical University (UTU).You can Download Previous year Question paper Database Management system (DBMS) for B.Sc.(IT) 2013-14. and check out of your exam pattern, answer, results, syllabus According to Professional courses. 

Last Year Paper of (DBMS) for B.Sc. (IT) 2013-14 

B.Sc. (IT) Third Semester Examination, 2013-14

Database Management System (DBMS)

Time Duration: Three Hrs.                                             Total marks:70

 

Instruction: Attempt any five Question in all. All question carry equal marks.

Q1. (a)   Explain the role and responsibility a database administrator?

        (b)   Describe various component of database system?

Q2.     Write notes on with example:

        (a)   Query processor

        (b)   Tupple variable

        (c)    Degree of a relation

        (d)    Super key

Q3. (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:

 

 1234

 Q4.            Differentiate the following :

 (a )     DDL(Data Definition language) and DML (DATA manipulation language) .

(b)     Weak entity set and strong entity set

Q5.  (a)    Why we need normalization ?

         (b)     Define the following:

         (i)     Fully function dependency

         (ii)     Multivalued dependency

        (iii)   Trivial dependency.

 Q6.  (a)    Define 3NF (III Normal form ) and  BCNF  (Boyee codd’s Normal ) form                         with example ?

         (b)   Justify that 3NF is stronger than 2 NF ?

Q7. (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.