If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#14
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|