| CompanyID | Name | Location |
|---|---|---|
| 1 | TechNews | New York |
| 2 | WorldReport | Los Angeles |
| 3 | GlobalInsight | San Francisco |
| 4 | InfoHub | Chicago |
| 5 | DigitalTimes | Seattle |
| 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 |
| CareerID | Careertype |
|---|---|
| 1 | Journalist |
| 2 | Editor |
| LanguageID | Languagename |
|---|---|
| 1 | English |
| 2 | Spanish |
| JobRequirementID | Skillname | MinimumYearsExperience |
|---|---|---|
| 1 | Project Management | 5 |
| 2 | UX Design | 3 |
| 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 |