System Analysis and Design

301. An entity is

  1. a collection of items in an application
  2. a distinct real world item in an application
  3. an inanimate object in an application
  4. a data structure
Correct answer: (B)
a distinct real world item in an application

302. In an E-R diagram entities are represented by

  1. circles
  2. rectangles
  3. diamond shaped box
  4. ellipse
Correct answer: (B)
rectangles

303. A student can take not more than 5 subjects in a semester. The number of students allowed in a subject in a semester is not more than 40. The student
- subject relationship is:

  1. 5:40
  2. 40:5
  3. N:5
  4. 40:M
Correct answer: (B)
40:5

304. The relation given in Exercise 10.4.4 may be converted to 1 NF relation by

  1. eliminating composite attributes
  2. eliminating common attributes
  3. duplicating common attributes as many times as lines in corresponding attributes
  4. putting composite attributes in a separate table
Correct answer: (C)
duplicating common attributes as many times as lines in corresponding attributes

305. Given the relation of Exercise 10.7.5 it is reduced to the following BCNF relation

  1. Supplier (s_ids, s_name)
    Purchase (s_id, p_order, qty)
  2. Supplier (s_id, s_name)
    Purchase (p_order, qty)
  3. Purchase (s_id, p_order)
    Supplier (s_name, qty)
  4. Supplier (s_id, s_name, qty)
    Purchase (s_id, p_order)
Correct answer: (A)
Supplier (s_ids, s_name) Purchase (s_id, p_order, qty)

306. The ORDER PLACED FOR relation in Mini-case example 1 has the composite key order no, item code because

  1. item code has a multivalued dependency with order no.
  2. the non-key attributes are dependent on the composite key order no, item code
  3. if order no is the only key we cannot find qty. ordered, price/unit, delivery time
  4. if item code is the only key we cannot find order no. uniquely
Correct answer: (A)
item code has a multivalued dependency with order no.

307. By data independence we mean application programs

  1. do not need data
  2. may be developed independent of data
  3. may be developed without knowing the organization of data
  4. may be developed with independent data
Correct answer: (C)
may be developed without knowing the organization of data

308. By data security in DBMS we mean

  1. preventing access to data
  2. allowing access to data only to authorized users
  3. preventing changing data
  4. introducing integrity constraints
Correct answer: (B)
allowing access to data only to authorized users

309. Designing physical model of DBMS requires information on

  1. data volume
  2. frequency of access to data
  3. programming language used
  4. secondary memory characteristics
  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. i, ii, iv
Correct answer: (D)
i, ii, iv

310. Pick entities from the following:

  1. vendor
  2. student
  3. attends
  4. km/hour
  1. i, ii, iii
  2. i, ii, iv
  3. i and ii
  4. iii and iv
Correct answer: (C)
i and ii
Previous
Page 31 of 61
Next