Which of the 'if statements below is the correct one for the following problem statement? Adjust employees increase, if the employee earns more than R11 000 per month increase their salary by 2.5% else increase their salary by 3.5%. Select one: O a. if salary > 11000 then salary = salary * 1.025 else salary = salary * 1.035 endif O b. if salary > 11000 then salary = salary * .25 endif if salary < 11000 then salary = salary * .35 endif O c. if salary > 11000 then salary = salary * .25 else salary = salary * .35 endif d. if salary < 11000 then salary = salary * 1.025 else salary = salary * 1.035 endif

Which of the 'if statements below is the correct one for the following problem statement? Adjust employees increase, if the employee earns more than R11 000 per month increase their salary by 2.5% else increase their salary by 3.5%. Select one: O a. if salary > 11000 then salary = salary * 1.025 else salary = salary * 1.035 endif O b. if salary > 11000 then salary = salary * .25 endif if salary < 11000 then salary = salary * .35 endif O c. if salary > 11000 then salary = salary * .25 else salary = salary * .35 endif d. if salary < 11000 then salary = salary * 1.025 else salary = salary * 1.035 endif

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Program Purpose - Professional Athletes often hire other professionals to help take care of matters for them. We will group them in four categories: Lawyers, Personal Assistants, Agents, and Trainers. They all get paid a percentage of the athlete's total yearly salary. Lawyers - 10%, Personal Assistants - 3%, Agents - 7%, and Trainers - 5% . Prompt the user to enter the athlete's salary for the year (ensure that the entered value is positive). The user should then enter the name and category of each of the hired professionals. The athlete should be able to hire as many professionals in each category as he/she wants, even if it is more than he/she can afford. Based on the category, calculate the amount that each professional should be paid. After all data has been entered, print the names of each professional hired, how much each is being paid, the total amount the athlete paid, and how much the athlete has left.
only code needed program that prompts the user to enter the month and year and displays the number of days in the month. For example, if the user entered month 2 and year 2012, the program should display that February 2012 has 29 days. If the user entered month 3 and year 2015, the program should display that March 2015 has 31 days.
Question 6 Write a while statement to test if the value of a whole number variable (called num) is greater than or equal to zerd? The value of num must be decreased by one in the while test condition before the test operation is performed. Hint: Use either prefix or postfix operators.
QUESTION 6 A CASE expression may use a O ELSE clause THEN All of these END WHEN None of these
you should only use chapter 2 and 3 (you can not use loop except if and else ) In a certain company the cost of software depends on the license type which could be Individual or Enterprise. Write a program that reads ∙ License Type wanted (just the first character of each type: I, i, E, e). ∙ Number of Users to use the software. Type Price/User Minimum number of users Individual 500$ 1 Enterprise 300$ 5
If X's value is 11, Y's value is 20,the compound condition (X>0|| Y<10) returns: a) true; b) false
Beginning in cell f4, enter a formula using IFS function to calculate the commission rate based on the following table if annual sales are >=225,000 >=175,000 >=100,000 <100,000 then commission rate is: 6%4%2%0%
Final answer please
QUESTION 5 You need to use a nested If statement when O You have 2 or more conditions. The second (or third) condition is an 'if.else' statement You have 2 conditions. The second condition is only evaluated if the first condition is True You have 3 conditions. The second condition is only evaluated if the first condition is false You have 3 conditions. The second condition is only evaluated if the first condition is True
Given c = True , d = False. Determine if the following condition is true or false: !d && C True False
The following statements represent a "normal flow" use case for placing an online order for a meal from a restaurant that delivers food to one's home. The steps are out of order. You are to number them in the natural order of beginning to end. Question 34 options: App displays ordered menu items, individual prices, and total price, including taxes and delivery charge. Patron either confirms meal order (continue normal flow) or requests to modify meal order ( return to step 2 ). Patron opens app to view menu for a specific date. Patron selects one or more food items from menu. The app displays menu of available food items and the daily special. Patron selects a delivery time and specifies the delivery location. Patron indicates that meal order is complete. App sends patron an email message confirming order details, price, and delivery instructions. App displays available delivery times for the delivery date. Patron specifies payment method. App sends patron an…
If p < 0 and q > 0, determine whether the statement is true always, sometimes, or never. Describe how you know. pq < 0