Chapter 3 - Database Life Cycle

The following that is correct to describe bottom-up approach in database system design

• Identify data sets

• Identify data elements

• Defines attributes

• Define entities

Answer explanation

Slide 14 Chapter 3.

The following that is correct to describe top-down approach in database system design

• Identify data sets

• Identify data elements

• Defines attributes

• Define entities

Answer explanation

Slide 14 Chapter 3.

Which one is correct for top down approach in designing database system.

• Entity -> Concept-> Attribute

• Concept->Attribute ->Entity

• Concept->Entity->Attribute

• Attribute->Entity->Concept

Answer explanation

Phase 2 in DBLC is design. Remember the difference between two approaches of top down and bottom up.

Which one is correct for bottom up approach in designing database system.

• Entity -> Concept-> Attribute

• Concept->Attribute ->Entity

• Concept->Entity->Attribute

• Attribute->Entity->Concept

Answer explanation

Phase 2 in DBLC is design. Remember the difference between two approaches of top down and bottom up.

Regardless, top down or bottom up design approaches in DBLC , defining entities is always placed in level

• One

• Two

• Three

Answer explanation

Remember this diagram to differentiate between the top-down and bottom up approach in database design phase.

In designing a database system, it is possible to define the attributes first before entities.

• TRUE

• FALSE

Answer explanation

Attributes or data elements first to identify is a bottom up approach.

Factors that affecting in DBMS selection

• Cost

• Entities

• Features/Tools

• Hardware requirements

Answer explanation

Entities is a part of conceptual design process in DBLC.

Storage features depend on the

• DBMS

• Hardware

• ER model

Answer explanation

DBMS is a software

ER model is a concept

Access features depend on the

• DBMS

• Hardware

• ER model

Answer explanation

ER model is a concept while hardware is a physical structure of the storage.

It used to verify against the processes of the proposed system.

• DBMS

• Hardware

• ER model

Answer explanation

We used ER model to verify with the processes and implementation.