Thread: Normalization
View Single Post
  #14  
Old July 5th, 2009, 08:22 PM posted to microsoft.public.access.tablesdbdesign
lmcc007
external usenet poster
 
Posts: 63
Default Normalization

No, there may be several jobs per company. For example I have applied with
Shell Oil several times:

Date EventType JobTitle Notes
1/1/08 SubResume Administrator
1/1/08 Email recd Administrator Confirmation ltr
2/1/08 SubResume Admin. I
2/1/08 Email recd Admin. I Confirmation ltr
5/5/08 SubResume Admin. II

I think I have worked at this too much I am confusing myself. But I have a
JobTitle table that is a list of job titles.

Now, I am thinking about doing a JobTitleInfo table that gives information
about each job I applied for. That's where I am confused on whether I should
do this.

"June7 via AccessMonster.com" wrote:

You will not have more than one job per company? I see as the primary purpose
is to track job apps and all data contributes info to that effort, so the job
record is parent to events, thus recommendation for table with one record per
job.