Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2013
    Posts
    1

    Database Normalization

    Hello

    I have been given a task to normalize a data structure which is used to fill a form that contains information about the company applied to, such as the role and required strengths/qualifications.

    It will also contain my strenghts, qualifications, cv , outcome etc.

    Thing is, I don't exactly understand the normalization process, I did bring the unnormalized structure into 3rd normal form, however I'm not sure if i've done it correctly.

    I'd appreciate if you could look over it and eventually suggest any improvements.

    Un-normalised structure

    Application(CompanyName, CompanyInformation, Role, reqStrengths, reqQuals, myStrengths, myEvidence, mySatisfaction,myQual, qualDate, qualGrade, Aim, Relevance, CV, CovLetter, dateSent, Response, dateInterview, Outcome, Reflection)

    Identifying functional dependencies

    Company  (CompanyName, CompanyInformation, Role, reqStrengths, reqQuals, CV, CovLetter, dateSent, Response, dateInterview, Outcome, Reflection)
    MyStrengths (myStrengths, myEvidence, mySatisfaction)
    MyQualifications (myQuals, qualDate, qualGrade)
    MyAims(Aim, Relevance)

    First normal form

    Application(CompanyName, CompanyInformation, Role, reqStrengths, reqQuals, CV, CovLetter, dateSent, Response, dateInterview, Outcome, Reflection)
    Myself(CompanyName*, myStrengths, myEvidence, mySatisfaction, myQuals, qualDate, qualGrade, Aim, Relevance)

    Second normal form

    Application(CompanyName, CompanyInformation, Role, CV, CovLetter, dateSent, Response, dateInterview, Outcome, Reflection)
    Role(CompanyName*, reqStrength, reqQual)
    RequiredStrengths(Role*, reqStrength)
    RequiredQualifications(Role*,reqQual)
    MyStrengths(Role*, myStrenght, myEvidence, mySatisfaction)
    MyQualifications(Role*, myQual, qualDate, qualGrade)
    MyAims(Role*, Aim, Relevance)

    Third normal form

    Application(CompanyName, CompanyInformation, Role)
    Communication(CompanyName*, CV, CovLetter, dateSent, Response,dateInterview, Outcome, Reflection)
    Role(CompanyName*, reqStrengths, reqQuals)
    MyStrengths(Role*, myStrengths, myEvidence, mySatisfaction)
    MyQualifications(Role*, myQuals, qualDate, qualGrade)
    MyAims(Role*, Aim, Relevance)
    Thank you.
    Last edited by Arom; 02-23-13 at 12:03.

Posting Permissions

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