Learning Goal: I’m working on a computer science writing question and need an explanation and answer to help me learn.
Answer the following questions:
What are the objectives of selecting a data type for a field?
Explain why you sometimes must reserve much more space for a numeric field than any of the initial stored values requires.
Explain why normalize relations may not be the most efficient design.
Explain why an index is useful only if there is sufficient variety in the values of an attribute.
What is the difference between a dynamic view and a materialized view?
List six potential benefits of having in SQL standard that is widely accepted.