321. Given the relation
Supplier(s_id, p_order, s_name, qty)
Given that there is a unique s_name for each s_id and that s_id, p_order is a
composite key, find the correct statement among the following:
this relation is a BCNF
this is 3 NF relation
this is a 2 NF relation
this is a 1 NF relation
i and ii
ii and iii
i and iv
i and iii
Correct answer: (D) i and iii
322. The relation SUPPLIES in Mini-case example 1 of Section 10.10 requires normalization because
it has a composite key with three attributes
the non-key attributes are dependent on part of composite key
the attributes item code and order no of the composite key have multivalued dependency
vendor code and order no have a multivalued dependency
Correct answer: (C) the attributes item code and order no of the composite key have multivalued dependency
323. The abbreviation DBMS stands for
Data Base Manipulation System
Data Bank Manipulating System
Data Base Management System
Data Bank Management System
Correct answer: (C) Data Base Management System
324. Among objectives of DBMS are ensuring
data integrity
data redundancy
data security
easy data retrieval
i, ii
i, iii
i, iii, iv
i, ii, iii
Correct answer: (C) i, iii, iv
325. When a logical model is mapped into a physical storage such as a disk store the resultant data model is known as
conceptual data model
external data model
internal data model
disk data model
Correct answer: (C) internal data model
326. The sequence followed in designing a DBMS are
physical model conceptual model logical model
logical model physical model conceptual model
conceptual model logical model physical model
conceptual model physical model logical model
Correct answer: (C) conceptual model logical model physical model
327. Pick the relationship from the following:
a classroom
teacher
attends
cost per dozen
Correct answer: (C) attends
328. The expansion of E-R diagram is
Entity-Relationship diagram
Entity-Relative diagram
Entity-Relation diagram
Entity-Rationalized diagram
Correct answer: (A) Entity-Relationship diagram
329. A pilot can fly three types of planes and a plane can be piloted by any qualified pilot. The pilot-plane type relationship is
N:3
3:N
1:3
3:1
Correct answer: (A) N:3
330. Normalization is a process of restructuring a relation to
minimize duplication of data in a database
maximize duplication of data to ensure reliability
make it of uniform size
allow addition of data
Correct answer: (A) minimize duplication of data in a database