System Analysis and Design
331. The number of normal forms which has been proposed and discussed in the book are
- 3
- 4
- 5
- 6
Correct answer: (D)
6
332. A third Normal Form (3 NF) relation should
- be in 2 NF
- not have complete key
- not be 1 NF
- should not have non-key attributes depend on key attribute
Correct answer: (A)
be in 2 NF
333. BCNF is needed because
- otherwise tuples may be duplicated
- when a data is deleted tuples may be lost
- updating is otherwise difficult
- when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples
Correct answer: (D)
when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples
334. TEACHES-COURSES relation in Mini-case example 2 is in
- 3 NF. Does not need any further normalization
- BCNF
- 4 NF
- unnormalized form
Correct answer: (A)
3 NF. Does not need any further normalization
335. Some of the objectives of a database management system are to
- minimize duplication of data
- ensure centralized management control of data
- ease retrieval of data
- maintain a data dictionary
- i and ii
- i, ii and iv
- i and iii
- i, ii and iii
Correct answer: (D)
i, ii and iii
336. Data independence allows
- no changes in application programs
- change in database without affecting application programs
- hardware to be changed without affecting application programs
- system software to be changed without affecting application programs
- i, ii
- ii, iii
- ii, iii, iv
- i, ii, iv
Correct answer: (C)
ii, iii, iv
337. An E-R modelling for given application leads to
- conceptual data model
- logical data model
- external data model
- internal data model
Correct answer: (A)
conceptual data model
338. The responsibilities of a database administrator includes
- maintenance of data dictionary
- ensuring security of database
- ensuring privacy and integrity of data
- obtain an E-R model
- i, ii
- i, ii, iii
- i, ii, iii, iv
- ii, iii, iv
Correct answer: (B)
i, ii, iii
339. Pick the meaningful relationship between entities
- vendor supplies goods
- vendor talks with customers
- vendor complains to vendor
- vendor asks prices
Correct answer: (A)
vendor supplies goods
340. In an E-R diagram relationship is represented by
- circles
- rectangles
- diamond shaped box
- ellipse
Correct answer: (C)
diamond shaped box