Wednesday, August 28, 2019

Complex SQL Benefits Research Paper Example | Topics and Well Written Essays - 250 words

Complex SQL Benefits - Research Paper Example (2) It would be very difficult to incorporate â€Å"Driver Performance by Month† in parallel with Month of Customer’s total shipments/weights in the Customer Summary Report, especially when different months appear in both tables. (3) A typical SQL Statement will have to be written determining/rating the drivers’ performance on the basis of # of manifests on time and/or delivered late. It involves calculation + IF and THEN conditions statements I understand that the Driver Table may be created on a need basis because the purpose of this table is to get the status of Drivers’ Performance, which is also being recorded/saved into the permanent Customer File. I feel â€Å"Driver Performance by Month† in the Customer File is against the concept of table normalization because the drivers’ performance is nothing to do in the Customer Table carrying customers’ transactions.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.