## Companies

id | name | address | phoneNumber
--- | --- | --- | ---
1 | Company A | 123 Main St | 555-1234
2 | Company B | 456 Elm St | 555-5678
3 | Company C | 789 Oak St | 555-9012
4 | Company D | 321 Pine St | 555-1357
5 | Company E | 999 Maple Ave | 555-2468

## Locations

id | locationName | description
--- | --- | ---
1 | University's Main Library | The main library of a large university.
2 | City Hall | A government building that serves as the administrative center of a city.
3 | Private School | An independent school not funded by public taxes.
4 | Hospital | A medical institution providing healthcare services.
5 | Research Center | A facility dedicated to scientific research.

## Jobs

id | title | description | startDate | endDate | companyId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.id)
1 | Software Developer | Developing software applications. | 2022-01-01 | 2023-12-31 | 1
2 | Graphic Designer | Creating visual content. | 2022-02-01 | 2023-12-31 | 1
3 | Data Analyst | Analyzing data sets. | 2022-03-01 | 2023-12-31 | 2
4 | HR Specialist | Managing employee relations. | 2022-04-01 | 2023-12-31 | 2
5 | Marketing Manager | Overseeing marketing campaigns. | 2022-05-01 | 2023-12-31 | 3

## Information_Management_Jobs

id | informationType | jobTitle | salary | jobDescription | locationId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Locations.id)
1 | Librarian | Librarian | 50000 | Organizing and managing library resources. | 1
2 | Librarian | Library Assistant | 35000 | Assisting with various tasks in the library. | 2
3 | Archivist | Archivist | 45000 | Preserving historical documents and records. | 1
4 | Archivist | Records Management Specialist | 40000 | Implementing records management systems. | 3
5 | Curator | Curator | 55000 | Managing collections and exhibitions. | 4