MCA NALANDA OPEN UNIVERSITY QUESTION (2011) Part-III, Paper-XXII, (Advanced Database Design)

MCA NALANDA OPEN UNIVERSITY QUESTION (2011) Part-III, Paper-XXII, (Advanced Database Design)

                                                                                  2011
                                                                           Time: 3 hours
                                                                          Full marks: 80
                                     Answer any five questions. All questions carry equal marks.

1. The ABC Bank offers five types of Accounts: loan, checking, savings, daily interest saving and money market. It operates a number of branches within the country. A client of the bank can have number of accounts. Accounts can be self or a joint account. Draw an E-R diagram for the ABC bank identifying various entities, attributes and cardinality. Show meaningful relationships that exist among the entities. Translate the E-R diagram to schema Relational model.

2. Explain the following protocols for concurrency control in transactions with the help of an illustration for each:-
   (a) Tree- protocol
   (b) Timestamp- Based Protocol.

3. With the help of a process diagram, explain the various tasks involved in the knowledge Discovery in databases(KDD) process. Explain the role of ODBC and JDBC with the help of an example.

4. What are multimedia databases (MMDBs)? List some of the applications of MMDBs. Describe various contents of MMDBs. Also, mention the challenges in designing of MMDBs. Define Multi-valued depedencies and join dependencies. Give an examples of each.

5. State fourth and fifth normal form. Consider a relation R (A,B,C) with functional dependencies,
    (i) AB->C;   (ii) C->A. Decompose the relation R into BCNF relations.

6. With the help of a diagram, explain the reference architecture of distribute DBMS.How is this different from component Architecture  of DDBMS? Explain the following two ways to implement the object- oriented concepts in DBMS:
  (a) To extend the existing RDBMS to include object orientation.
  (b) To create a new DBMS that is exclusively devoted to OODBMS.

7. What is a (DW) Data Ware House? Explain the basic components of a DW. consider a supply data of an organization having three dimensions as supplier, Part and Project. Draw a star schema with supply as the fact table. make suitable assumptions.

8. Explain the following in the context of ORACLE with examples:-
    Triggers, Security, Data Dictionary, Indexing

9. With reference to special Databases, and GIS explain the following:
     (a) Application of Geographic Databases.
     (b) Requirements of a GIS.
     (c) Operations on the data captured in GIS.

10. (a) Consider the following query:-
            SELECT Empld, Emp Name,Emp Address, Dept Name, Designation,
            FROM Employee, Department
            WHERE Employee. Dept No= Department. Dept No
             AND Employee, salary > 2000
      Create a query evaluation plan for the query given above. Make suitable assumptions about the            relation and statistics.

 (b) Explain Cursors. Explain the role of cursors in Embedded SQL with the help of an example.