Under what circumstances would you want to denormalize a logical data model? Use examples to illustrate your answer.
What will be an ideal response?
Generally, if overall performance needs to be improved, controlled redundancy can be introduced
(see also Step 7).
Examples:
If queries on staff always require the branch address, this attribute could be posted into staff.
The effect on updating would be minimal if branch data was relatively static, and it removes a
join from the query.
If the number of staff for each branch was often required with branch details, a derived
attribute could be placed in branch. This would remove the need to access and repeatedly
count the relevant records in staff. When staff join or leave a branch, this attribute would need
to be updated.
You might also like to view...
MC Which of the following sticky values causes the component to stretch the entire width of its container?
a) S+E. b) W+E. c) N+S. d) Both b and c.
Many font options are located in the Font Dialog Box Launcher in the __________.
A. FONT tab B. Font group C. Font ribbon D. Font box
Write a method called sumRange that accepts two integer parameters that represent a range. Issue an error message and return zero if the second parameter is less than the first. Otherwise, the method should return the sum of the integers in that range (inclusive).
What will be an ideal response?
The name of the company ________ has entered public vocabulary as a verb meaning to conduct a Web search
Fill in the blank(s) with correct word