Guru Gobind Singh Indraprastha Vishwavidyalaya 2005 B.B.A Database Management System - exam paper

END-TERM exam
2nd SEMESTER [BBA/BBA(B&I)] - MAY 2005
Paper Code:BBA/BBA(B&I)108 Subject: Database Management System
Time : three Hours Maximum Marks : 75
Q.1 (a) elaborate the main differences ranging from a file -processing

Q.2 (a) Des cribe the basic features of the relational database model. (5)
(b) List and discuss the various kinds of attributes used in the E-R model. (6)

(c) discuss the terms ‘Entity Set’ and ‘Relationship Set’. (4)
(a) Identify and explain every of the indicated dependencies. (4)

Q.3 (a) In case of relation database design, a relationship set table
(b) Create a database whose tales are at lowest in 2NF, showing
linking a weak entity set to the corresponding strong entity
the dependency diagrams for every table. (4)
set is redundant. Elucidate. (5)
(c) Create a database whose tables are at lowest in 3nF, showing
(b) Construct an E-R diagram for a car -insurance company that
the dependency diagrams for every table. (4)
has a set of customers, every of whom owns 1 or more
(d) What is multivalued dependency? (3)
cars. every car has associated with it zero to any number of recorded accidents. (5)


Q.4 Differentiate between: -
(c) discuss the parts that appear during report design
(a) Table and View
(3)
window.
(6)
(b) Candidate and Super key (3)

(c) Centralized and Disturbed databases (3)


Q.5 (a) elaborate Aggregate functions? discuss the every function
(b) discuss the subsequent comparison operators with an example. (4)
(i) like
(ii) gn
(c) provide the syntax for the following: -
(i) Create table. (2)
(ii) Insert. (1)
(iii) Update. (1)
(iv) Delete. 1)
(d) Design problems of an E-R database schema with an example. (6)

Q.6 provided the subsequent dependency diagram: -
system and a DBMS? (7)
b1 b2 b3 b4 b5
(a) Identify and explain every of the indicated dependencies.(4)

(b) What is data independence and why is it important? (5)

(c) What do you understand by the term ‘Transaction’? (3)

Q.7 (a) elaborate the data kinds supported by MS Access? discuss
(c) Construct the relational schema for the above E-R diagram.
the every kind.
(6)

(b) elaborate filters? discuss. (3)

Q.8 Write notes on any three: - (5x3=15)
(d) elaborate the various constraints that can be imposed on a
(a) Steps in creating a form
relation? .
(b) Mapping cordinalities

(c) Concurrency control

Earning:   Approval pending.