MIS 610 Topic 4 DQ 1
Using your experiences thus far regarding NULL values and aggregation, discuss when it is a good idea to assume there might be NULL data in your records. Explain why extra coding may be worthwhile. Discuss whether one should only do the extra work involved in this process when there is an issue. Justify your ideas with support from the Topic Materials or relevant industry examples.
MIS 610 Topic 4 DQ 2
Determinism of a function is one of several properties of user-defined functions that determine the ability of SQL to index results. When and for what purposes would you choose to use deterministic versus nondeterministic functions to arrive at your desired results? Justify your ideas with support from the Topic Materials or relevant industry examples.