Results 1 to 7 of 7
  1. #1
    Join Date
    May 2010
    Posts
    4

    Help me with database design

    Hello

    I want to convert a paper form to a database. i did it but i'm not sure... so help me please.

    the paper form contain 4 sections: Personal information, University Degree information, Job information and certifications list.

    This is the field on the Paper:
    First name, Last name, ID, Date of birth, city,
    Degree level, Degree date, University, section,
    Jop name, Hire date, department, Jop Location,
    certification name, certification date, certification period, Authored by

    I think the City field need to be in a new table, because the city repeated frequently. i also made a new tables for Degree level, University, section, department, Jop Location And certification.

    Please correct me.

    Thanks

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    If you've made the tables, post them here so we're not guessing.

  3. #3
    Join Date
    May 2010
    Posts
    4
    Quote Originally Posted by sco08y View Post
    If you've made the tables, post them here so we're not guessing.
    OK,
    This is the form:
    http://i50.tinypic.com/b487qq.jpg

    This is the tables i made:
    http://i50.tinypic.com/35i3bdk.jpg

    Should i make a new tables for: DEGREE.Grade, DEGREE.Major field of study, DEGREE.College Name, Certifications.Institution, JOP.Location, JOP.Standing and JOP.Current Position?

    Please correct me.

  4. #4
    Join Date
    May 2010
    Posts
    4
    This is fields names (in case you want to copy/past):

    National ID:
    First Name:
    Middle Name:
    Last Name:
    Date of Birth:
    Sex:
    License Number:
    City of issue:
    Date of issue:
    Expiration date:
    Home Address:
    Postal Code:
    Email
    Phone Number

    Current degree:
    Date Obtained:
    Grade:
    Major field of study:
    College Name:

    Jop Title:
    Date Employed:
    Jop Location:
    Jop Standing:
    Current Position:

    Certification Obtained
    Period
    Date Attended
    Institution

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Looks OK to me, but if you make City a separate table rather than a free-text field, be prepared to populate the table with a list of every single city you will encounter. Be sure this separation of data is necessary for your requirements.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    May 2010
    Posts
    4
    How could i make sure? is there any rules about this?

    The CITY field is not important for me, i will not make a quiry depend on it.

    I will quiry only by: Names, National ID, Jop Title, Jop Location, Jop Standing and Current Position.

    Thanks for your reply.
    Quote Originally Posted by blindman View Post
    Looks OK to me, but if you make City a separate table rather than a free-text field, be prepared to populate the table with a list of every single city you will encounter. Be sure this separation of data is necessary for your requirements.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Then don't bother creating a separate table for cities.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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