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 |