Solved

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

Posted on 2002-07-30
3
151 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 50

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to solve ssl error handshake failure alert on IE 1 229
Has my website been infiltrated? 21 69
SSL sertificate 5 70
How can i point a subdomain to directory? 5 30
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…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
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…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

839 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