|
Step 1:
| Employee
|
|---|
* SSN
Username
Lname
Fname
streetadd1
streetadd2
zipcode
phone1
phone2
|
| Employer
|
|---|
*telephone_num
comp_name
address
location
contact_person
FK job
website
|
| jobs
|
|---|
*job
job_title
job_desc
salary
terms (full time, partime, contract..)
duration (how many months, days..)
category
requirements (degree, skills, certifications)
|
|
Step 2:
| Employee
|
|---|
* SSN
Username
Lname
Fname
streetadd1
streetadd2
password
FK zipcode
phone1
phone2
|
|
Zips
|
|---|
* zipcode
City
State
|
|
EmpSkills
|
|---|
*FK SSN (from the employee table)
*FK Skill_id (from the skills table)
skill_level
|
|
Skills
|
|---|
* Skill_id
category
skill_name
skill_description
|
| Employer
|
|---|
*telephone_num
comp_name
address
location
contact_person
FK job
website
|
| jobs
|
|---|
*job
job_title
job_desc
salary
terms (full time, partime, contract..)
duration (how many months, days..)
category
requirements (degree, skills, certifications)
|
|
