System Analysis and Design

351. By relation cardinality we mean

  1. number of items in a relationship
  2. number of relationships in which an entity can appear
  3. number of items in an entity
  4. number of entity sets which may be related to a given entity
Correct answer: (B)
number of relationships in which an entity can appear

352. Normalization of database is essential to

  1. avoid accidental deletion of required data when some data is deleted
  2. eliminate inconsistencies when a data item is modified in the database
  3. allows storage of data in a computer's disk
  4. use a database management system
  1. i and iii
  2. i and ii
  3. ii and iii
  4. ii and iv
Correct answer: (B)
i and ii

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

354. Given the following relation
Student (roll no, name, course no, course max. marks, year of study, address)
The corresponding 3 NF relations are

  1. student (roll no, name, year of study, address)
    course (course no, course max. marks)
  2. student (roll no, name, year of study, address)
    student (roll no, course no) course (course no, course max. marks)
  3. student (roll no, name, address)
    year (roll no, year of study) course (course no, course max. marks)
  4. student (roll no, name, address)
    course (course no, course max. marks, year of study)
Correct answer: (B)

student (roll no, name, year of study, address)
student (roll no, course no) course (course no, course max. marks)/p>

355. The project guidance relation of Exercise 10.8.3 needs further normalization to 5 NF because

  1. There are too many multivalued dependencies
  2. Multivalued dependency and simple dependency are mixed in the 4 NF relation
  3. Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects
  4. 4 NF relations have composite keys
Correct answer: (C)
Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects

356. Data availability is often difficult in file based system

  1. as files are duplicated
  2. as unnecessary data are stored in files
  3. as one has to search different files and these files may be in different update states
  4. redundant data are stored in files 8.5.4 Management policy changes are difficult to implement in a file based system because
Correct answer: (C)
as one has to search different files and these files may be in different update states

357. A database models data so that it is

  1. appropriate for application
  2. independent of application program
  3. optimized for most frequent applications
  4. optimized for all applications
Correct answer: (B)
independent of application program

358. Data integrity is ensured by

  1. good data editing
  2. propagating data changes to all data items
  3. preventing unauthorized access
  4. preventing data duplication
Correct answer: (B)
propagating data changes to all data items

359. A check pointing system is needed

  1. to ensure system security
  2. to recover from transient faults
  3. to ensure system privacy
  4. to ensure system integrity
Correct answer: (B)
to recover from transient faults

360. A good database design

  1. is expandable with growth and changes in organization
  2. easy to change when software changes
  3. ensures data integrity
  4. allows access to only authorized users
  1. i, ii
  2. ii, iii
  3. i, ii, iii, iv
  4. i, ii, iii
Correct answer: (C)
i, ii, iii, iv
Page 36 of 61