R&R Travel and Tours offers special promotion flight fare from Kuala Lumpur to Kota Bharu on February 2015. Passengers under 12 years old will be subjected to Children rates. The special rates are shown in Table 1. Table 1: Special rates from Kuala Lumpur to Kota Bharu Airlines Airlines Rates Code Adult Children 1 Air Asia RM 100 RM 20 Malaysia Airlines Malindo Air 2 RM 210 RM 50 3 RM 90 RM 10 Calculate the total amount of flight fares according to Table 1. Use loops to ask if customer wants to add more booking.
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: Complete the following exercise: Using your student table select all students that have a last name…
A: The name of the table is student Attributes of the student table are ID, FirstName, LastName ,…
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: Doctor id Doctor_name Degree Join year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM…
A: Given: To write a query to show the doctor name and degree in the following format; Example: Saleh…
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: Problem 1 Display the number of students. Use the student.student table. Problem 2 Display all…
A: Java used to answer this question
Q: t. Use relative and mixed cell references correctly. Copy the formula for the Sunday column to…
A: To calculate revenue per day for each type of seating, we will use the following formula: = number…
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: 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: The population of the five most populous Australian cities at the last three census is recorded in…
A: Since no programming language is mentioned, I am using Matlab. Code:…
Q: Draw BST from the following values: 2, 9, 4, 15, 20, 7, 12, 1, 18
A: The binary search tree is said to be a node-based binary tree. Its left subtree values are lesser…
Q: The pg2.np_2016traffic table contains monthly traffic statistics from the National Park Service for…
A: Given : we have to create a new table which will contain monthly traffic statistics with park names.…
Q: 3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total…
A: Since there is no programming language and approach mentioned we will be using C++ and object…
Q: Cafe Customer name: john Customer Table number: 8 Please enter order [1]: maggie Please enter…
A: C Program for above : #include <stdio.h> int main() { char name[20], order[3][20];…
Q: Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales.…
A: Flowchart:
Q: Select number of movies grouped by year USING MySQL The Movie table has the following columns:…
A: Answer: Given table name is Movie Select statement is used to print the required fields on the…
Q: 19. The following code refers to the sample data in the table people. What is the result of each…
A: Note: - As per the guidelines we can only answer one specific question at a time. Please resubmit…
Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…
A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…
Q: Company also likes to find out the total purchase amount and the number of transactions made by each…
A: Please find the answer in step 2.
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: Happy Shop sells different products to the customers. A customer could buy one or more products at a…
A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…
Q: Use arithmetic operators and aggregate functions. Procedure: 1. Create a table named StudentGrade…
A: --creating tablecreate table studentgrade(coursecode varchar(30),coursetitle varchar(30),units…
Q: Task 4: ' The Car Maintenance team wants to add new maintenance tasks into the system. The team has…
A: SQL Query:
Q: Convert the following epsilon NFAs to NFAs with complete transition table
A: Here i am explaining the steps to convert it:…
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: Your Name UMC Theaters Ticket Sales Theater Cocoplace Sunset Walk October November December Totals…
A: In this the data is for comparison of theaters ticket sales per month. In this situation, we cannot…
Q: 7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT…
A: Since you have asked multiple questions, we solve first question for you. If you want any specific…
Q: 3.Write a MYSQL statement to create a table named jobs including columns job_id, job_title,…
A: CREATE TABLE IF NOT EXISTS jobs ( JOB_ID varchar(100) NOT NULL , JOB_TITLE varchar(350) NOT NULL,…
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: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…
A: Let the table name be emp which has the following columns employee_id, first_name, last_name,…
Q: 17. Update the salary of the instructors by making it 50000 if it is less than 50000 and 90000 if it…
A: SQL query Information on integrity constraint
Q: 550g [1] Ground Beef [2] Beef Cubes 550g [3] Breakfast Steak 550g [4] Ribeye Steak 550g [5] Sirloin…
A: #include <iostream> int main() { std::cout << "\n* BEEF…
Q: D Panda EST Monthly Sales Report - July Salary Sales Amount 1600 1800 1500 Comission 25007 3000…
A: Answer: I have given answered in the handwritten format in brief explanation.
Q: Objective: At the end of the exercise, the students should be able to: Use arithmetic operators and…
A: Given student course table for we have to create table and insert data and write the queries using…
Q: q. if the payee, such as a grocery store, keeps the original check, this is called ____ a.) primary…
A: The solution to the given problem is below.
Q: Write a program that allows the user to set the loan amount, loan period, and interest rate, and…
A: Program code: //Import java files import java.awt.*; import java.text.*; import javax.swing.*;…
Q: Use single-row subquery in a HAVING clause. List customer numbers of customers who paid total amount…
A: A unmarried row subquery returns 0 or one row to the outer SQL assertion. You can area a subquery in…
Q: Assigned Problem: Delete all penalties and matches of player 104, regardless of whether the player…
A: Here have to determine delete sql query.
Q: In cell B16, use the SUMIF function to display the total wins for teams in the Yo
A: The, Answer has given below:
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: 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: Customer ID 1 2 3 4 5 6 7 8 9 10 Items of transaction {A,B,E,D} {A,C,D,E} {D,E,A} {E,B,A,C}…
A: please do upvote for my efforts ! answer:
Q: enter students' data in four columns, the first column gets students' names, the second column…
A: #include<iostream>using namespace std;int main(){ int n; cout<<"Enter size of the…
Q: F A E a. b. C. B d. C 00 8 7 6 5 4 What do the letters in the box plot above represent? 3 2- 1- A =…
A: A box plot displays the five-number summary of a set of data. The five-number summary is the…
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 5 steps with 5 images
- SeriResort has four type of room packages, The rate for each package is shown in the following table: Type of Package Code Rate Per Day (RM) Premium 1 300 Family 2 200 Deluxe 3 150 Standard 4 100 Each guest has to pay 10% SST. The information needed to make a reservation at the resort are the guest’s name, type of package, number of days and type of booking (o – online, M – Manual). A discount of 10% will be given for online booking For each reservation, a receipt must be printed as shown below: SERI RESORT Guest Name xxxxxxxxxxxxxxx Type of Package xxxxxxxxxxxxx Number of Days xx Total Charges (RM) : xxx.xx SST 10% (RM) : xxx.xx Total Payment : xxxxx.xx Draw a flowchart to solve the given.Suppose it is 4:00 p.m., September 29, 2008. Fitter Snacker’s CEO sends this e-mail message to the accounting manager: “I need to meet with the Board of Directors tomorrow morning. The Board members are concerned about the current sales of our energy bars. They would like to see sales data for today, 9/29, as a typical day. Please complete the attached report and have it on my desk by 9:00 a.m. tomorrow, September 30.” The blank table shown in Figure 1 is attached to the memo. Given the company’s sales order data-processing practices, why won’t the accountants be able to easily accomplish this task? Cite the practices that cause difficulty, and explain. If FS had an ERP system, why would this task be easy to complete?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.
- IN SCALA COULD YOU COMPLETE THE FUNCTIONS: get_january_data, get_first_price, get_prices, get_delta, get_deltas, yearly_yield, compound_yield AND investment val blchip_portfolio = List("GOOG", "AAPL", "MSFT", "IBM", "FB", "AMZN", "BIDU")val rstate_portfolio = List("PLD", "PSA", "AMT", "AIV", "AVB", "BXP", "CCI", "DLR", "EQIX", "EQR", "ESS", "EXR", "FRT", "HCP") // (1) The function below takes a stock symbol and a year as arguments.// It should read the corresponding CSV-file and then extract the January // data from the given year. The data should be collected in a list of// strings (one entry for each line in the CSV-file). import io.Sourceimport scala.util._ def get_january_data(symbol: String, year: Int) : List[String] = ??? // (2) From the output of the get_january_data function, the next function // should extract the first line (if it exists) and the corresponding// first trading price in that year with type Option[Double]. If no…Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) Commission 1–5,999.99 10% of sales 6,000–29,999.99 $600 plus 13% of the sales over 6,000 30,000 and over $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total dueIncome Incorrect downvote please.
- Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting. In the same worksheet in part (c) dynamically apply the following formats for Qtr1and Qtr4 for all related revenue types:i. Values over $140,000 should be yellow. [2]ii. Values under or equals to $80,000 should be read and bolded Thom-Pierre Consultants (TPC) Quarterly Schedule of Revenue For the year December 31, 2018 QTR1 QTR2 QTR3 QTR4 2018 Sales 290000 320000 320000 490000 Interest 102500 175000 180000 54000 Investment Income 13000 9500 10000 20000 Other 16000 25000 19500 29000 TotalIn 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.(c) Using IF and VLOOKUP functions, write a formula in cell H24 to find the spot server's discount rate. For on-demand servers, the discount rate is 0%. Copy the formula to H25 to H41. Screenshots attached below thank you!!!!
- Qustion number 3 using paython, please!Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)(f) Write a formula in cell K24 to compute the Total cost for the given server. Total Cost = Rate per hour after discount * # of hours Rented. Copy the formula from K25 to K41. Screenshots attacched thank you