DepartmentID
DepartmentName
1 HR
2 Finance
3 IT
4 Marketing
5 Sales
6 Operations
7 Support
8 R&D
9 Legal
10 Admin
EmployeeIDFirstName LastName
DepartmentID Role Salary HireDate Email Phone
1 Karan Patel 2 Coordinato 81940 2024-08-3 employee +91-9560013760
2 Vikram Iyer 10 Manager 50705 2019-02-1 employee +91-7864749450
3 Pooja Patel 3 Coordinato 62421 2020-04-2 employee +91-8973060801
4 Neha Iyer 8 Assistant 94872 2020-05-0 employee +91-8867902263
5 Vikram Rao 8 Developer 102458 2023-03-0 employee +91-7843593335
6 Karan Yadav 3 Assistant 97829 2020-08-1 employee +91-7644411743
7 Vikram Yadav 9 Lead 59688 2017-10-2 employee +91-7498561153
8 Priya Rao 7 Manager 50228 2020-10-0 employee +91-7303536482
9 Priya Patel 4 Consultant 79119 2025-04-1 employee +91-9822668490
10 Anjali Iyer 8 Analyst 80705 2022-01-1 employee +91-7323846552
11 Karan Jain 6 Lead 49143 2021-12-2 employee +91-9102622266
12 Karan Nair 10 Developer 74946 2023-08-0 employee +91-9246565688
13 Raj Verma 1 Executive 46143 2023-09-1 employee +91-8860012601
14 Raj Patel 4 Manager 109808 2019-06-2 employee +91-7969269034
15 Priya Rao 1 Manager 113717 2023-01-0 employee +91-9687422757
16 Meena Rao 7 Assistant 95973 2023-10-2 employee +91-8046919328
17 Priya Patel 6 Consultant 83965 2024-06-1 employee +91-8500802502
18 Anjali Nair 1 Consultant 59412 2019-01-1 employee +91-8500572387
19 Pooja Yadav 3 Executive 51817 2022-09-0 employee +91-8545149136
20 Neha Yadav 2 Specialist 51576 2018-12-2 employee +91-9450990244
21 Amit Nair 6 Coordinato 117528 2020-03-1 employee +91-7837359006
22 Anjali Nair 5 Coordinato 37150 2017-10-1 employee +91-7842865090
23 Meena Rao 10 Consultant 43116 2019-11-1 employee +91-8015859825
24 Vikram Singh 6 Consultant 66992 2019-06-0 employee +91-9694594917
25 Vikram Nair 6 Specialist 117228 2021-02-2 employee +91-8203840515
ProjectIDProjectName
DepartmentIDBudget StartDate EndDate
1 Project_1 6 820057 2024-09-1 2027-01-14
2 Project_2 4 1442330 2024-09-2 2026-05-04
3 Project_3 7 1234243 2023-10-2 2026-11-23
4 Project_4 1 848952 2023-04-1 2027-08-15
5 Project_5 4 1163926 2023-09-2 2027-03-03
6 Project_6 7 1957561 2024-03-1 2026-09-14
7 Project_7 5 1785743 2024-09-2 2026-04-20
8 Project_8 9 1006974 2024-04-2 2026-01-03
9 Project_9 4 1191892 2023-09-0 2026-02-05
10 Project_10 6 1117786 2023-07-2 2028-01-18
EmployeeIDProjectIDHoursWorked
14 7 123
14 8 135
16 7 148
16 3 67
18 10 70
10 4 137
18 5 163
24 3 187
1 7 165
17 8 35
3 4 76
24 3 122
14 10 123
15 9 140
4 3 160
12 5 123
15 3 193
16 5 44
17 1 43
1 10 90
4 4 23
9 6 121
7 6 69
18 9 189
12 6 113
20 10 29
7 3 69
23 9 86
18 3 39
4 3 104
