Need an argumentative essay on Complex SQL Benefits. Needs to be 1 pages. Please no plagiarism.
(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.
