## Companies

CompanyID | Name | Location
--- | --- | ---
1 | TechNews | New York
2 | WorldReport | Los Angeles
3 | GlobalInsight | San Francisco
4 | InfoHub | Chicago
5 | DigitalTimes | Seattle

## Jobs

JobID | Title | Description | Requirements | PostedOn | CompanyID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.CompanyID)
1 | Senior Journalist | Lead a team of journalists... | Strong leadership skills required. | 2024-03-13 12:10:07 | 1
2 | Web Developer | Design and develop web applications... | Proficiency in JavaScript and HTML/CSS. | 2024-03-13 12:10:07 | 2
3 | Data Analyst | Analyze large datasets... | Advanced knowledge of R programming. | 2024-03-13 12:10:07 | 3
4 | Graphic Designer | Create visual content... | Expertise in Adobe Creative Suite. | 2024-03-13 12:10:07 | 4
5 | Marketing Manager | Develop marketing strategies... | MBA degree preferred. | 2024-03-13 12:10:07 | 5

## MediaCareers

CareerID | Careertype
--- | ---
1 | Journalist
2 | Editor

## Languages

LanguageID | Languagename
--- | ---
1 | English
2 | Spanish

## JobRequirements

JobRequirementID | Skillname | MinimumYearsExperience
--- | --- | ---
1 | Project Management | 5
2 | UX Design | 3

## JobPostingDetails

JobPostingID | JobID | CareerID | LanguageID | JobRequirementID
--- | --- | --- | --- | ---
| (→ Jobs.JobID) | (→ MediaCareers.CareerID) | (→ Languages.LanguageID) | (→ JobRequirements.JobRequirementID)
1 | 1 | 1 | 1 | 1
2 | 2 | 1 | 2 | 2
3 | 3 | 2 | 1 | 3
4 | 4 | 2 | 2 | 4
5 | 5 | 1 | 1 | 5