Emp ID Emp Name Phone No Hire Date Salary Dept ID Dept Name Manager ID

1001 John Smith 555-1234 5/10/2019 5000 101 HR 2001

1002 Jane Doe 555-5678 2/15/2020 6000 101 HR 2001
1003 Michael Lee 555-9876 11/20/2018 5500 102 Sales 2002
1004 Sarah Green 555-6543 8/5/2017 6500 102 Sales 2002
1005 David Clark 555-2345 3/30/2019 4500 103 Finance 2003
1006 Lisa Brown 555-8765 6/12/2020 7000 103 Finance 2003
1007 Brian Chen 555-3456 2/18/2018 4000 104 IT 2004
1008 Emma Scott 555-7890 9/1/2017 5500 104 IT 2004
1009 Jason Wang 555-4321 10/25/2020 5000 105 Marketing 2005
1010 Sophia Liu 555-8765 4/15/2019 4500 105 Marketing 2005
1011 Alex Young 555-2345 7/10/2018 6500 106 R&D 2006
1012 Olivia Kim 555-5678 1/5/2020 6000 106 R&D 2006
1013 Ethan Wu 555-9876 6/20/2017 4000 107 Operations 2007
1014 Chloe Li 555-6543 11/15/2019 5000 107 Operations 2007
1015 Ryan Wang 555-1234 3/12/2021 5500 108 HR 2001
1016 Mia Johnson 555-5678 8/8/2020 4500 108 HR 2001
1017 Lucas Chen 555-9876 9/2/2019 6000 109 Sales 2002
1018 Lily Davis 555-6543 4/17/2018 5500 109 Sales 2002
1019 Daniel Kim 555-2345 11/30/2020 4000 110 Finance 2003
1020 Grace Brown 555-8765 7/5/2017 7000 110 Finance 2003
1021 Henry Lee 555-3456 6/18/2019 5000 111 IT 2004
1022 Ava Clark 555-7890 9/20/2020 6500 111 IT 2004
1023 Noah White 555-4321 8/15/2018 4500 112 Marketing 2005
1024 Emily Wang 555-8765 5/1/2017 5500 112 Marketing 2005
1025 Ethan Brown 555-2345 2/14/2019 6000 113 R&D 2006
1026 Mia Smith 555-5678 7/20/2020 4000 113 R&D 2006
1027 Jacob Chen 555-9876 12/1/2018 5000 114 Operations 2007
1028 Ava Johnson 555-6543 1/10/2021 5500 114 Operations 2007
1029 William Liu 555-1234 4/5/2020 4500 115 HR 2001
1030 Natalie Kim 555-5678 8/20/2019 6500 115 HR 2001
1031 James Wang 555-9876 5/15/2018 5500 116 Sales 2002
1032 Sophia Li 555-6543 10/1/2020 5000 116 Sales 2002
1033 Benjamin Wu 555-2345 12/18/2017 4000 117 Finance 2003
1034 Chloe Brown 555-8765 11/1/2019 6000 117 Finance 2003
1035 Daniel Lee 555-3456 2/14/2021 5500 118 IT 2004
1036 Grace Scott 555-7890 9/5/2020 4500 118 IT 2004
1037 Samuel Chen 555-4321 10/10/2018 6500 119 Marketing 2005
1038 Lily Davis 555-8765 7/25/2017 5000 119 Marketing 2005
1039 Michael Kim 555-2345 12/18/2020 6000 120 R&D 2006
1040 Olivia Smith 555-5678 9/1/2019 4000 120 R&D 2006
1041 Ethan Chen 555-9876 6/15/2018 5500 121 Operations 2007
1042 Emily Johnson 555-6543 3/10/2021 4500 121 Operations 2007
1043 Lucas Wang 555-1234 8/25/2020 5000 122 HR 2001
1044 Mia Brown 555-5678 9/10/2019 6500 122 HR 2001
1045 Alexander Liu 555-9876 4/15/2018 5500 123 Sales 2002
1046 Chloe White 555-6543 11/30/2020 4000 123 Sales 2002
1047 Noah Johnson 555-2345 2/25/2019 6000 124 Finance 2003
1048 Ava Davis 555-8765 12/1/2017 5500 124 Finance 2003
1049 William Kim 555-3456 5/5/2021 4500 125 IT 2004
1050 Natalie Lee 555-7890 8/20/2020 6500 125 IT 2004
 Manager Name Commission
Emily Brown 100
Emily Brown 150
Mark Johnson 75
Mark Johnson 200
Emma Wilson 50
Emma Wilson 250
James Smith 0
James Smith 50
Julia Davis 100
Julia Davis 75
Robert Brown 0
Robert Brown 100
Daniel Smith 0
Daniel Smith 0
Emily Brown 150
Emily Brown 100
Mark Johnson 200
Mark Johnson 100
Emma Wilson 0
Emma Wilson 300
James Smith 0
James Smith 50
Julia Davis 75
Julia Davis 100
Robert Brown 150
Robert Brown 0
Daniel Smith 0
Daniel Smith 100
Emily Brown 50
Emily Brown 150
Mark Johnson 0
Mark Johnson 100
Emma Wilson 0
Emma Wilson 200
James Smith 50
James Smith 100
Julia Davis 150
Julia Davis 50
Robert Brown 100
Robert Brown 0
Daniel Smith 0
Daniel Smith 75
Emily Brown 50
Emily Brown 200
Mark Johnson 100
Mark Johnson 0
Emma Wilson 100
Emma Wilson 50
James Smith 75
James Smith 150