Database week 2 & 3

what are the 3 levels in ANSI-SPARC Database Architecture ?

• designer,

  developer and administrator

• conceptual, external and internal

• conceptual, detailed and internal

• conceptual, logical and physical

which of the three levels contains the relationship between entities ?

• external

• conceptual

• internal

which of the three levels describes how the data is stored?

• external

• conceptual

• internal

what is abstraction?

• providing a simplified view and hiding away the complex inner workings

• making simple things more complicated

• a new energy drink

the two conceptual models we studied are?

• context model and key model

• key model and fully attributed model

• context model and fully attributed model

• fully attributed model and physical model

which of the following models contains the attribute names?

• context model

• fully attributed

how many phases are in the database life cycle (DBLC)?

• 6

• 5

• 7

• 8

in which DBLC phase do we define problems, constraints and objectives

• phase 1: initial study

• phase 2: database design

• phase 3: implementation

the phase 2: database design process is

• sequential

• iterative

in which DBLC phase do we draw ERD diagrams?

• initial study

• database design

• implementation and loading

• maintenance and evolution