## Companies

ID | Name
--- | ---
1 | ABC Corporation
2 | XYZ Industries
3 | MNO Consultancy
4 | PQR Bank
5 | LST Technology

## Locations

ID | City | State | Country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Chicago | IL | USA
3 | London | England | UK
4 | Paris | Ile-de-France | France
5 | Tokyo | Tokyo | Japan

## Education_Requirements

ID | Degree_Required | Years_Experience
--- | --- | ---
1 | Bachelor's degree | 2
2 | Master's degree | 3
3 | PhD | 5
4 | Bachelor's degree | 1
5 | Associate degree | 0

## JobPostings

ID | CompanyID | LocationID | Title | Description | Roles | Data
--- | --- | --- | --- | --- | --- | ---
| (→ Companies.ID) | (→ Locations.ID) |  |  |  |
1 | 1 | 1 | Economist - Demographics Analyst | Analyze demographic trends for economic forecasting. | Economist | Demographics
2 | 2 | 2 | Economist - Market Researcher | Conduct market research and analyze economic indicators. | Economist | Market
3 | 3 | 3 | Statistician - Demographics Expert | Apply statistical methods to study demographic patterns. | Statistician | Demographics
4 | 4 | 4 | Statistician - Financial Analyst | Use statistics to assess financial risks and opportunities. | Statistician | Financial
5 | 5 | 5 | Software Engineer - Full Stack Developer | Design and develop full stack software solutions. | Engineer | None