System Analysis and Design

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:

  1. this relation is a BCNF
  2. this is 3 NF relation
  3. this is a 2 NF relation
  4. this is a 1 NF relation
  1. i and ii
  2. ii and iii
  3. i and iv
  4. 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

  1. it has a composite key with three attributes
  2. the non-key attributes are dependent on part of composite key
  3. the attributes item code and order no of the composite key have multivalued dependency
  4. 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

  1. Data Base Manipulation System
  2. Data Bank Manipulating System
  3. Data Base Management System
  4. Data Bank Management System
Correct answer: (C)
Data Base Management System

324. Among objectives of DBMS are ensuring

  1. data integrity
  2. data redundancy
  3. data security
  4. easy data retrieval
  1. i, ii
  2. i, iii
  3. i, iii, iv
  4. 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

  1. conceptual data model
  2. external data model
  3. internal data model
  4. disk data model
Correct answer: (C)
internal data model

326. The sequence followed in designing a DBMS are

  1. physical model  conceptual model  logical model
  2. logical model  physical model  conceptual model
  3. conceptual model  logical model  physical model
  4. conceptual model  physical model  logical model
Correct answer: (C)
conceptual model  logical model  physical model

327. Pick the relationship from the following:

  1. a classroom
  2. teacher
  3. attends
  4. cost per dozen
Correct answer: (C)
attends

328. The expansion of E-R diagram is

  1. Entity-Relationship diagram
  2. Entity-Relative diagram
  3. Entity-Relation diagram
  4. 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

  1. N:3
  2. 3:N
  3. 1:3
  4. 3:1
Correct answer: (A)
N:3

330. Normalization is a process of restructuring a relation to

  1. minimize duplication of data in a database
  2. maximize duplication of data to ensure reliability
  3. make it of uniform size
  4. allow addition of data
Correct answer: (A)
minimize duplication of data in a database
Page 33 of 61