System Analysis and Design
381. Relationships are identified from the word statement of a problem by
- picking words which are adjectives
- picking words which are nouns
- picking words which are verbs
- picking words which are pronouns
Correct answer: (C)
picking words which are verbs
382. The rows of a relation
- must be in specified order
- may be in any order
- in ascending order of key
- in descending order of key
Correct answer: (B)
may be in any order
383. Given the following relation
vendor order ( vendor no, order no, vendor name, qty supplied, price/unit) it is not in 2 NF because
- it is not in 1 NF
- it has a composite key
- non-key attribute vendor name is dependent on vendor no. which is one part of the composite key
- Qty supplied and price/unit are dependent
Correct answer: (C)
non-key attribute vendor name is dependent on vendor no. which is one part of the composite key
384. Fourth normal form (4 NF) relations are needed when
- there are multivalued dependencies between attributes in composite key
- there are more than one composite key
- there are two or more overlapping composite keys
- there are multivalued dependency between non-key attributes
Correct answer: (A)
there are multivalued dependencies between attributes in composite key
385. Data integrity in a file based system may be lost because
- the same variable may have different values in different files
- files are duplicated
- unnecessary data is stored in files
- redundant data is stored in files
Correct answer: (A)
the same variable may have different values in different files
386. A DBMS
- is a set of procedures
- manages a database
- is a set of procedures to manage a database to provide data as required by applications
- provides data to applications
Correct answer: (C)
is a set of procedures to manage a database to provide data as required by applications
387. Data independence allows
- sharing the same database by several applications
- extensive modification of applications
- no data sharing between applications
- elimination of several application programs
Correct answer: (A)
sharing the same database by several applications
388. A conceptual data model is converted using a Relational Data Base Management System to a
- logical data model
- external data model
- internal data model
- an entity-relation data model
Correct answer: (A)
logical data model
389. The columns of a relation
- must be in specified order
- may be in any order
- with key field in first column
- with largest width column last
Correct answer: (B)
may be in any order
390. Given the following relation it is not 3 NF because
Student (roll no, name, course no, course max. marks, year of study, address)
- it is not in 2 NF
- it does not have composite key
- non-key attributes course no and course max. marks are functionally dependent
- it has more than 3 non-key attributes
Correct answer: (C)
non-key attributes course no and course max. marks are functionally dependent