- The tables below shows the human resources system in a particular company.(Solved)
The tables below shows the human resources system in a particular company.
The table below shows the tax calculation based on income.
(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.
Date posted: August 20, 2019. Answers (1)
- With reference to word processing define the following terms:
(i) Draft printing
(ii) Orphan
(iii) Widow(Solved)
With reference to word processing define the following terms:
(i) Draft printing
(ii) Orphan
(iii) Widow
Date posted: August 20, 2019. Answers (1)
- Differentiate between:
(i) Search engine and a Browser.
(ii) Sabotage and eaves dropping.(Solved)
Differentiate between:
(i) Search engine and a Browser.
(ii) Sabotage and eaves dropping.
Date posted: August 20, 2019. Answers (1)
- Name and describe how four different areas have been changed negatively by growth in Information Technology.(Solved)
Name and describe how four different areas have been changed negatively by growth in Information Technology.
Date posted: August 20, 2019. Answers (1)
- Differentiate between a byte and a word as used in data representation in a computer.(Solved)
Differentiate between a byte and a word as used in data representation in a computer.
Date posted: August 20, 2019. Answers (1)
- Using twos complement, subtract 1710 from 1310 leaving your answer in binary notation.(Solved)
Using twos complement, subtract 1710 from 1310 leaving your answer in binary notation.
Date posted: August 20, 2019. Answers (1)
- Convert 19.88 to binary notation(Solved)
Convert 19.88 to binary notation
Date posted: August 20, 2019. Answers (1)
- Convert each of the following binary numbers to octal given that the left most digit is a sign bit.
(a) 01110110102
(b) 11101010102(Solved)
Convert each of the following binary numbers to octal given that the left most digit is a sign bit.
(a) 01110110102
(b) 11101010102
Date posted: August 20, 2019. Answers (1)
- A hospital runs a manual system in delivery of its services. Patients are issued with forms to fill their detailed at the reception and the...(Solved)
A hospital runs a manual system in delivery of its services. Patients are issued with forms to fill their detailed at the reception and the same details are captured by finance officer and the pharmacy attendant.
i) Identify two challenges that may be facing this hospital system.
ii) Explain three methods that may be used to gather facts about the above hospital system.
iii) A new computerized hospital system was developed and implemented, list any four method maintenance which will be employed to ensure the system is effective.
Date posted: August 20, 2019. Answers (1)
- Differentiate between testing and debugging as used in programming.(Solved)
Differentiate between testing and debugging as used in programming.
Date posted: August 20, 2019. Answers (1)
- Draw a flow chart that counts all the even numbers between 1 and 20 inclusive and then displays the sum which uses a repeat loop.(Solved)
Draw a flow chart that counts all the even numbers between 1 and 20 inclusive and then displays the sum which uses a repeat loop.
Date posted: August 20, 2019. Answers (1)
- Mwanaisha deposited Ksh 10000 in a bank at an interest rate of 20% per annum. At the end of each year, the interest earned is...(Solved)
Mwanaisha deposited Ksh 10000 in a bank at an interest rate of 20% per annum. At the end of each year, the interest earned is added to the deposit and the new amount becomes the deposit of that year.
Write a pseudo code that would track the growth of the deposit over a period of 5 years.
Date posted: August 20, 2019. Answers (1)
- Differentiate between hot swapping and plug and play as used in computing.(Solved)
Differentiate between hot swapping and plug and play as used in computing.
Date posted: August 20, 2019. Answers (1)
- Use figures below to answers the questions that follow.(Solved)
Use figures below to answers the questions that follow.
(i) Identify the network topologies in Figure 4 and Figure 5 above.
(ii) Explain why it is beneficial to use the topology in Figure 4 above.
Date posted: August 20, 2019. Answers (1)
- The following worksheet represents the number of stems of various types of flowers exported in Ken Flower Ltd.(Solved)
The following worksheet represents the number of stems of various types of flowers exported in Ken Flower Ltd.
The cost of each stem from the farmer is Kshs 25. This amount is typed in cell B10.
(a) Write a function that will calculate the total number of stems of all the types of flowers in all months.
(b) Write a formula that can be typed in cell E2 and then be copied down to obtain monthly purchases for Roses.
(c) Identify the data type in cell C1 and cell D3.
Date posted: August 20, 2019. Answers (1)
- Figure 3 below shows a removable storage media. Use it to answer the questions that follow.(Solved)
Figure 3 below shows a removable storage media. Use it to answer the questions that follow.
a) Identify the storage media above.
b) Explain two disadvantages of using the storage media above.
Date posted: August 20, 2019. Answers (1)
- Differentiate between working storage and auxiliary storage .(Solved)
Differentiate between working storage and auxiliary storage .
Date posted: August 20, 2019. Answers (1)
- The following computer components were displayed to inform computer students during a practical lesson.(Solved)
The following computer component were displayed to inform computer students during a practical lesson.
a) Identify the components in Figure 1 and Figure 2 above.
Figure 1-
Figure 2-
b) Explain how each of the components identified influences on the capability of a computer.
Date posted: August 20, 2019. Answers (1)
- Differentiate between merging cells and splitting cell in a table when using word processors.(Solved)
Differentiate between merging cells and splitting cell in a table when using word processors.
Date posted: August 20, 2019. Answers (1)
- Give examples of database systems(Solved)
Give examples of database systems
Date posted: August 2, 2019. Answers (1)