Solved

My Coldfusion Project - Part 1 (Database), Please help!

Posted on 2002-07-30
3
146 Views
Last Modified: 2013-12-24
Guys,

Here is part 1 of my project and I need your input. I am trying to create a website for Job Search. Similar to www.job.com but a very much scale down version. Not trying to compete with any job search websites and only limited to a very specific industry, for fun, and to learn (from experts, of course). :) And, I am putting Access problem here as I will continue with Part II - Coldfusion later and put everything under the same topic.

Part 1 - Database

Required Info - Resume
----------------------
Personal Details
- AutoID
- LoginName
- Name, Etc.

Education (allow user to add Education records)
- Level (PhD, Master, etc.)
- Field of Study
- Grade, Etc.

Job Experience (allow user to add Job Experience)
- Company
- Title
- Salary
- Job Description (should use Memos for greater than 255 characters?), Etc.

References (2 Names)
- Name
- Company, etc.

Required Info - Job Application
-------------------------------
- Employer’s Name
- Job Position --> Job Details (easy, just a link, I have no problem with this)
- Job Status (Applied (default), Viewed)
- Apply Date

Required Info - Employer
------------------------
Resume submitted by job applicants for a particular vacancy
- Name --> Details (Click "Name" and go to Resume Details)
- Current Job Position
- Contact (Phone Number)
- Status (Applied (default), Viewed, Shortlisted, KIV)

I would like your opinion on how many "tables", the relationship of the tables should be setup to best fit the above requirements. User will be able to add additional "Job Experience" at later stage.

And, when the user submit resume for a particular vacancy, Employer will be able to view user's info (Resume). Do I need another table for this? Each vacancy could have hundreds of resumes. Do I create table for each vacancy? I just don't know how to put all vacancies and resumes in one table if this can and should be done.

SORRY FOR THE LONG STORY... :)

Thanks and regards,
Buybuy
0
Comment
Question by:buybuy
3 Comments
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 200 total points
ID: 7187428
As we can see each applicant can had been employeed more than 1 time, so the 'Job Experience' is definite a 1 to many relationship with the 'Personal Details' table. As well as 'Education', it's also a 1 to many condition, so another table 'Education' will be created.

For the 'References' (2 Names), it's depending on us whether the maximum references will be 2, or can be more (not flexible). So, if the maximum preference is confirm to be 2 then the References should included in 'Personal Details' table.

>> Employer will be able to view user's info (Resume). Do I need another table for this?
It's depending on how many resume can a user have. If the answer is 1, then you only need to create another table , like 'Job Application History', which includes the ID of the 'Job' table, the ID of the user in 'Personal Details', the [Apply Date], [Status], just similar to the 'Required Info - Job Application' table. The 'Job Application History' will be a many to many table.

Hope these helps.
0
 
LVL 2

Expert Comment

by:DBrown
ID: 7192234
This is how I would do it, each table needs a reference to the user and therefore a FK(Foreign Key relationship) also each table should have a Primary key (ID)

Users
- ID (PK)
- LoginName
- Name, Etc.

Education (allow user to add Education records)
- ID (PK)
- USER_ID (FK_USERS_ID)
- Level (PhD, Master, etc.)
- Field of Study
- Grade, Etc.

Job Experience (allow user to add Job Experience)
- ID
- USER_ID (FK_USERS_ID)
- Company
- Title
- Salary
- Job Description (should use Memos for greater than 255 characters?), Etc.

References (2 Names)
- ID (PK)
- USER_ID (FK_USERS_ID)
- Name
- Company, etc.

Required Info - Job Application
-------------------------------
- ID (PK)
- USER_ID (FK_USERS_ID)
- Employer’s Name
- Job Position --> Job Details (easy, just a link, I have no problem with this)
- Job Status (Applied (default), Viewed)
- Apply Date
0
 

Author Comment

by:buybuy
ID: 7195616
Thanks guys...
0

Featured Post

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help Fix A 403 error 13 103
IIS Site Configuration Copy 2 70
I starting with php 12 112
Web server settings related to keepalive 1 107
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now