Roll No. . . .
Total No. of Questions : 9] ITotalNo. of Printed Pages:3
(1048)
BCA (CBCS) RUSA IInd Semester
Examination
4031
DATABASE MANAGEMENT SYSTEM
Paper BCA-0205
Time:3 Hours] [MaximumMarks: 70
Note- Select one question from each Unit II, III, IV and
V. Unit-I is compulsory,
Unit-I
(Compulsory Question)
1. Attempt any seven :
(i) What is data and information ?
(i) What is Primary key ?
( i i ) What is a direct file ?
(iv) What is difference between file oriented and
DBMS approach ?
C-663 (1) Turn Over
(v) What is a query ? Write all its types.
(vi) What is the need of normalization ?
(vii) Define data integrity.
(vii) What is an attribute and tuple ?
(ix) Describe DML statement is sQL.
(x) Describe the types of relational calculus. 7x2-14
Unit-II
2 . What do you mean by data modeling for a data-
base ? Discuss data Abstraction and data integration
with suitable example.
3. What is E-R model ? Discuss the various
shapes
used to draw E-R diagram with the help of one
suitable example. 14 each
Unit-III
4 What is file ? Discuss various methods
of file
organization with the help of suitable example.
5. What is relation ? How do you define relational
a
database ? Discuss degree and cardinality of a
relation
with the help of suitable
example. Explain Join
operation. 14 each
C-663 (2
Unit-IV
6. What is normalization ? Define 3NF and BCNF
explaining their pre-conditions. Give suitable examples.
7. Write short notes on the following:
Multivalued Dependency.
(i) Relational Database design. 14 each
Unit-V
8.
8. What is master-detail table ? How primary and foreign
keys are related to each other ? Discuss their usage
in master-detail table by giving suitable example.
9 . Discuss with example the process of creating a form
by using a wizard. 14 each
C-663 (3)
Roll No...
Total No. of Questions : 9] [Total No. of Printed Pages: 4
(1049)
BCA (CBCS) RUSA IInd Semester
Examination
4389
DATABASE MANAGEMENT SYSTEM
Paper BCA-02055
Time:3 Hours] [MaximumMarks :70
Note-Atempt five questions in al. Unit-I is compulsory.
Select one question from each of the Units-II, III,
IV and V.
Unit-I
(Compulsory Question) 7x2-14
1. Attempt any seven parts
Explain the following:
) Field and Records
i) Data Abstraction
CH-715 (1) Turn Over
and Foreign key
ii) Primary key
Attributes
(iv) Entity and
(v) Direct Files
(vi) Relation Scheme
(vii) Master-detail Tadle
(vii) Query
ix) Dependency preservation
(x) Tuple
Unit-II 14 each
2. a What is Data-base ? Explain its architecture
in detail along with its advantages and
disadvantages.
bDefine Data-model. Give its classification with
examples.
3. (a) What is DBMS ? Explain the structure of
DBMS. Also explain its importance and
limitations.
(b) Compare File-based, semantic and
Entity-relationship models.
CH-715 (2)
Unit-III 14 each
4. (a) Define File. Explain its various operations along
with its types.
(b) Write short note on "Relational Algebra' and
Relational Calculus.
5. (a) What is Indexing ? Explain the various types of
indexes in detail.
(b)
(b) What is Relational Model ? How is it
implemented ? Explain through example.
Unit-IV 14 each
6. (a) What is Normal Form ? Explain third and Boyce
Code with suitable examples.
(b) Define Dependency. Explain functional and
Multi-valued dependency in detail.
7. (a)
(a) Explain through short notes on the following:
Relational Data-base Design
(ii) Decomposition
(b)What is Normaliation ? Define 2NF and 3NF
explain their pre-condition through suitable
examples.
CH-715 (3) Turn Over
Unit-V 14 each
Some important features of
8. (a) Explain
MS-ACCESS.
Modeless
b) What is Form ? How 'Modal' and
forms are implemented ? Explain.
9. (a) Explain Make-table', Update and Append
operations through suitable examples.
(b)
b) What is Report ? Create a simple report from a
table of database of your choice.
CH-715 (4)
