Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Database design issue

    I am a bit confused In which normal form (2NF, 3NF) will be the following sample database.

    Database - jobportal

    Table accounts
    ---------------
    account_id
    registration_email
    temporary_email
    registration_pass
    data_creation

    Table education
    ---------------
    education_id
    account_id -> FK to the accounts table
    institution_name
    faculty_name
    education_from
    education_to
    education_degree
    country_id -> FK to a nomenclature table
    town

    Table country
    ---------------
    country_id
    country_name

    For one account there might be stored many educational records.

    Are there any other problems that might be encountered?
    Your help is kindly appreciated.

    Regards

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    homework assignment? which school? what's the name of the course?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Posts
    2
    no, its not a homework. its a sample bit of a whole database for a jobportal site.
    there are other tables, similarly connected to the account table (f.e certification, projects, references). i am on some stage of designing it, that i am a bit consufed about destinguishing the normal form of it although analysing the forms definitions and their examples. i am wondering if i had to extract education.account_id and the education.education_id in a separate table, so the education.account_id FK would be not needed in the education table.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by krasssy_lf
    i am wondering if i had to extract education.account_id and the education.education_id in a separate table, so the education.account_id FK would be not needed in the education table.
    you could do that if you wanted to, but i wouldn't

    is it possible for you to insert an education row without knowing whose education it is? i.e. without knowing the account?

    i doubt it, so therefore education.account_id must be NOT NULL, therefore i would leave it right there in the education table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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