Monday, September 05, 2016
S.B. Roll No.
RELATIONAL
DATABASE MANAGEMENT SYSTEM
4th
Exam/Comp/IT/6268/May’08
Duration : 3 Hrs.
Note : There
are questions in all.
·
Question 1 is compulsory and carries 15 marks.
·
Attempt any five question form section B and
three question form section C.
·
Any required data not explicitly given , may be
suitably assumed and stated.
1.
Choose the correct or best alternative in the
following:
a.
The property /properties of a database is/ are:
b.
It is an intergrated collection of logically
related records.
c.
It consolidates separate files into a common
pool of data records.
d.
All of the above.
e.
The DBMS language component which can be
embedded in a program is
i.
The data definition language (DDL)
ii.
The data manipulation language (DML)
iii.
The database administrator (DBA)
iv.
A query language.
f.
A relational database developer refers to a
record as
i.
A criteria
ii.
A relation
iii.
A tuple.
iv.
An attribute.
g.
The relational model feature is that there
i.
Is no need for primary key data
ii.
Is much more data independence than some other
database models.
iii.
Are explicit relationships among records.
iv.
Are tables with many dimensions
h.
Conceptual design
i.
Is a documentation technique
Needs data
volume and processing frequencies to determine the size of the database
Involves modeling
independent of the DBMS
Is designing the
relational model .
i.
The method in which records are physically
stored in a specified order according to a key field in each record is
i.
Hash
ii.
Direct
iii.
Sequential
iv.
All of the above
j.
A subschema expresses
i.
The logical view
ii.
The physical view.
iii.
The external
iv.
All of the above
k.
Count function in SQL returns the number of
i.
Values.
ii.
Distinct values.
iii.
Groups.
iv.
Columns.
Section –B
2.
Discus the main advantages of using a DBMS.
3.
What are the different types of database and
user? Discuss the main activates of each
4.
Describe the three-schema architecture
5.
Discuss the typical user friendly interfaces and
the types of users who use each.
6.
Differentiate between
Procedural and non procedural
languages
Key and super key.
Primary and secondary storage.
7.
With the help of an example show how records can
be deleted and updated in QBE
8.
a.
Describe cardinality ratios and participation
constraints for relationship types.
b.
Information about a bank is about customers and
their account. Customer has a name, address which consists of house number ,
area and city , and one more phone numbers, account has number, type and
balance. We need to record customers who own an account , Account can be held
individually or jointly . an account cannot exist without a customer.
Arrive at an E-R diagram. Clearly indicate attributes, keys, the
carnality ratios and participation constraints.
9.
a.
Describe the static hash file with buckets and
changing and show how insertion, deletion and modification of a record can be
performed.
b.
What are the reasons for having variable length
records? What types of separator characters are needed for each?
10.
Define the following terms
Derived and stored attribute.
Distributed system.
Interlock gap
Degree of a relation
Catalog
Conceptual schema
11.
a.
Define a relation
b.
Describe entity integrity and referential integrity. Give an example of
each
c.
Consider the two relations given below
R S
|
A
|
B
|
C
|
|
A1
Null
A1
|
B1
B2
B3
|
C1
Null
C1
|
|
D
|
A
|
F
|
|
D1
D1
|
A1
A2
|
F1
Null
|
Given that A is the primary key of R, D is the primary key
of S and there is a referential integrity between S.A and R.A, discuss all
integrity constraints that are violated.
0 comments:
Post a Comment
North India Campus