Want to download INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS DCA Question Papers asked in previous years? Get December 2015 Question Paper of GITAM University for this subject. Collect it in text form as well as image format as mentioned below.
GITAM University
Year: December 2014
[SDDCA-103]
DCA EXAMINATION
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
(Effective for the admitted batch 2009-10)
Time: 3 Hours Max.Marks: 70
------------------------------------------------------------------------------------------
Instructions: All parts of the section must be answered in one place only.
Figures in the right hand margin indicate marks allotted.
------------------------------------------------------------------------------------------
SECTION-A
1. Answer any Four of the following (4 x 5 = 20)
a) Explain the levels Architecture of DBMS
b) Define the bellow terms
i. Entity
ii. Relation
iii. Attribute
iv. Generalization
v. Specification
c) Explain the concepts of Relational Model
d) Define the Normalization, what are the properties of Normalized relations
e) Give the commands how to do Update, Rename, and Add queries in SQL with an example
f) Explain the Data Dictionary
g) Explain GROUP by features in SQL
SECTION-B
Answer all questions: (5 x 10 = 50)
2. a) Explain the facilities of DBMS
OR
b) Explain advances and dis-advances of DBMS
3. a) Advances and Dis-Advances of Relational approach
b) Difference between Relational and other models
OR
c) Explain how to do convert elements of ER into relation model with an example in detail
4. a) Explain Codd – commandments in detail
OR
b) Explain JOIN, SELECTION, PROJECTION, DIVISION, and CARTESION PRODUCT operations in Relational Algebra
5. a) Explain BOYCE – CODD Normal from (BCNF)
OR
b) Explain Functional Dependency in detail
6. a) Explain the basic structure of SELECT statement. What is a view?, how the view can be defined in SQL
OR
b) Explain DML statements of SQL with examples
GITAM University
Year: December 2014
[SDDCA-103]
DCA EXAMINATION
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
(Effective for the admitted batch 2009-10)
Time: 3 Hours Max.Marks: 70
------------------------------------------------------------------------------------------
Instructions: All parts of the section must be answered in one place only.
Figures in the right hand margin indicate marks allotted.
------------------------------------------------------------------------------------------
SECTION-A
1. Answer any Four of the following (4 x 5 = 20)
a) Explain the levels Architecture of DBMS
b) Define the bellow terms
i. Entity
ii. Relation
iii. Attribute
iv. Generalization
v. Specification
c) Explain the concepts of Relational Model
d) Define the Normalization, what are the properties of Normalized relations
e) Give the commands how to do Update, Rename, and Add queries in SQL with an example
f) Explain the Data Dictionary
g) Explain GROUP by features in SQL
SECTION-B
Answer all questions: (5 x 10 = 50)
2. a) Explain the facilities of DBMS
OR
b) Explain advances and dis-advances of DBMS
3. a) Advances and Dis-Advances of Relational approach
b) Difference between Relational and other models
OR
c) Explain how to do convert elements of ER into relation model with an example in detail
4. a) Explain Codd – commandments in detail
OR
b) Explain JOIN, SELECTION, PROJECTION, DIVISION, and CARTESION PRODUCT operations in Relational Algebra
5. a) Explain BOYCE – CODD Normal from (BCNF)
OR
b) Explain Functional Dependency in detail
6. a) Explain the basic structure of SELECT statement. What is a view?, how the view can be defined in SQL
OR
b) Explain DML statements of SQL with examples
0 comments:
Pen down your valuable important comments below