System Analysis and Design

331. The number of normal forms which has been proposed and discussed in the book are

  1. 3
  2. 4
  3. 5
  4. 6
Correct answer: (D)
6

332. A third Normal Form (3 NF) relation should

  1. be in 2 NF
  2. not have complete key
  3. not be 1 NF
  4. should not have non-key attributes depend on key attribute
Correct answer: (A)
be in 2 NF

333. BCNF is needed because

  1. otherwise tuples may be duplicated
  2. when a data is deleted tuples may be lost
  3. updating is otherwise difficult
  4. when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples
Correct answer: (D)
when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples

334. TEACHES-COURSES relation in Mini-case example 2 is in

  1. 3 NF. Does not need any further normalization
  2. BCNF
  3. 4 NF
  4. unnormalized form
Correct answer: (A)
3 NF. Does not need any further normalization

335. Some of the objectives of a database management system are to

  1. minimize duplication of data
  2. ensure centralized management control of data
  3. ease retrieval of data
  4. maintain a data dictionary
  1. i and ii
  2. i, ii and iv
  3. i and iii
  4. i, ii and iii
Correct answer: (D)
i, ii and iii

336. Data independence allows

  1. no changes in application programs
  2. change in database without affecting application programs
  3. hardware to be changed without affecting application programs
  4. system software to be changed without affecting application programs
  1. i, ii
  2. ii, iii
  3. ii, iii, iv
  4. i, ii, iv
Correct answer: (C)
ii, iii, iv

337. An E-R modelling for given application leads to

  1. conceptual data model
  2. logical data model
  3. external data model
  4. internal data model
Correct answer: (A)
conceptual data model

338. The responsibilities of a database administrator includes

  1. maintenance of data dictionary
  2. ensuring security of database
  3. ensuring privacy and integrity of data
  4. obtain an E-R model
  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. ii, iii, iv
Correct answer: (B)
i, ii, iii

339. Pick the meaningful relationship between entities

  1. vendor supplies goods
  2. vendor talks with customers
  3. vendor complains to vendor
  4. vendor asks prices
Correct answer: (A)
vendor supplies goods

340. In an E-R diagram relationship is represented by

  1. circles
  2. rectangles
  3. diamond shaped box
  4. ellipse
Correct answer: (C)
diamond shaped box
Page 34 of 61