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 | 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 |