Question: 2 2 . Describe three situations that can be good candidates for denormalization. 2 3 . Describe several techniques that can improve performance of a
Describe three situations that can be good candidates
for denormalization.
Describe several techniques that can improve performance of a database.
What is the diff erence between interfi le and intrafi le
clustering? Why are they used?
What is an index and how can it improve the performance 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 infl uence the design of the data management layer?
What are the key issues in deciding between using perfectly 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 dependent on the problem domain classes instead of the other
way around?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
