Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started