System Analysis and Design

3401. If an entity appears in only one relationship then it is

  1. a 1:1 relationship
  2. a 1:N relationship
  3. a N:1 relationship
  4. a N:M relationship
Correct answer: (A)
a 1:1 relationship

3402. Relations are used in logical database design because

  1. sound theory of relations facilitates systematic design of relational databases
  2. they are very popular
  3. they are flat files and easy to store and retrieve from computer's memory
  4. E-R diagrams allow design of relations
  1. i and ii
  2. i and iii
  3. ii and iii
  4. iii and iv
Correct answer: (B)
i and iii

340. A relation is said to be in 1NF if

  1. there is no duplication of data
  2. there are no composite attributes in the relation
  3. there are only a few composite attributes
  4. all attributes are of uniform type
Correct answer: (B)
there are no composite attributes in the relation

344. A relation is said to be in 2 NF if

  1. it is in 1 NF
  2. non-key attributes dependent on key attribute
  3. non-key attributes are independent of one another
  4. if it has a composite key, no non-key attribute should be dependent on part of the composite key
  1. i, ii, iii
  2. i and ii
  3. i, ii, iv
  4. i, iv
Correct answer: (C)
i, ii, iv

345. Boye Codd Normal Form (BCNF) is needed when

  1. two non-key attributes are dependent
  2. there is more then one possible composite key
  3. there are two or more possible composite overlapping keys and one attribute of a composite key is dependent on an attribute of another composite key
  4. there are two possible keys and they are dependent on one another
Correct answer: (C)
there are two or more possible composite overlapping keys and one attribute of a composite key is dependent on an attribute of another composite key

346. A relation project guidance Project Guidance (professor, project, student no. st-name, dept)

A professor can give many projects to many students
A project will have many students
A project may be guided by many professors

The 4 NF relation corresponding to this are

  1. Prof_Project (professor, st_name, dept)
    Proj_stud (project, student no.)
  2. Prof_stud (professor, student no)
    Proj_stud (project, student no)
    Student (student no, st_name, dept)
  3. Student (student no, st_name, dept)
    Professor(professor, project)
  4. Professor( professor, project, dept)
    Student (student no, st_name, dept)
Correct answer: (B)

Prof_stud (professor, student no)
Proj_stud (project, student no)
Student (student no, st_name, dept)

347. One of the main objectives of a DBMS is to

  1. Create a database for an organization
  2. Facilitate sharing of a database by current and future applications
  3. Allow sharing application programs
  4. Replace file based systems
Correct answer: (B)
Facilitate sharing of a database by current and future applications

348. By data integrity we mean

  1. maintaining consistent data values
  2. integrated data values
  3. banning improper access to data
  4. not leaking data values
Correct answer: (A)
maintaining consistent data values

349. A good database design

  1. caters primarily to current needs
  2. caters to current and future needs as organizations grow
  3. has to be modified when hardware is upgraded
  4. ensures data security
  1. i, ii
  2. i, ii, iii
  3. ii, iv
  4. iii, iv
Correct answer: (C)
ii, iv

350. The entity set is a

  1. set of entities
  2. collection of different entities
  3. collection of related entities
  4. collection of similar entities
Correct answer: (D)
collection of similar entities
Page 35 of 61