System Analysis and Design

311. Attributes are

  1. properties of relationship
  2. attributed to entities
  3. properties of members of an entity set
  1. i
  2. i and ii
  3. i and iii
  4. iii
Correct answer: (C)
i and iii

312. A relation is

  1. an entity
  2. a relationship
  3. members of a relationship set
  4. members of an entity set or a relationship set
Correct answer: (D)
members of an entity set or a relationship set

313. 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

314. A second Normal Form (2 NF) relation should

  1. be in 1 NF
  2. not have a composite key
  3. not have attributes dependent on key attribute
  4. not have attributes dependent on one another
Correct answer: (A)
be in 1 NF

315. A relationship is

  1. an item in an application
  2. a meaningful dependency between entities
  3. a collection of related entities
  4. related data
Correct answer: (B)
a meaningful dependency between entities

316. One entity may be

  1. related to only one other entity
  2. related to itself
  3. related to only two other entities
  4. related to many other entities
Correct answer: (D)
related to many other entities

317. Rows of a relation are called

  1. tuples
  2. a relation row
  3. a data structure
  4. an entity
Correct answer: (A)
tuples

318. The process of normalization

  1. is automatic using a computer program
  2. requires one to understand dependency between attributes
  3. is manual and requires semantic information
  4. is finding the key of a relation
Correct answer: (B)
requires one to understand dependency between attributes

319. An attribute y may be functionally dependent on

  1. a composite attribute x,y
  2. a single attribute x
  3. no attribute
  1. i and ii
  2. i and iii
  3. ii and iii
  4. iii
Correct answer: (A)
i and ii

320. A relation is said to be in 3 NF if

  1. it is in 2 NF
  2. non-key attributes are independent of one another
  3. key attribute is not dependent on part of a composite key
  4. has no multi-valued dependency
  1. i and iii
  2. i and iv
  3. i and ii
  4. ii and iv
Correct answer: (C)
i and ii
Page 32 of 61