How to normalize this data


D

DawnTreader

Hello all

i have an incredibly complex situation that i am trying to get
somewhere on. i am working on creating a form that will record data
that in the past has not been well normalized.

currently the data looks like this:

Voltage Running Amperage Running
L1 / L2 L1 / L3 L2 / L3 L1 L2 L3
Main Motor 303 311 370 97 408 259
HX Motor 49 302 384 173 126 238
Vent / HX Motor 10 201 96 337 279 32
Water Pump Motor 184 355 243 167 324 320
Cooling Tower Motor 106 289 388 376 166 285
Radiator Motor 373 308 79 185 409 342

this data is just made up, but the idea is there.

i am working on having 3 tables to record this:

subtblSRCompressorVARs
SRCompressorSubDataID Autonumber - Part of Primary Key
ServiceReportID Number - Part of Primary Key value from Service
Report Table
ProductID Number
BlockID Number

subtblSRElectrical
ElectricalID Autonumber - Primary Key
SRCompressorSubDataID Number - Foreign Key
VoltageRecorded Number - Stores the value the Tech sees at the site
VoltageTypeID Number - Stores the column the value should be in
table above
DateEntered Date/Time - just so i know...

subtblSRVoltageTypes
VoltageTypeID Autonumber - Primary Key
VoltageDescription Text - Voltage Running L1/L2, Voltage Running L1/
L3, etc...

i am unsure if this is a good plan...

why? because i dont know how to make a grid where people enter the
values.

and now that i think about it i would also need a 4th table to store
which motor things are for, like this:

subtblSRMotorTypes
MotorID Autonumber - Primary Key
MotorDescription Text - Motor Description

is this level of normalization a good thing or will it make it
impossible for me to arrange in the layout like i have? or will the
layout be days worth of programming a form to do the job? additionally
what impact does this have on speed of the opening of the form?

any and all help appreciated :)
 
Ad

Advertisements

D

DawnTreader

Hello all

i have an incredibly complex situation that i am trying to get
somewhere on. i am working on creating a form that will record data
that in the past has not been well normalized.

currently the data looks like this:

                              Voltage Running                 Amperage Running
                        L1 / L2 L1 / L3 L2 / L3 L1      L2      L3
Main Motor      303     311     370     97      408     259
HX Motor                        49      302    384     173     126     238
Vent / HX Motor 10      201     96      337     279     32
Water Pump Motor        184     355     243     167     324     320
Cooling Tower Motor     106     289     388     376     166     285
Radiator Motor  373     308     79      185     409     342

this data is just made up, but the idea is there.

i am working on having 3 tables to record this:

subtblSRCompressorVARs
SRCompressorSubDataID   Autonumber      - Part of Primary Key
ServiceReportID         Number          - Part of Primary Key value from Service
Report Table
ProductID                       Number
BlockID                 Number

subtblSRElectrical
ElectricalID            Autonumber      - Primary Key
SRCompressorSubDataID   Number          - Foreign Key
VoltageRecorded         Number          - Stores the value the Tech sees at the site
VoltageTypeID           Number          - Stores the column the value should be in
table above
DateEntered             Date/Time              - just so i know...

subtblSRVoltageTypes
VoltageTypeID           Autonumber      - Primary Key
VoltageDescription              Text            - Voltage Running L1/L2, Voltage Running L1/
L3, etc...

i am unsure if this is a good plan...

why? because i dont know how to make a grid where people enter the
values.

and now that i think about it i would also need a 4th table to store
which motor things are for, like this:

subtblSRMotorTypes
MotorID         Autonumber              - Primary Key
MotorDescription        Text                    - Motor Description

is this level of normalization a good thing or will it make it
impossible for me to arrange in the layout like i have? or will the
layout be days worth of programming a form to do the job? additionally
what impact does this have on speed of the opening of the form?

any and all help appreciated :)

answered over at :
http://answers.microsoft.com/en-us/...c-68b599b31bf5?page=1&tm=1300395258460#footer
 

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