The tables below shows the human resources system in a particular company.

      

The tables below shows the human resources system in a particular company.

Q120820191250.png

Q120820191253.png


The table below shows the tax calculation based on income.


Q120820191255.png



(a) (i) Create he two tables for the database and save the database as Human resource.

(ii) Create relationship between the two tables.
(iii) Insert the data above in the two tables format the salary field to Ksh.

(b) (i) Create a query with all fields in the employee table and a calculated field giving the years of service of the employee (save the query as length of service).
(ii) Create a query based on employee table for the employees employed between two dates (Save the query as between dates).
(iii) Create a query based on the table employee and department add a calculated field tax
and net salary Depending on the income bracket of the employee.(save the query as
payslip.

(c) (i) Create a report based on the query payslip.
(ii) Create a report of employee based on the query length of service.

  

Answers


Maurice
(a) (i) Q12082019105.png

(ii) Creating relationships



(iii) Inserting data into the tables

Q12082019110.png



(b) (i) Q12082019116.png


(ii) Between Dates

Q12082019120.png

Q12082019123.png


(c) (i) Report Payslip

Q12082019127.png


(ii) Years of service report

Q12082019125.png




maurice.mutuku answered the question on August 20, 2019 at 10:32


Next: Two airports are such that B is 500km due East of A. Two planes P and Q take off from A and B respectively and...
Previous: State four ways in which lakes can be formed

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions