System Analysis and Design
391. A 3 NF relation is split into 4 NF
- by removing overlapping composite keys
- by splitting into relations which do not have more than one independent multivalued dependency
- removing multivalued dependency
- 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
- Prof_stud (professor, student_no)
Proj_stud ( project, student_no)
Prof_proj (professor, project)
Student (student_no, st_name, dept)
- Professor (professor, professor details)
Student (student_no, st_name, dept)
Project (project no, project details)
- Prof_stud (professor, student_no)
Prof_proj (professor, project)
- 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
- different views of portions of data requested by an application
- data only to selected applications as decided by an organization
- a uniform view of data to all applications
- 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
- conceptual data model
- external data model
- internal data model
- an entity-relation data model
Correct answer: (B)
external data model
395. Computer systems are designed by
- simplifying requirements of system
- breaking of the system into smaller self-contained co-operating subsystems
- breaking up the systems into independent parts
- modular design
Correct answer: (B)
breaking of the system into smaller self-contained co-operating subsystems
396. The advantages of object-oriented modelling are
- it allows easy integration of subsystems
- it promotes reuse of code written earlier
- it allows modification of some objects by other objects
- it allows data structures in objects to be modified by other objects
- i, ii
- i, iii
- ii, iii
- i, iv
Correct answer: (A)
i, ii
397. A query operation on a object
- has side effect
- has no side effects
- changes the state of an object
- is not allowed
Correct answer: (B)
has no side effects
398. Objects may be viewed as
- clients in a system
- servers in a system
- as both clients and servers in a system
- 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
- verb phrases in the statement
- noun phrases in the statement
- adjectives in the statement
- adverbs in the statement
Correct answer: (B)
noun phrases in the statement
400. Object-oriented system modelling using CRC method gives
- Java programs for the system
- C++ programs for the system
- Classes of the system, their responsibilities and collaborating classes
- Objective C programs for the system
Correct answer: (C)
Classes of the system, their responsibilities and collaborating classes