Companies

companyIDnamelocation
1Company ANew York
2Company BSan Francisco
3Company CBoston
4Company DChicago
5Company ELos Angeles

Departments

deptIDdeptNamecompanyID
(→ Companies.companyID)
1Engineering1
2Marketing2
3Human Resources3
4Finance4
5Product Development5

Teams

teamIDteamNamedeptID
(→ Departments.deptID)
1Web Developers1
2Mobile App Developers1
3Graphic Designers2
4Content Writers2
5Data Analysts4

Positions

positionIDtitledescriptionteamID
(→ Teams.teamID)
1Software EngineerDevelop and maintain software applications.1
2Android DeveloperDesign and develop Android apps.2
3UX/UI DesignerCreate user-centered designs.2
4Data ScientistAnalyze data to provide insights.4
5AccountantHandle financial transactions and reports.5

Employees

employeeIDfirstNamelastNameemailphoneNumberhireDatepositionID
(→ Positions.positionID)
1JohnDoejohn.doe@example.com123-456-78902021-01-151
2AliceJohnsonalice.johnson@example.com098-765-43212020-02-102
3TomBrowntom.brown@example.com555-555-55552019-03-053
4LindaGreenlinda.green@example.com555-123-45672018-04-014
5KevinBlackkevin.black@example.com111-222-33332017-05-155

Management

roleIDPositionIDSupervisor
(→ Positions.positionID)
11John Doe
21Alice Johnson
32Tom Brown
43Linda Green
54Kevin Black