Normalizing Tables Help Needed.

G

Guest

Looking for some guidance on setting up a database for performing some metric
calculations.
This data consists of the following:
LTL Orders
TL Orders
Parcel Orders

LTLLines
TL Lines
Parcel Lines

LTL Peices
TL Peices
Parcel Peices

This data is collected for today's date. yeasterdays date (past due), and
All the rest of the past due after yeasterdays date.

The above data is collected each day.

The second set of collected is Hours.
Hours are broken up by 3 shifts Total Labor hours for each task. (About 14
tasks.)

I need to then do calculation on the 2 types of data and end up with s report.
The question is does anyone have a suggestion on how to normalize tables for
this?
 
G

Guest

Before I precede let me know if the hierarchy is laid out correctly.
LTL_Orders
LTL_Lines
LTL_Pieces

Parcel_Orders
Parcel_Lines
Parcel_Pieces

TL_Orders
TL_Lines
TL_Pieces
 
G

Guest

I appoligize for the delay on a reply. I was out of the state for a little
while.
Anyways
Yes. You are correct.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top