DATABASE TECHNOLOGIES (DBT) MAY 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 3503-10.                            (REVISED COURSE)                                       AN-4603
                                                          (3 Hours)                                        [Total Marks:100]


N.B.: (1) Questions No. 1 is compulsory.
         (2) Solve any four questions out of remaining six.
         (3) Assume any suitable data wherever required but justify the same.

Q. 1   Consider the following information about a Life Insurance Corporation:
          The Netwark divisional office of the Life Insurance Corporation of America
           Keeps all the necessary information about the policy holders is a database. A
           policy holder pays a premium untill the maturity of the policy of his death. at
           which time sum assured and bonus is paid to the nominee. The premium to be
           paid is worked out based on the age of the person proposed and the term of
           the policy. Network division keeps the following information about each policy
           holder: social security number, name, address, date of birth , description of the
           terms of the policy and the annual premium. The corporation has divided its
           Netwark division into 15 zones for its convenience. Each zone has it manager.
           Every zone has a number of agents allotted, typically ranging from 10 to 20.
           Every agent must procure a minimum of 10 customers.
      (a) Draw an E-R diagram for the Corporation database (state any assumption you
           believe you need to make in order to develop a complete diagram). Identify the
           key attribute (attributes) for each entity and the cardinality of each entity
           relationship. [10 Marks]
      (b) Write SQL statement to create corresponding relation and the capture as of the 
           constraints as possible. if you cannot capture some constraints, explain why? [10 Marks]

Q.2 (a) Explain ACID properties in detail? [10 Marks]
      (b) Explain 3NF and 4NF with suitable example? [10 Marks]

Q.3 (a) What is deadlock? Explain the different method to prevent and detected it? [10 Marks]
      (b) What is difference persistent and transient object ? How the persistence handle
           typical OODBMS? [10 Marks]

Q.4 (a) How is a vertical and a horizontal partitioning of a relation is specified? How
           can a relation be put back together from a complete vertical and a complete
           horizontal partitioning? [10 Marks]
      (b) Explain relational algebra operators in details ? [10 Marks]

Q.5 (a) Explain the reference integrity with example? [10 Marks]
      (b) Explain concurrency control in DBMS with help ant two protocols? [10 Marks]

Q.6 (a) Explain database system structure in detail? [10 Marks]
      (b) Explain the architecture of datawarehouse in detail. [10 Marks]

Q.7     Short notes on (any four) [20 Marks]
               a) Comparison of ODBMS ORDBMS
               b) OLAP
               c) Temporal database
               d) Mobile database
               e) Trigger and Assertion. 

Also see Database technologies question papers for May 2013