- Employees Table Structure Name Employee Id First Name Last Name Salary Commission Pct Manager Id Department Id Departmen 1 (35.76 KiB) Viewed 46 times
- Employees Table Structure Name Employee Id First Name Last Name Salary Commission Pct Manager Id Department Id Departmen 2 (57.43 KiB) Viewed 46 times
- Employees Table Structure Name Employee Id First Name Last Name Salary Commission Pct Manager Id Department Id Departmen 3 (37.28 KiB) Viewed 46 times
Employees Table structure Name EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID Departments table structure Name DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID Type NUMBER (6) VARCHAR2 (20) NOT NULL VARCHAR2 (25) NUMBER (8,2) Null? Null? NUMBER(2, 2) NUMBER (6) NUMBER (4) Type NUMBER (4) NOT NULL VARCHAR2(30) NUMBER (6) NUMBER (4)
Sample data employees table EMPLOYEE ID FIRST_NAME 100 Steven 101 Neena 102 Lex 103 Alexander 104 Bruce 105 David 106 Valli 107 Diana 108 Nancy 109 Daniel 110 John 111 Ismael 112 Jose Manuel 113 Luis 114 Den 115 Alexander 116 Shelli 117 Sigal 118 Guy 119 Karen 120 Matthew 121 Adam EMPLOYEE ID FIRST_NAME 122 Payan 123 Shanta 124 Kevin 125 Julia 126 Irene 127 James 128 Steven 129 Laura 130 Mozhe 131 James 132 TJ 133 Jason 134 Michael 135 Ki 136 Hazel 137 Renske 138 Stephen 139 John LAST_NAME King Kochhar De Haan Hunold Ernst Austin Pataballa Lorentz Greenberg Faviet Chen Sciarra Urman Popp Raphaely Khoo Baida Tobias Himuro Colmenares Weiss Fripp LAST_NAME Kaufling Vollman Mourgos Nayer Mikkilineni Landry Markle Bissot Atkinson Marlow olson Mallin Rogers Gee Philtanker Ladwig Stiles Seo SALARY COMMISSION PCT MANAGER_ID DEPARTMENT_ID 24000 17000 17000 9000 6000 4888 4800 4200 12008 9000 8200 7788 7888 6900 11000 3100 2900 2888 2600 2500 8888 8200 3300 2888 2500 2100 100 100 102 3300 2988 2400 2288 3600 3200 2788 103 103 103 103 101 108 108 108 108 108 100 114 114 114 114 114 100 100 100 100 100 120 120 120 120 121 121 121 121 122 122 122 122 90 90 90 SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID 7988 6500 5800 3200 2788 2488 2208 123 123 123 60 60 68 60 60 100 100 100 100 100 100 30 30 30 38 30 30 58 50 50 58 58 58 50 58 58 50 58 58 58 50 58 50 58 50 50 50
Sample data for Departments table DEPARTMENT ID DEPARTMENT_NAME 10 Administration 20 Marketing 30 Purchasing 40 Human Resources 50 Shipping 60 IT 70 Public Relations 80 Sales 90 Executive 100 Finance 110 Accounting 120 Treasury 130 Corporate Tax 140 Control And Credit 150 Shareholder Services 160 Benefits 170 Manufacturing 180 Construction 190 Contracting MANAGER_ID LOCATION_ID 200 201 114 203 121 103 204 145 100 108 205 1700 1800 1700 2400 1500 1400 2700 2500 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700