| 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 |
| deptID | deptName | companyID |
|---|---|---|
| (→ Companies.companyID) | ||
| 1 | Engineering | 1 |
| 2 | Marketing | 2 |
| 3 | Human Resources | 3 |
| 4 | Finance | 4 |
| 5 | Product Development | 5 |
| 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 |
| 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 |
| 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 |
| employeeID | firstName | lastName | 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 |