Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Bartleby Related Questions Icon
Related questions
Question
Kindly make a flowchart that will calculate the total salary of an employee using this chart
Transcribed Image Text:5. Programming Challenge:
The easiest way to find the net salary of employee is by first taking the values of
gross salary, income tax, provident fund and professional tax in the main function and
directly use the below formula.
Net Salary = Gross Salary-Income Tax - Public Provident Fund - Security Tax
But to Create a program that would be compute salary of an employee based on the
information indicated in the table given below.
Dept.
MIS
Dept.
Code
MIS
Marketing MKT
Accountin
g
ACT
STATUS
HEAD OF THE
FAMILY
SINGLE WITH
DEPENDENTS
SINGLE W/O
DEPENDENTS
Position
Programme
Analyst
Advertiser
Staff
Chief
Cashier
Position
Code
HOF
SWD
011
STATUS CODE
SOD
012
021
022
031
032
a. Problem Definition:
1. The program should ask the user to
enter employee name
department code
number of hours worked
status code name
Sub-
Position
Senior
Programmer
Junior
Programmer
System
Analyst
Data
Analyts
BIR TAX
10%
15%
20%
Sub-
Position
Code
011A
011B
012A
012B
Rate Per
Hour
1000
employees' position / employees' position code
sub-position code
SECURITY TAX
5%
10%
1000
15%
800
500
400
600
400
2. Create a program that will compute for the gross income of the employee by
multiplying the number of hours worked into his rate per hour based on the
employees' position or sub-position identified in each department.
3. To compute the total deductions by adding the percentage from BIR and
Security Taxes based on his/her civil status.
4. To compute for the net income by subtracting the total deductions from the
gross income.
b. Program Design-flowchart.:
Before we write the program, First develop a logic plan for solving the problem
using flowchart.
Expert Solution
Check MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
bartleby
Trending nowThis is a popular solution!
bartleby
Step by stepSolved in 3 steps with 1 images
Knowledge Booster
Background pattern image
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Create a simple IPO chart that enters an individual's year of birth and the present year and calculate and return the individual's current agearrow_forwardplease tell me the R code for this statement: Categorial variable from StartDateTime: if StartDateTime between 12am- 11:59am set it to ‘Daytime’, else if StartDateTime is 12pm -11:59pm set it as ‘Evening’ Please be specific on each step. Thanksarrow_forwardas i try to run checks it does not work, what should i change to make the code work.arrow_forward
- Each of the flowchart segments in Figure 3-24 is unstructured. Redraw each segment so that it does the same processes under the same conditions, but is structured.arrow_forwardWhich of the following statements invokes the GetDiscount function, passing it the contents of two Decimal variables named decSales and decRate? The statement should assign the function’s return value to the decDiscount variable. a. decDiscount = GetDiscount(ByVal decSales, ByVal decRate) b. GetDiscount(decSales, decRate, decDiscount) c. decDiscount = GetDiscount(decSales, decRate) d. None of the above.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education