The director of a company uses a database to store data about job title. This is a part of the database given below:
The director of a company uses a database to store data about job title. This is a part of the database given below:
Employee Salary
| Last Name | First Name | Dept. | Payroll Number | Salary | Job Title |
| Shen | James | Finance | A621 | 19500 | Payroll Clerk |
| Gupta | Shruthi | Finance | M502 | 35000 | Accountant |
| Bedi | Reeta | Human Resource | M421 | 18500 | Secretary |
| Walker | Tia | Sales | W815 | 24000 | Sales Representative |
| Shafia | Ahmed | Factory | H219 | 39000 | Factory Manager |
| Mittal | Chavi | Purchasing | M134 | 20000 | Purchasing Clerk |
1. How many records are there in this part of the database?
2. How many fields are there in this part of the database?
3. What is the job title of the employee with Payroll Number M421?
4. Which department has maximum employees and what are their Payroll Numbers?
9 views
1 Answers
1. 6
2. 6
3. Secretary
4. Finance department and their Payroll Numbers are A621 and M502.
9 views
Answered