D
debl5
I want to set up a database of my work experience. I think it will be useful
in pulling different job skills and accomplishments to help me in configuring
a resume to a specific job. I also thought it would be useful as an exercise
to brush up on long dormant skills. If my being as stuck as I am now is any
indication, I think they are long dead skills, not dormant.
I would appreciate help in how to set up the tables. Here's what I have so
far:
Table One - Jobs
Company Name
Job Title
Start Date
End Date
Supervisor
Supervisor extension
Table Two - Companies
Company Name
Address
City
State
Zip
Phone
URL
Notes
Table Three - Accomplishments
Accomplishment Detail
Table Four - Skills
Skill Category
Table Five - Junction Table
primary key accomplishments
primary key skills
Each job has a list of accomplishments that can be categorized into one or
more skill categories. If I write general accomplishments (like supervising
people), they can relate to more than one job.
Ultimately I want to be able to pull a list of all jobs that relate to
certain skills, all accomplishments that relate to certain skills, and all
accomplishments related to a certain job.
I'm just not sure how to apply more than one category to an accomplishment. I
understand (vaguley) the concept of building a junction table with the
primary key from both the accomplishment and skills tables, but my head
starts to hurt after that.
Any words of wisdom to get me headed in the right direction would be GREATLY
APPRECIATED!!
Thanks
in pulling different job skills and accomplishments to help me in configuring
a resume to a specific job. I also thought it would be useful as an exercise
to brush up on long dormant skills. If my being as stuck as I am now is any
indication, I think they are long dead skills, not dormant.
I would appreciate help in how to set up the tables. Here's what I have so
far:
Table One - Jobs
Company Name
Job Title
Start Date
End Date
Supervisor
Supervisor extension
Table Two - Companies
Company Name
Address
City
State
Zip
Phone
URL
Notes
Table Three - Accomplishments
Accomplishment Detail
Table Four - Skills
Skill Category
Table Five - Junction Table
primary key accomplishments
primary key skills
Each job has a list of accomplishments that can be categorized into one or
more skill categories. If I write general accomplishments (like supervising
people), they can relate to more than one job.
Ultimately I want to be able to pull a list of all jobs that relate to
certain skills, all accomplishments that relate to certain skills, and all
accomplishments related to a certain job.
I'm just not sure how to apply more than one category to an accomplishment. I
understand (vaguley) the concept of building a junction table with the
primary key from both the accomplishment and skills tables, but my head
starts to hurt after that.
Any words of wisdom to get me headed in the right direction would be GREATLY
APPRECIATED!!
Thanks
