Results 1 to 2 of 2

Thread: How to do normalization on a table to the third form using SQL

  1. 08-08-2008, 07:38 PM #1
    firulais01
    firulais01 is offline Registered User
    Join Date
    Aug 2008
    Posts
    1

    How to do normalization on a table to the third form using SQL

    I need help with this table I want to make it to the third form of normalization. I also need to identify the names of the table and their columns. Could you help me please!!!! Above is the is the information for the table:

    EmployeeNumber

    1
    2
    3

    EmployeeName

    John Stewart
    Bill Murray
    Nancy Drew

    Project1

    Accounting
    Payroll Processing
    Inventory Maintenance

    Project2

    Payroll Processing
    Accounting

    Project3

    Inventory Maintenance

    Team

    IT Development
    IT Development
    IT Networking

    Hours1

    100
    76
    45

    Hours2

    150
    80

    Hours3

    93

    ProjectManager1

    2
    2
    3
    Reply With Quote Reply With Quote
  2. 09-03-2008, 01:29 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Have you tried anything so far? Please post your initial design.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules