How to normalize this data

Discussion in 'Access Table Design' started by DawnTreader, Mar 17, 2011.

  1. DawnTreader

    DawnTreader Guest

    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 :)
     
    DawnTreader, Mar 17, 2011
    #1
    1. Advertisements

  2. DawnTreader

    DawnTreader Guest

    On Mar 17, 11:40 am, DawnTreader <> wrote:
    > 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
     
    DawnTreader, Mar 17, 2011
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Applebaum

    How to normalize this?

    Applebaum, Jul 9, 2003, in forum: Access Table Design
    Replies:
    5
    Views:
    124
    Allen Browne
    Jul 9, 2003
  2. Gary Stockton

    Normalize a table into two related tables

    Gary Stockton, Aug 17, 2003, in forum: Access Table Design
    Replies:
    0
    Views:
    93
    Gary Stockton
    Aug 17, 2003
  3. Microsoft

    normalize tables

    Microsoft, Jan 18, 2004, in forum: Access Table Design
    Replies:
    4
    Views:
    164
    Microsoft
    Jan 19, 2004
  4. Amit
    Replies:
    1
    Views:
    86
    Duane Hookom
    Jan 27, 2005
  5. Karl Burrows

    Used Table Analyzer to Normalize, Form Update Errors

    Karl Burrows, Aug 29, 2005, in forum: Access Table Design
    Replies:
    2
    Views:
    100
    Karl Burrows
    Aug 31, 2005
  6. Monica

    normalize/analyze multiple databases

    Monica, Feb 3, 2006, in forum: Access Table Design
    Replies:
    4
    Views:
    106
    mnature
    Feb 6, 2006
  7. variance1
    Replies:
    8
    Views:
    156
    Jeff Boyce
    Mar 10, 2006
  8. M Skabialka

    How do I best normalize this data?

    M Skabialka, Jul 19, 2007, in forum: Access Table Design
    Replies:
    3
    Views:
    124
    M Skabialka
    Jul 19, 2007
Loading...