Download Database Management System (DBMS) - BCA (CBCS) RUSA IInd Semester Examination and more Schemes and Mind Maps Database Management Systems (DBMS) in PDF only on Docsity!
Roll No. ...
Total No. of Questions : 9] ITotal^ No.^ of^ Printed^ Pages:
BCA (CBCS) RUSA IInd Semester
Examination
4031
DATABASE MANAGEMENT SYSTEM
Paper BCA-
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)
- Attempt any seven :
(i)
What is data and information?
(i) What is Primary key^?
(ii) What is a direct file?
(iv) What is difference between file oriented and
DBMS approach?
C-
(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-
Unit-II
- 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 ofof file
file
organization
with the
help
of suitable
example.
5. What is
a (^) relation?
How do
you define^ relational
database
Discuss
degree
and
cardinality
of a
relation
with the
help
of
suitable example. (^) Explain Join
operation.
14 each
C- (
Roll No...
Total No. of Questions : 9] [Total^
No. of Printed Pages:^
4
BCA (^) (CBCS)
RUSA IInd Semester
Examination
DATABASE MANAGEMENT SYSTEM
Paper BCA-
Time:3 Hours]
[MaximumMarks :
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-
Attempt any
seven
parts
Explain the following:
Field and Records
)
i) Data Abstraction
CH-715 (1)
Turn Over
ii) Primary^
key
and Foreign key
(iv) Entity^
and
Attributes
(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-
Unit-V
14 each
features of
- (a) Explain
Some important
MS-ACCESS.
b)
What is Form^?^ How 'Modal'^ and Modeless
forms are implemented? Explain.
- (a) Explain Make-table', Update and Append
operations through suitable examples.
b)
What is Report
? Create a
simple report^
from a
(b)
table of database of your choice.
CH-715 (4)
