$364$ Chapter $9$ Data Management Layer Design

Describe three situations that can be good candidates

for denormalization.

Describe several techniques that can improve perfor$-$

mance of a database.

What is the difference between interfile and intrafile

clustering? Why are they used?

What is an index and how can it improve the perfor$-$

mance of a system?

Describe what should be considered when estimating

the size of a database.

Why is it important to understand the initial and

projected size of a database during design?

What are some of the nonfunctional requirements that

can influence the design of the data management layer?

What are the key issues in deciding between using per$-$

fectly normalized databases and denormalized databases?

What is the primary purpose of the data access and

manipulation classes?

Why should the data access and manipulation classes

be dependent on the problem domain classes instead

of the other way around?

Why should the object persistence classes be depend$-$

ent on the problem domain classes instead of the other

way around?