System Analysis and Design

391. A 3 NF relation is split into 4 NF

  1. by removing overlapping composite keys
  2. by splitting into relations which do not have more than one independent multivalued dependency
  3. removing multivalued dependency
  4. by putting dependent non-key attribute in a separate table
Correct answer: (B)
by splitting into relations which do not have more than one independent multivalued dependency

392. 5 NF relations equivalent to the relation of Exercise 10.8.3 are

  1. Prof_stud (professor, student_no)
    Proj_stud ( project, student_no)
    Prof_proj (professor, project)
    Student (student_no, st_name, dept)
  2. Professor (professor, professor details)
    Student (student_no, st_name, dept)
    Project (project no, project details)
  3. Prof_stud (professor, student_no)
    Prof_proj (professor, project)
  4. Prof_stud (professor, student_no)
    Stud_proj (student_no, project)
    Student (student_no, st_name, dept)
Correct answer: (A)

Prof_stud (professor, student_no)
Proj_stud ( project, student_no)
Prof_proj (professor, project)
Student (student_no, st_name, dept)

393. A database should be designed to allow providing

  1. different views of portions of data requested by an application
  2. data only to selected applications as decided by an organization
  3. a uniform view of data to all applications
  4. data to all applications
Correct answer: (A)
different views of portions of data requested by an application

394. A subset of logical data model accessed by programmers is called a

  1. conceptual data model
  2. external data model
  3. internal data model
  4. an entity-relation data model
Correct answer: (B)
external data model

395. Computer systems are designed by

  1. simplifying requirements of system
  2. breaking of the system into smaller self-contained co-operating subsystems
  3. breaking up the systems into independent parts
  4. modular design
Correct answer: (B)
breaking of the system into smaller self-contained co-operating subsystems

396. The advantages of object-oriented modelling are

  1. it allows easy integration of subsystems
  2. it promotes reuse of code written earlier
  3. it allows modification of some objects by other objects
  4. it allows data structures in objects to be modified by other objects
  1. i, ii
  2. i, iii
  3. ii, iii
  4. i, iv
Correct answer: (A)
i, ii

397. A query operation on a object

  1. has side effect
  2. has no side effects
  3. changes the state of an object
  4. is not allowed
Correct answer: (B)
has no side effects

398. Objects may be viewed as

  1. clients in a system
  2. servers in a system
  3. as both clients and servers in a system
  4. neither as clients nor as servers in a system
Correct answer: (C)
as both clients and servers in a system

399. Given a word statement of a problem potential objects are identified by selecting

  1. verb phrases in the statement
  2. noun phrases in the statement
  3. adjectives in the statement
  4. adverbs in the statement
Correct answer: (B)
noun phrases in the statement

400. Object-oriented system modelling using CRC method gives

  1. Java programs for the system
  2. C++ programs for the system
  3. Classes of the system, their responsibilities and collaborating classes
  4. Objective C programs for the system
Correct answer: (C)
Classes of the system, their responsibilities and collaborating classes
Page 40 of 61