Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: Normalization Data

    I am a newbie at normalization so bare with me please. I have a database that someone built that has only one table and all the fields are of course in this one table. It is an integrity nightmare. Anyway, I am going to get it to a 3NF form. I get the jist of getting it too this point, but I have a couple of questions about how to do one part of it. The db I am working with is ORACLE, but I am using ACCESS to manipulate it. My first issue is as follows:

    Primary Key Example: DESMIAIT01T (piece of equipment)
    A1ST_CONTACT (say Ed Smith)
    A1ST_CONTACT_FC
    A1ST_CONTACT_SC
    A1ST_CONTACT_TC
    A1ST_CONTACT_EMAIL
    A2ND_CONTACT (say Chucky Cheese)
    A2ND_CONTACT_FC
    ETC........ (This will go up to a potential 8 people who could be called if trouble with this piece of equipment exists. The contacts are placed in the order that they would need to be called. Now, if the equipment has a different code such as DESMIAIT02T, it may have the same people getting called out, but they would be in a different order such as A1ST_CONTACT would be Chucky Cheese and A2ND_CONTACT would be Ed Smith). Another site may have Ed Smith listed as the 4th or 5th CONTACT.

    Question: What is the best way to get this down to 3NF of just the CONTACT as the key of its table and the other fields that are dependent on CONTACT? I just can't get by how I am going to split this up so integrity is maintain. I want a table where the CONTACT is only in the table once, but how do I create the relationship to multiple fields on the other side.

    Second Question, which may seem like a duh issue: Once the database structure is constructed and the relationship design created, does the already existing data have to be split up and placed in the lowest, simplest tables manually? Will Access do the data move for me or do I do a create table off of a select query. I trying to envision how this can be split up and maintain the relationship. I maybe making this part harder than it really is.

    I really appreciate any help!!

    Jesse

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    First organize the data in First Normal Form.
    Next start with previous results to transform into Second Normal Form.
    Lastly start with 2nd Normal Form & transform into Third Normal Form.

    >Will Access do the data move for me
    No ACCESS is too dumb & must be told what to do with the data.

    Post the DDL (CREATE TABLE) for the existing table.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •