Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    1

    Unhappy Database Normalization

    Good Day All,

    I had 3NF normalization is there anyway that i can work backwards to 1NF? Below is the example of an 3NF.

    Employee (EmployeeNumber, FullName, Gender, Address, ContactNumber,Email, DeptID , ContractID, StartOfContact, EndOfContact, Notes)
    Department (DeptID,DeptName)
    Contract (ContractID,ContractDuration,HourlyRate,ContractPo sition)
    Job (JobID, JobName, JobStrTime, JobEndTime, JobDuration, DeptID)
    Location (LocationID,LocationName,WorkForceRequired, JobID)

    Pls assist me.

  2. #2
    Join Date
    Apr 2015
    Posts
    5
    Obviously we can go back to 2NF by grouping those entities and putting transitive dependencies back into.

    Nevertheless, I think the fastest way is to go directly to 1NF first, by grouping all attributes into a single entity. Then we remove partial dependencies to get 2NF.

    Cheers.

Tags for this 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
  •