System Analysis and Design
361. Pick entity set from the following
- all vendors supplying to an organization
- vendors and organizations they supply
- vendors and transporters
- a vendor supplying to many organizations
Correct answer: (A)
all vendors supplying to an organization
362. If an entity appears in N relationships then it is
- a 1:1 relationship
- a 1:N relationship
- a N:1 relationship
- a N:M relationship
Correct answer: (B)
a 1:N relationship
363. A relation which is in a higher normal form
- implies that it also qualifies to be in lower normal form
- does not necessarily satisfy the conditions of lower normal form
- is included in the lower normal form
- is independent of lower normal forms
Correct answer: (A)
implies that it also qualifies to be in lower normal form
364. A relation is said to be in BCNF when
- it has overlapping composite keys
- it has no composite keys
- it has no multivalued dependencies
- it has no overlapping composite keys which have related attributes
Correct answer: (D)
it has no overlapping composite keys which have related attributes
365. TEACHER-STUDENT relation in Mini-case example 2 is required because
- it is in 3 NF
- it has a multivalued key
- it has a composite key with multivalued dependency relation
- Without this relation database is incomplete and some queries cannot be answered
Correct answer: (D)
Without this relation database is incomplete and some queries cannot be answered
366. A DBMS is
- another name for database system
- independent of a database
- dependent on application programs
- is a set of procedures which manage a database
Correct answer: (D)
is a set of procedures which manage a database
367. DBMS
- does not allow replication of data
- allows controlled replication of data if it improves performance
- does not allow common data to be duplicated
- does not allow replication as it adversely affects reliability
Correct answer: (B)
allows controlled replication of data if it improves performance
368. A DBMS has the following components
- a data definition language
- a query language
- a security system
- audit trail
- i, ii
- i, ii, iii
- i, ii, iii, iv
- i, ii, iv
Correct answer: (C)
i, ii, iii, iv
369. Access right to a database is controlled by
- top management
- system designer
- system analyst
- database administrator
Correct answer: (D)
database administrator
370. The attributes of relationship teaches in teacher teaches course should be
- teacher code, teacher name, dept, phone no
- course no, course name, semester offered, credits
- teacher code, course no, semester no
- teacher code, course no, teacher name, dept, phone no
Correct answer: (C)
teacher code, course no, semester no