| 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 |
| 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 |
| id | skillName |
|---|---|
| 1 | Python Programming |
| 2 | Java Development |
| 3 | SQL Database Management |
| 4 | Data Analysis |
| 5 | Project Management |
| 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 |
| 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 | 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 | IT Consultant | Implement IT projects and manage change. | IT Consultant | $90,000 | 2 | 4 | 2 | 2 |