Results 1 to 5 of 5

Thread: Normalisation

  1. #1
    Join Date
    Mar 2014
    Posts
    17

    Unhappy Unanswered: Normalisation

    hello,

    I have a Excel spreadsheet but wanting to turn it into a database.

    If i gave someone the list of fields would you be able to help normalise the fields and create the tables and what the relationships would be between each table.

    Thanks!

  2. #2
    Join Date
    Mar 2014
    Posts
    17

    Fields

    These are the fields:

    Forename
    Surname
    Age
    Address Line 1
    Address Line 2
    Address Line 3
    Postcode
    Email
    Telephone
    Employment Status
    Tenant/Friends/Family
    Work Type
    Qualification
    Previous Experience
    Benefits claiming
    College Course Date
    Confirmed Course and letter Sent
    Work experience required
    Work experience information
    NI number or DOB
    Date Started college course
    Date completed course
    Date of work experience start
    Department of work experience
    Data of employment start
    Additional notes

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I find it helps to actually go through the process of normalisation to understand the concepts behind relational databases

    try reading
    Fundamentals of Relational Database Design -- r937.com
    or
    The Relational Data Model, Normalisation and effective Database Design
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2014
    Posts
    17
    I had a look through some information online similair to that and came up with a solution but still unsure it its correct and what to do about primary keys/relationships.

    This was my original list of fields:

    Forename
    Surname
    Age
    Address Line 1
    Address Line 2
    Address Line 3
    Postcode
    Email
    Telephone
    Employment Status
    Tenant/Friends/Family
    Work Type
    Qualification
    Previous Experience
    Benefits claiming
    College Course Date
    Confirmed Course and letter Sent
    Work experience required
    Work experience information
    NI number or DOB
    Date Started college course
    Date completed course
    Date of work experience start
    Department of work experience
    Data of employment start
    Additional notes

    I then created 4 tables from that:

    TABLE 1
    ID
    Forename
    Surname
    Age
    Address Line 1
    Address Line 2
    Address Line 3
    Postcode
    Email
    Telephone

    TABLE 2

  5. #5
    Join Date
    Mar 2014
    Posts
    17
    I had a look through some information online similair to that and came up with a solution but still unsure it its correct and what to do about primary keys/relationships.

    This was my original list of fields:

    Forename
    Surname
    Age
    Address Line 1
    Address Line 2
    Address Line 3
    Postcode
    Email
    Telephone
    Employment Status
    Tenant/Friends/Family
    Work Type
    Qualification
    Previous Experience
    Benefits claiming
    College Course Date
    Confirmed Course and letter Sent
    Work experience required
    Work experience information
    NI number or DOB
    Date Started college course
    Date completed course
    Date of work experience start
    Department of work experience
    Data of employment start
    Additional notes

    I then created 4 tables from that:

    TABLE 1
    mainID
    Forename
    Surname
    Age
    Address Line 1
    Address Line 2
    Address Line 3
    Postcode
    Email
    Telephone

    TABLE 2
    mainID
    College course date
    Confirmation of course
    Date started course
    Date completed course

    TABLE 3
    mainID
    Employment status
    Tenant/Friends/family
    Work type
    Qualifications
    Previous experience
    Benefits claiming

    TABLE 4
    mainID
    Work experience required
    Work experience information
    Start data

    help!

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
  •