System Analysis and Design

371. If an entity appears in not more than 5 relationships then it is a

  1. 1:1 relationship
  2. 1:5 relationship
  3. 5:1 relationship
  4. 5:5 relationship
Correct answer: (B)
1:5 relationship

372. Given an attribute x, another attribute y is dependent on it, if for a given x

  1. there are many y values
  2. there is only one value of y
  3. there is one or more y values
  4. there is none or one y value
Correct answer: (B)
there is only one value of y

373. Given the following relation
vendor order (vendor no, order no, vendor name, qty supplied , price/unit)
the second normal form relations are

  1. vendor (vendor no, vendor name)
    qty (qty supplied, price/unit)
    order (order no, qty supplied)
  2. vendor (vendor no, vendor name)
    order (order no, qty supplied, price/unit)
  3. vendor (vendor no, vendor name)
    order (order no, qty supplied, price/unit)
    vendor order (vendor no, order no)
  4. vendor (vendor no, vendor name, qty supplied, price/unit)
    vendor order (order no, vendor no)
Correct answer: (C)

vendor (vendor no, vendor name)
order (order no, qty supplied, price/unit)
vendor order (vendor no, order no)

374. A 3 NF relation is converted to BCNF by

  1. removing composite keys
  2. removing multivalued dependencies
  3. dependent attributes of overlapping composite keys are put in a separate relation
  4. dependent non-key attributes are put in a separate table
Correct answer: (C)
dependent attributes of overlapping composite keys are put in a separate relation

375. By redundancy in a file based system we mean that

  1. unnecessary data is stored
  2. same data is duplicated in many files
  3. data is unavailable
  4. files have redundant data
Correct answer: (B)
same data is duplicated in many files

376. A database is a

  1. collection of files
  2. collection of inputs and outputs of application
  3. collection of related data necessary to manage an organization
  4. data resource of an organization
Correct answer: (C)
collection of related data necessary to manage an organization

377. Database is

  1. an important resource of an organization
  2. not relevant to existing programs
  3. not relevant for future programs
  4. not as good as files as there is redundancy
Correct answer: (A)
an important resource of an organization

378. DBMS must implement management controls to

  1. control access rights to users
  2. implement audit trail when changes are made
  3. allow data to be used extensively in the organization
  4. duplicate databases
  1. i, ii
  2. ii, iii
  3. iii, iv
  4. i, iv
Correct answer: (A)
i, ii

379. A database administrator

  1. administers data in an organization
  2. controls all inputs and all outputs of programs
  3. is controller of data resources of an organization
  4. controls all data entry operators
Correct answer: (C)
is controller of data resources of an organization

380. Entities are identified from the word statement of a problem by

  1. picking words which are adjectives
  2. picking words which are nouns
  3. picking words which are verbs
  4. picking words which are pronouns
Correct answer: (B)
picking words which are nouns
Page 38 of 61