Database Normalization help

[isuru143]

Guys,

I need to normalize following table. I tried to do it myself. Tell me if I done it correctly.

title
salary/rate
benefits
keywords
job type
location
start_date
description
agency
agency_contact_name
agency_telephone
agency_email
job_reference number
date_posted
expiry_date

job table
- id
- title

keywords table
- id
- keywords

basic_details table
- id
- job_type
- description

location_datails table
- location
- start_date

pay table
- salary/ rate
- benefits

Thanks guys!

 

[Wild-EYE]

Bump

 

[homoelectronics]

Why start_date in location_datails table. ? What is the scenario/case study behind this normalization?

 

[mldarshana]

Scenario eka dannathuwa hariyatama kiyanna bae .. me wage ekak ei .. thawa multivalued attributes kadanna puluwan

JOB_Table
job_id, title, salary, benefits, keywords, jid, lid, start_date, description

Job Types Table
jid, job_description

Location Table
lid, location

Agency_Table
aid, agency, agency_contact_name, agency_telephone, agency_email, job_id, date_posted, expiry_date

 

[DjSpK]

^ above one is correct but create another table to save contact information's if you want to add more than one email or more than one mobile , home numbers
table contacts:
aid,contact_type(mobile,email,home,office),value

 

[nadeeraasanka]

what are the relationship ???

 

[toiya]

location_datails table
pay table

ID s nathuwa me deka link karanne kohomada

 

[isuru143]

Scenario is job vacancies site.