System Analysis and Design
371. If an entity appears in not more than 5 relationships then it is a
- 1:1 relationship
- 1:5 relationship
- 5:1 relationship
- 5:5 relationship
Correct answer: (B)
1:5 relationship
372. Given an attribute x, another attribute y is dependent on it, if for a given x
- there are many y values
- there is only one value of y
- there is one or more y values
- there is none or one y value
Correct answer: (B)
there is only one value of y
373. Given the following relation
vendor order (vendor no, order no, vendor name, qty supplied , price/unit)
the second normal form relations are
- vendor (vendor no, vendor name)
qty (qty supplied, price/unit)
order (order no, qty supplied)
- vendor (vendor no, vendor name)
order (order no, qty supplied, price/unit)
- vendor (vendor no, vendor name)
order (order no, qty supplied, price/unit)
vendor order (vendor no, order no)
- vendor (vendor no, vendor name, qty supplied, price/unit)
vendor order (order no, vendor no)
Correct answer: (C)
vendor (vendor no, vendor name)
order (order no, qty supplied, price/unit)
vendor order (vendor no, order no)
374. A 3 NF relation is converted to BCNF by
- removing composite keys
- removing multivalued dependencies
- dependent attributes of overlapping composite keys are put in a separate relation
- dependent non-key attributes are put in a separate table
Correct answer: (C)
dependent attributes of overlapping composite keys are put in a separate relation
375. By redundancy in a file based system we mean that
- unnecessary data is stored
- same data is duplicated in many files
- data is unavailable
- files have redundant data
Correct answer: (B)
same data is duplicated in many files
376. A database is a
- collection of files
- collection of inputs and outputs of application
- collection of related data necessary to manage an organization
- data resource of an organization
Correct answer: (C)
collection of related data necessary to manage an organization
377. Database is
- an important resource of an organization
- not relevant to existing programs
- not relevant for future programs
- not as good as files as there is redundancy
Correct answer: (A)
an important resource of an organization
378. DBMS must implement management controls to
- control access rights to users
- implement audit trail when changes are made
- allow data to be used extensively in the organization
- duplicate databases
- i, ii
- ii, iii
- iii, iv
- i, iv
Correct answer: (A)
i, ii
379. A database administrator
- administers data in an organization
- controls all inputs and all outputs of programs
- is controller of data resources of an organization
- controls all data entry operators
Correct answer: (C)
is controller of data resources of an organization
380. Entities 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: (B)
picking words which are nouns