Normalizing - ???

[twitchie]

It was suggested I learn more on normalizing to reduce the headaches in my report which is generated from tables. I went thru and trimmed some fat and came up with 2 tables as listed below:

tbl_ShiftNumbers:
Date
CustomerCount
ActualHours
LaborDollars
NetSales

tbl_DailyResults:
Date
ActualSales
CashOverShort
Deposit
VerificationCode
DineSales
DineCC
WindowSales
WindowCC
TakeSales
TakeCC
MealPeriod1Sales
MealPeriod1CC
MealPeriod2Sales
MealPeriod2CC
MealPeriod3Sales
MealPeriod31CC
MealPeriod4Sales
MealPeriod4CC
ForecastCC
ActualHours
LaborDollars
Coupons
PromoCompCount
PromoCompAmount
PolicsCount
PoliceAmount
DeletesCount
DeletesAmount
MgrMealsCount
MgrMealsAmount
EmpMealsCount
EmpMealsAmount

I know, we track a lot of numbers. What can I do to normalize these? Would there be any point? I'm just learning about normalization so your help is greatly appreciated! Thanx!

James

 

[lloydmav]

You ned to break down the information into groups of the same type of info (entities/tables). So you could have [Sales Information] in one table, [Shift Information] in another, hours?, labour? etc etc. Remember you will be creating a record in each of this tables, this needs to be identified uniquely so create a unique primary key field in each table. Eg Shift ID etc make these an autonumber. You also need to think about your relationships between tables.

Hope this helps

 

[Mile-O]

There's a good thread on normalisation on another forum: click here