Friday, September 27, 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment