System Analysis and Design

311. Attributes are

1. properties of relationship
2. attributed to entities
3. properties of members of an entity set

1. i
2. i and ii
3. i and iii
4. iii

View answer

312. A relation is

1. an entity
2. a relationship
3. members of a relationship set
4. members of an entity set or a relationship set

View answer

313. Normalization is a process of restructuring a relation to

1. minimize duplication of data in a database
2. maximize duplication of data to ensure reliability
3. make it of uniform size
4. allow addition of data

View answer

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

View answer

315. A relationship is

1. an item in an application
2. a meaningful dependency between entities
3. a collection of related entities
4. related data

View answer

316. One entity may be

1. related to only one other entity
2. related to itself
3. related to only two other entities
4. related to many other entities

View answer

317. Rows of a relation are called

1. tuples
2. a relation row
3. a data structure
4. an entity

View answer

318. The process of normalization

1. is automatic using a computer program
2. requires one to understand dependency between attributes
3. is manual and requires semantic information
4. is finding the key of a relation

View answer

319. An attribute y may be functionally dependent on

1. a composite attribute x,y
2. a single attribute x
3. no attribute

1. i and ii
2. i and iii
3. ii and iii
4. iii

View answer

320. A relation is said to be in 3 NF if

1. it is in 2 NF
2. non-key attributes are independent of one another
3. key attribute is not dependent on part of a composite key
4. has no multi-valued dependency

1. i and iii
2. i and iv
3. i and ii
4. ii and iv

View answer