DATABASE MANAGEMENT (DBM) S.E.I.T/SEM - III (May 2012)

DATABASE MANAGEMENT (DBM)

 S.E.I.T/SEM - III (May 2012)

Con. 4586-12                                                                                                   GN-8720

                                                     (3 Hours)                                [Total Marks : 100]         

N.B. : (1)Question No. 1 is compulsory.

          (2) Answer any four out of remaining questions.
          (3)Assume any suitable data if necessary and clearly state it.

1. a) Discuss the advantages of Database system over file system. - [05 Marks]
    b) What is strong entity and weak entity? Explain with example. - [05 Marks]
    c) Explain different feature of GUI. - [05 Marks]
    d) What is a view? Write syntax to create view using SQL. - [05 Marks]                                       
2. a) Consider a car insurance company whose customers own one or more cars each.
        Each car has associated with it zero to any number of recorded accidents.
         i) Design an EER schema, stating any assumption you make. - [05 Marks]                
        ii) Show mapping of EER schema to relational schema. - [05 Marks]                                                  
     b) Explain following relational algebra operators with example: - [10 Marks]                   
         i) Project    ii) Rename   iii) Division   iv) Natural Join   v) Set Difference

3. a) Explain different states and properties of transaction. [10 Marks]                                
    b) What is a deadlock? Explain different techniques to prevent and recover
        from the deadlock. [10 Marks]                                                                                                     
4. a) Consider the following global schema which keep track of airline flight information.
        Answer the following queries in SQL: -  [10 Marks]
        Flights (flno, from, to, distance, departs, arrives, price)
        Aircraft (aid, aname, cruisingranger)
        Certified (eid, aid)
        Employees (eid, ename, salary)                                                                                
        i) Find the names of pilots certified for some Boeing aircraft.
       ii) Find the aids of all aircraft that can be used on routes from Mumbai to Delhi.
      iii) Find the names of pilots whose salary is less than the price price of the cheapest
           route from Mumbai to Chennai.
      iv) For each pilot who is certified for more than three aircraft, find the eid and the
           maximum cruisingrange of the aircraft for which she or he is certified.

   b) Explain the use of logs and check points for recovery in a database. - [10 Marks]                              
5. a) Explain Murphy’s Law of GUI design. - [05 Marks]
    b) Write a note on Activex Data Object(ADO). - [05 Marks]                                                                 
    c) What is serializable schedule? Describe with suitable example different types of                  serializable schedule. - [10 Marks]                                                                         

6. a) What is concurrency control? Explain the two phase locking protocol
        and graph based protocols. - [10 Marks]                                                                       
    b) Explain the shadow page recovery technique. - [05 Marks]                                       
    c) Write a note on icons and graphics. - [05 Marks]
                                                                               
7. Write short note on: - [20 Marks]                                                                                       
    a) Responsibilities of Database Administrator.
    b) Generalization and Aggregation.
    c) Listbox, Combobox, Checkbox controls of VB.
    d) Referential integrity in SQL.

Also see Database management question papers December 2013