Answered step by step
Verified Expert Solution
Link Copied!

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

22. Describe three situations that can be good candidates
for denormalization.
23. Describe several techniques that can improve performance of a database.
24. What is the diff erence between interfi le and intrafi le
clustering? Why are they used?
25. What is an index and how can it improve the performance of a system?
26. Describe what should be considered when estimating
the size of a database.
27. Why is it important to understand the initial and
projected size of a database during design?
28. What are some of the nonfunctional requirements that
can infl uence the design of the data management layer?
29. What are the key issues in deciding between using perfectly normalized databases and denormalized databases?
30. What is the primary purpose of the data access and
manipulation classes?
31. Why should the data access and manipulation classes
be dependent on the problem domain classes instead
of the other way around?
32. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

Students also viewed these Databases questions