## Companies

companyID | name | location
--- | --- | ---
1 | Company A | New York
2 | Company B | San Francisco
3 | Company C | Boston
4 | Company D | Chicago
5 | Company E | Los Angeles

## Departments

deptID | deptName | companyID
--- | --- | ---
|  | (→ Companies.companyID)
1 | Engineering | 1
2 | Marketing | 2
3 | Human Resources | 3
4 | Finance | 4
5 | Product Development | 5

## Teams

teamID | teamName | deptID
--- | --- | ---
|  | (→ Departments.deptID)
1 | Web Developers | 1
2 | Mobile App Developers | 1
3 | Graphic Designers | 2
4 | Content Writers | 2
5 | Data Analysts | 4

## Positions

positionID | title | description | teamID
--- | --- | --- | ---
|  |  | (→ Teams.teamID)
1 | Software Engineer | Develop and maintain software applications. | 1
2 | Android Developer | Design and develop Android apps. | 2
3 | UX/UI Designer | Create user-centered designs. | 2
4 | Data Scientist | Analyze data to provide insights. | 4
5 | Accountant | Handle financial transactions and reports. | 5

## Management

roleID | PositionID | Department_Head | Team_Leader
--- | --- | --- | ---
| (→ Positions.positionID) |  |
1 | 1 | Noah Davis | Jane Smith
2 | 1 | Emma Garcia | Alex Brown
3 | 2 | Sophia Lee | Mary White
4 | 3 | Olivia Martinez | Kate Green
5 | 4 | Liam Johnson | Robert Elliot

## Employees

employeeID | firstName | lastName | email | phoneNumber | hireDate | positionID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Positions.positionID)
1 | John | Doe | john.doe@example.com | 123-456-7890 | 2021-01-15 | 1
2 | Alice | Johnson | alice.johnson@example.com | 098-765-4321 | 2020-02-10 | 2
3 | Tom | Brown | tom.brown@example.com | 555-555-5555 | 2019-03-05 | 3
4 | Linda | Green | linda.green@example.com | 555-123-4567 | 2018-04-01 | 4
5 | Kevin | Black | kevin.black@example.com | 111-222-3333 | 2017-05-15 | 5