aC program to enter the midterm marks of 4 courses for 3 students. Calculate the average mark for each course and display which courses has the highest and the lowest averages respectively.
Q: A company has six salespeople. Every month they go on road trips to sell the company's product. At…
A: #include<iostream> //for cout and cin#include<fstream> //for…
Q: Relational comparison operators include(s): (1) (1) ; (3) ; (5) All of the options provided.
A: Relational operators are the operators that are operated on two operands to know the relation…
Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…
A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30
Q: Display a report that calculate the average of hours in the table works_on, regardless of whether…
A: Answer 1 :- For calculate the average of hours in the table works_on, regardless of whether null…
Q: ABC Sdn Bhd is organizing Hari Raya sale for all items in the shop. Create Scheme code to calculate…
A: Given: Total Price Discount Below RM 51 10% RM 51 - RM 100 15% Above RM 100 20%…
Q: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…
A: Normalization : is the process of minimizing redundancy from a relation or set of relations. 1NF :…
Q: In cell F4, create a formula using the HLOOKUP function to determine the Cost per participant for…
A: Question 1. In cell F4, create a formula using the HLOOKUP function to determine the Cost per…
Q: Using R calculate the total income for each of the bedroom types from the chart. Sort the output…
A: Here is the total income for each of the bedroom types & the Output from High to low income…
Q: Read the marks of a student for 3 courses. Calculate the average marks for the student. Check the…
A: 1. Take marks for the three courses as input from the student 2. Take average of the three numbers…
Q: Ensure the Employee Satisfaction worksheet is active, then use the FREQUENCY function to calculate…
A: 1. Add in the formula for these as such =FREQUENCY(C2:C10,F5:F9) • Do, change it according the…
Q: 4. Display customer ID, customer name, and the order ID and the order date of all orders for…
A: 4) SELECT c.CUSTOMER_ID, c.NAME, o.ORDER_ID, o.ORDER_DATE, oi.QUANTITY AS "Total Items",…
Q: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…
A: From the given question we can identify the below functional dependencies which are violating the…
Q: Item Quantity Item Total 13. Then, Subtotal, Tax, Total Price with "SAR" 1:
A: Java Code: import java.util.*;import java.lang.*;import java.io.*; /* Name of the class has to be…
Q: One hundred students were asked whether they had taken courses in any of the three subjects,…
A: Total students = 100S(M) = 45S(M ∩ CS) = 18S(CS) = 38S(IT) = 21S(M ∩ IT) = 9S(CS ∩ IT) = 4100 - S(MU…
Q: With the following information format the data into 1st, 2nd, and 3rd normal form. Case ID Test…
A: 1st Normal Form The table in question has a composite attribute (Patient_Name) and repeated groups…
Q: ###### Qib. Report the mean, median, mini mum, maximum, and standard deviation for each numeric…
A: As given in the question we have to find mean, mode , median, standard deviation, min, max of a csv…
Q: t. Below
A: According to the question we have to plot. and I am using MATLAB to plot this.
Q: For short listing of the candidates for a job in a company in different sections based on the…
A: selection[test1_,test2_]:= Which[(test1*60/200)+(test2*40/200)>=80,"Hire in…
Q: pletion Status: What would be the table output of "Table 2 EXCEPT Table 1" where Tables 1 and Table…
A: Here in this question we have given. Two table and we have asked to perform some operation on it and…
Q: Make a flowchart for estimating Wind Load. (according to nscp 2015)
A: The answer is given below.
Q: نقطة واحدة values" column (value“ labels) in SPSS contain two item (1= car), (2= airplane), and when…
A: Dear Student, As item 2 is the most frequently occurring , and mode is the value that occurs more…
Q: The students'grades % as shown 80] %Calculate the mean of each student using % one command
A: In MATLAB mean is inbuilt function which can be used to find mean in single go.
Q: Please use c++ How do you compare the score between four workers and list them from highest to…
A: Hello Student. Greetings from my side. Hope you are doing great. I will try my best to answer your…
Q: paid salesperson for 10 months. The following are the monthly paychecks in $: 3000, 3300,
A: THE CODE IS IN BELOW STEP
Q: use the following data to shown minimum and maximum and average of parts unit price
A: Parts table: Creating parts table: create table parts (PartNo varchar(5) primary key,Description…
Q: Read the marks of a student for 3 courses. Calculate the average marks for the student. Check the…
A: Start Read marks of 3 courses Find average Initialize CGPA to 0 if average is in range 8-10 then…
Q: Determine which categories are represented in the current book inventory. List each category only…
A: The DISTINCT clause is utilized to remove duplicate records from the result set. Syntax: SELECT…
Q: How to get the minimum, 25th percentile, median, 75th, and max of a numeric series?
A: Introduction : Compute the minimum, 25th percentile, median, 75th, and maximum of ser. Input ser =…
Q: Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the…
A: First Type in the given data into a excel sheet as shown below: After typing apply the sum(B6:B9)…
Q: Question 4 Listen In 01 of the IF worksheet enter a SumIF function to find the total price of homes…
A: 1. Creating an sample excel sheet . City Price ABC 250000 Cheyenne 320000 XYZ 450000 XYZ…
Q: Table Valued Function: ufn_FetchAllAppointments This function fetches all the appointment details…
A: As Given, Function is: ufn_FetchAllAppointments We have to fetch all the appointment details from…
Q: Use an IF function to determine if the month in the employee's birth date in Cell C2 matches the…
A: if(condition,"message_if_true","message_if_false") Apply this formula on any cell of the sheet.…
Q: 4. List all customers (last name, first name and zip code) whose zip code is missing (unknown). 5.…
A: According to the Question below the Complete Query:
Q: At a local university, each engineering major requires a different number of credits for graduation.…
A: Ask the user to the enter the engineering program they want the grades for. Then according to the…
Q: In cell D5, create a formula using the VLOOKUP function to determine the cost per participant for…
A:
Q: Assume f(n) = 31/n) and g(n) = 45" and indicate the relationship between the two. Compare.1: Select…
A: Given functions are, f(n)=3(1/n3) g(n)=4log n Big Oh represents the worst case time complexity which…
Q: What is MINR minimum value across a range of value?
A: MINR: To do complex mathematical calculations, the math instruction “Calculate Expression” is used.…
Q: Get the GPA of a student as input. Calculate the CGPA according to the following table. GPA CGPA…
A: Required:
Q: 1. Using Printf , \t & \n and get the ouput as shown below *** **** **** CIMS Student Result Report…
A: Sample Response: //C programming language#include <stdio.h>//main function definitionint…
Q: A University has published the CAT1, CAT 2 and FAT exam results of Winter semester. Proctor wants to…
A: 1. HistogramA histogram is a graphical tool that works on a single variable. Numerous variable…
Q: Shop (ShopCode, ShopName, ShopSales) Which of the following queries displays name of the shop that…
A: Given question has asked select the query to display name of the shop that has the highest average…
Q: Use a data set of property value from 2007 - 2019. The data contains sale price for houses and…
A: Actually, given information Use a data set of property value from 2007 - 2019. The data contains…
Q: calculate the overtime hours using if then and end if .
A: SQL> SQL> -- Calculating overtime hours with IF. SQL> set echo on SQL> DECLARE 2…
Q: Based on given data sets (car_final.csv and car_insurance.CSV), complete the following tasks:
A: As mentioned the question the datasets are : --> car_final.csv --> car_insurance.csv a) Code…
Q: Use the Histogram tool to construct frequency distributions and histograms for weekly usage and…
A: 1) Histogram for Weekly usage
Q: 1. Make a table of five columns “Name", “Midterm Score", “Final Term Score" , “Average" and Grade.…
A: Given Grades: Below 60 : F Above 60 :D Above 70 :C Above 80: B Above 90: A
Q: Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third…
A: The given table is: Student_Car(CarPlateNo, CarDesc, CarType, BillNo, BillDate, Penalty, FinalBill)…
Q: Ask for the midterm and final grades of 20 students and write the codes that find the grade point…
A: Given that Ask for the midterm and final grades of 20 students and write the codes that find the…
Q: Normalise the following data to third normal form (3NF) Hotel Name The Palace at the Lost City L The…
A: Normalization: In SQL the process of arranging the data in the database can reduce the data…
Q: 18. The HR department needs a report of employees in Toronto. Display the last ame, job, de ment…
A: We are supposed to solve only question, please repost other question. The query is written for…
Step by step
Solved in 3 steps with 1 images
- Please use c++ How do you compare the score between four workers and list them from highest to lowest asking the user to input the score. Please use worker_1, worker_2, worker_3, worker_4 for the name and list them from highest to lowest and list the worker with the highest score that earned the promotion.INPUT Name of StudentCourse Code (1, 2 or 3)]Given Table for Tuition FeeCourse Code Tuition Fee1 - BSIT 130002 - BSECE 150003 - BSP 12000Wrong code 0OUTPUTTuition Fee to PayOn the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.
- P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…Use the _____________ function to calculate cumulative interest paid for a loan with 5 year period. CUMIPMT() PMT CUMFREQ() none of the choices CUMPRIN()In cell C19, insert a formula that will calculate the projected advertising spending after the forecasted increase in cell A18 is added to the 2019 total. Ensure that the reference to cell A18 is an absolute cell reference.
- Please Look up the current USD to AUD exchange rate to use in your function..In cell G10, insert a formula using the PMT function using the monthly interest rate (cell G6), the loan period in months (cell G8), and the loan amount (cell G4) to calculate the monthly payment for the 10 Years scenario.- The HR department needs a report to display employee information as shown from the job_history table. The months worked is the number of months from the start date to the end date. Only list those employees whose months worked is an even number. Order by months worked descending
- Using Tableau create a variable for following situation student classification Graduate undergraduate HONOR (based on classification) for graduate GPA>90 then "GOLD" for undergraduate GPA>80 then "gold ribbon"The monthly payment M of a loan amount P for y years and with interest rate r can be calculated by the formula: P(r/12) M = 1-(1+r/12)-12y Calculate the monthly payment and the total payment for a $100,000 loan for 10, 11, 12, ..., 29, 30 years with an interest rate of 4.85%. Display the results in a three-column table where the first column is the number of years, the sec- ond is the monthly payment, and the third is the total payment.
