Draw a flowchart that will design an application for Bob’s E-Z Loans. The application accepts a client’s loan amount and monthly payment amount. After the payment is made each month, a finance charge of 1 percent is added to the balance. Output the customer’s loan balance and month for each month until the loan is paid off.

Prompt the user to enter their dinner bill and the percentage they want to tip. Calculate the tip and total bill. Display a column of values aligned by the decimal place. The rows should be diner cost, tip and total.

Write a statement that declares a named constant whose value is 0.12 and name is dblRATE.

A formula with the cell reference B$2 is copied one cell to the right, what in the new cell reference

in visual c# add customer id from customer table to booking table which has a customer id column. they are primary key and foriegn key and are linked in realtionship table in access file. when button is clicked insert first name into booking table in first name column. This should automaically copy customer id to booking table in customer id column without coding

Ex2. Write down two functions: transfer and receive from a bank account The settings will be transferred to two users of the bank. Must be a user Presented as a struct and must have an account attribute. That is, the program should ask you to enter the bank account (string type) and the name of the person to whom you are transferring the amount, as well as the amount of the money. If the amount is more than $ 1000, the program must print a notification to enter a fee - 10% of the amount. After entering 10% of the amount, print on the screen that the amount has been transferred.

The university is creating a new application that can either assign student awards and bursaries or provide academic warnings based on several criteria. The university administrators have come to you to program a solution that meet their requirements, outlined below: 1. The application must state whether a student is on the "Dean's List" if their GPA is 10.0 or better. 2. The application must state whether a student continues to receive their entrance scholarship if their GPA is 10.0 or better. 3. The application must state whether a student will be given an academic warning if their GPA is less than a given threshold. As the threshold differs according to program, the application must be able to accept any threshold when making this determination. 4. The application should accept an administrator's input for each of the determinations above and should allow the administrator to enter data for as many students as they wish without having to restart the application. Once the…

Write a stored procedure named displayNumberOfFilmRatings(). The displayNumberOfFilmRatings () procedure should find number of films for each film rating and then display the film rating and the number for films having that type of rating. Note: The displayNumberOfFilmRatings() procedure does not need to declare any variables. Hint: The output should have two columns only. Hint: There is no need to use cursor processing for this stored procedure.

Create a user-defined function called calculate_gains(), which receives the amount desired to be invested. Outside this function, create a global variable, multiplier_amount that would be accessible at any point in your code to store the "multiplier amount", which will be the amount that would trigger the increase on the gain margin in case the invested amount is greater than this value. In our case, this amount is set to 1 million. Inside your function, create a variable to store the gain margin, which is 0.1% by default. Also create variables for total_gains and total_amount, setting default values to 0. After these declarations, the first thing to check is whether the amount invested is greater than 1000 (one thousand), which is the minimum application value to start using the app. Next, check if the amount is greater than the multiplier value (1 million). If it is greater, then update the gain margin variable with the new gain margin and add the estimated amount to the original…

In the following pseudocode of creating a trigger, the first UPDATE is the ____ of the trigger, and the second UPDATE is the ____ of the trigger. CREATE TRIGGER MyTrigger AFTER UPDATE OF attr ON MyTable ... WHEN ... UPDATE MyTable .... Group of answer choices Action; action Condition; action Event; action Event; condition