DOEACC Society 2007 DOEACC A Level A7-R3 Introduction to Data Base Management Systems - Question Paper

D. Closure E. Union F. Primary
G. Physical H. Hierarchical I. Relations
J. Specialization K. Composite L. Weak entity set
M. Partitioning N. Aggregation O. Integrity Constraints
4.1 The process of designating sub-grouping within an entity set is_________.
4.2 An entity set that does not have sufficient attributes to form a primary key is known as
_______.
4.3 A relation that is not part of logical model but is made visible to a user as a virtual
relation is called a(n) _______________.
4.4 Durability is implemented in ______________component of database.
4.5 The UPDATE command in SQL is used to replace attribute values of 1 or more
opted _________.
4.6 A foreign key creates a(n) ________ relationship ranging from 2 associated entities.
4.7 The _______ of a query consists of the tuples, which may be assigned to the free
variables of the well-formed formula.
4.8 A key consisting of more than 1 column is called a(n) ________.
4.9 A(n) ________ structure is a logical data model that arranges data according to a few
natural hierarchy on a one-to-one basis.
4.10 A locking protocol ensures conflict serializability, iff for all legal schedules, the
associated relation is ___________.
A7-R3 Page four of six January, 2007
PART TWO
(Answer any 4 questions)
5.
a) discuss the subsequent Database terms with the help of an examplei)
Data Independence
ii) Domain
iii) Foreign Key
iv) Cardinality
v) Referential Integrity
b) discuss the purpose of triggers in SQL with the help of an example.
([2x5]+5)
6.
a) An insurance company wishes to create a database to keep track of its operations. A
policy may be held by many policy holders. An agent sells policies; with all policies being
sold by only 1 agent. A policyholder is serviced by only 1 agent. An agent normally
works in 1 office, although a few agents work from home. An office may have several
agents. Policy details held include the policy number, policy date, policy kind and
insurance amount. Policyholder’s details include policyholder number, name, and
address and phone number. Agent details include agent code, agent name, salary and
commission (2% of total policy insurance amount sold). Office details include the office
name, office address, office phone number and manager name.
i) State the entity kinds with their identifier and the relationships, using above
description.(State any assumption)
ii) Construct an ER diagram and use the relational mapping rules to derive a
suitable relational schema.
b) Explain, why Relational model is more popular than the other 2 models.
([4+7]+4)
7.
a) define in brief the different access control policies that are to be determined in light of
the security features given by the DBMS.
b) define in brief the recovery techniques based on immediate update.
c) discuss third normal form with suitable example.
(6+6+3)
8.
a) Consider the relation R (A, B, C, D, E, F, G) with subsequent set of functional
dependencies-
{A?CE, EF?ADG, BG?CEF, BF?AD, D?ABG}
i) calculate the closures of subsequent sets:
1.1) D
1.2) AB
ii) obtain a loss less BCNF decomposition of above schema. If BCNF decomposition
is not dependency preserving, obtain 3NF decomposition.
b) What is concurrency control? discuss with suitable example.
(5+10)
A7-R3 Page five of six January, 2007
9.
a) A schema describing theatres, cities where they are located and indicates is described as
follows-
CITY (Name, State, Country)
THEATRE (Name, City, State, Capacity)
SHOW (Title, Artist, Hall, Attendance)
Write the subsequent queries in both 1) SQL and 2) Relational Algebrai)
obtain names of artists who performed before at lowest 5000 people, together with
cities where those performances took place.
ii) obtain all states in India where Mr. X has performed.
iii) List all artists who never played in Delhi.
iv) obtain the name of theatres in Bombay whose capacity exceeds 5000.
b) discuss in brief ACID properties of a database transaction.
c) discuss the functions of Database Administrator.
([2x4]+4+3)
A7-R3 Page six of six January, 2007

Earning:   Approval pending.