Sathyabama University BE 511506-512506-6C0100-6CPT0012 Database Management Systems Nov 2010

Register Number

                               

SATHYABAMA UNIVERSITY

(Established under section 3 of UGC Act, 1956)

Course & Branch: B.E/B.Tech-CSE/DCS/IT/P-IT

Title of the Paper: Database Management Systems Max. Marks: 80

Sub. Code: 511506-512506-6C0100-6CPT0012   Time: 3 Hours

Date: 25/11/2010                                                    Session: FN

______________________________________________________________________________________________________________________

PART - A                (10 X 2 = 20)

Answer ALL the Questions

1.     What are all the categories of data models available?

2.     Draw the physical structure of 3-tier client server architecture.

3.     Define Data Abstraction.

4.     List the Characteristics of relations.

5.     Write down the syntax of creation and updating of SQL Queries.

6.     Define Views and cursors.

7.     What do you mean by flow control in database?

8.     Describe Encapsulation and Polymorphism.

9.     Compare Data mining with Data Warehousing.

10.   Define clustering

PART – B               (5 x 12 = 60)

Answer ALL the Questions

11.   Explain the 3-schema architecture.       

(or)

12.   Describe Data modeling using ER-model.

13.   Discuss relational algebra operations and their mapping algorithm.

(or)

14.   Describe Functional Dependencies and Normalization.

15.   Explain the various types of Nested Queries and its Applications.

(or)

16.   Write short notes on

        (a) Data base Recovery Techniques                                              

        (b) Data Base Security                                                          

17.   Differentiate the Hierarchical Model and Network Model.

(or)

18.   Discuss the various types of Databases.

19.   Briefly describe the type hierarchies and Inheritance.

(or)

20.   Illustrate the goals and applications of Data Mining.

Share This