Data Management – XIBMS solved papers

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

Call us at : 08263069601

logo

Xaviers Institute of Business Management Studies

           MARKS: 80

SUB :  Data Management

PART – A                     (5 x 4 = 20 Marks)

Attempt any 5 Questions

1. Distinguish between specialization and generalization.How will you represent them in an ER diagram?

2. Give examples of different types of JOIN statement in SQL.

3.  What are clustered indexes? What is the maximum number of clustered index allowed on one data file?

4. List the different types of constraints that can be specified in a relational database.

5. Define functional dependency and state the Normal Form based on this.

6. State the desirable properties of a transaction.

7. What are temporal databases? Give an example of a typical application where such databases will be required.

8. Explain inheritance property in OODBMS.

9. Draw a block diagram showing the basic steps in Query Processing.

10. Define: (a) Network transparency

                 (b)   Fragmentation transparency

PART – B                               (3 X 20 = 60 Marks)

Attempt any 3 Questions

11. (i) Explain the 3 schema architecture in DBMS.  Highlight the difference between physical and logical data independence.        

      (ii) Define 3 NF and Boyce-Codd NF. Explain with suitable examples.                                                                                                    

12.  (i) Compare a file based system and an RDBMS system. When will you  develop a file based system?                                                                

            (ii) Construct an ER diagram for a company, which sells and services cars. The company keeps information about customers who purchase one or more cars, the sales person who is responsible for the sale and service details for each car is maintained. (assume minimum of 4 attributes on each entity type)                                                               

  13.   (i)  With a suitable diagram, explain the overall structure of a database               system.                                                                                              

(ii) Define primary key, super key and candidate key.                           

(iii) What are inference rules in a functional dependency? When is a set of FD said to be a minimal set?                                   

14. (i)  List the operations of the relational algebra and explain with Suitable example                                                                               

15. (i) Explain the different types of indexes. Which of these indexes are dense and which are not.                                                                

16. a)  (i) Discuss why concurrency control is needed in a DBMS?                    

          (ii) Explain any one method by which concurrency is achieved in a

               DBMS.                                                                                                      

17.  (i) Explain with examples the concept Record and SET data structures in a  Network data ,model                                                                   

            (ii) Explain how a select operation is done in query processing?           

18.  (i)  Explain the concept of  Object and Object Identity in Object

               Oriented data model                                                                                   

            (ii)   Discuss the features of Distributed database.                                   

           (iii)   Explain the 2-phase commit protocol for distributed database.        

19. (i)  Describe the association rule and classification rules in data mining?                                                                                          

       (ii) With a schematic diagram explain the architecture and features

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

Call us at : 08263069601

Leave a Reply