chAptEr 5

Question 1

What is a data model?

Answer 1

A formal way for representing data used and created by a business system.

Question 2

List the 2 types of data models.

Answer 2

Logical data model
Physical data model

Question 3

List the properties of a logical data model.

Answer 3

Done in Analysis phase.
Shows organization on data without indicating how it stored, created and manipulated.

Question 4

List the properties of a physical data model.

Answer 4

Done in Design phase.
Shows how data is stored in databases.

Question 5

What is an entity relationship diagram (ERD)?

Answer 5

A graphic representation that shows information that is created, stored, and used by a business system.

Question 6

What is normalization?

Answer 6

Process used by analysts to validate data models.

Question 7

What is the purpose of data modeling?

Answer 7

To make data organization flexible and adaptable to unanticipated business requirements.

Question 8

List the type of identifier.

Answer 8

Concatenated identifier
Single identifier
Identifier to be added later.