## CompanyInfo

id | name | location | industry
--- | --- | --- | ---
1 | TechCorp | New York | Technology
2 | FinanceInc | Chicago | Banking
3 | HealthCareSystems | Los Angeles | Healthcare
4 | EduCo | San Francisco | Education
5 | GreenEnergy | Houston | Renewable Energy

## JobLocations

id | city | state | country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Chicago | IL | USA
3 | Los Angeles | CA | USA
4 | San Francisco | CA | USA
5 | Houston | TX | USA

## SkillsRequired

id | skillName
--- | ---
1 | Python Programming
2 | Java Development
3 | SQL Database Management
4 | Data Analysis
5 | Project Management

## EducationRequirements

id | degreeLevel | yearsOfExperience
--- | --- | ---
1 | Bachelor's Degree | 2
2 | Master's Degree | 3
3 | PhD | 5
4 | Associate Degree | 1
5 | High School Diploma | 0

## JobPostings

id | title | description | itJobs | salary | companyId | locationId | skillsId | educationId
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ CompanyInfo.id) | (→ JobLocations.id) | (→ SkillsRequired.id) | (→ EducationRequirements.id)
1 | Network Administrator | Administer network devices and systems. | Network Administrator | $70,000 | 1 | 1 | 1 | 1
2 | Senior Network Administrator | Manage network infrastructure and security. | Network Administrator | $80,000 | 1 | 2 | 1 | 1
3 | IT Consultant | Advise clients on IT strategy and solutions. | IT Consultant | $70,000 | 2 | 3 | 2 | 2
4 | Senior IT Consultant | Implement IT projects and manage change. | IT Consultant | $90,000 | 2 | 4 | 2 | 2