Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2014
    Posts
    3

    Unanswered: Noob Normalization question Please Helppp

    http://i.imgur.com/REgUMF4.png

    I have to normalize this table in the link above


    EmployeeName EmployeeSalary

    Erica Jones 64,000.00
    Donna Smith 70,000.00
    Eric Parks 58,000.00

    Project ID EmployeeName
    100 A Erica Jones
    100 A Donna Smith
    100 B Donna Smith
    200 A Erica Jones
    200 B Erica Jones
    200 C Donna Smith
    200 C Eric Parks
    200 D Eric Parks


    this is what i have so far....The textbook I am reading from really sucks so if you guys can please help me and show me how to normalize this table correctly it would be much appreciated!

  2. #2
    Join Date
    Sep 2014
    Posts
    3

    Normalization NOOB needs help please

    http://i.imgur.com/REgUMF4.png

    I need help normalizing this table ^^

    This is what I have so far:

    EmployeeName EmployeeSalary

    Erica Jones 64,000.00
    Donna Smith 70,000.00
    Eric Parks 58,000.00

    Project ID EmployeeName
    100 A Erica Jones
    100 A Donna Smith
    100 B Donna Smith
    200 A Erica Jones
    200 B Erica Jones
    200 C Donna Smith
    200 C Eric Parks
    200 D Eric Parks

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What you've done so far meets the requirements for first normal form. You may already be done with this assignment.

    What are the exact requirements? Providing a link to the assignment would be your best bet, since then we could be certain that we addressed all of the requirements.

    Are you looking for hints, or do you want us to actually complete your homework for you?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Apr 2004
    Location
    Arizona
    Posts
    75
    I agree with Pat that is this is homework then it is hard to answer because there are many ways to normalize hence all of the normalization rules, and it would be hard to answer this question unless we know what the teacher is looking for which is why you should do your own work.

    But, if this is for a project at work or personal project, I would probably separate the data into 3 tables each with a unique primary key and foreign keys to setup your joins. Are you going to need a many to many relationship to these data elements? Like will the employees have different salaries depending on the project they are working on.

    Hope that helps.

  5. #5
    Join Date
    Sep 2014
    Posts
    3
    thanks guys what I had was correct.

Posting Permissions

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