*6.7 (Financial application: compute the future investment value) Write a method that computes future investment value at a given interest rate for a specified number of years. The future investment is determined using the formula in Programming Exercise 2.21. Use the following method header: public static double futureInvestmentValue( double investmentAmount, double monthlyInterestRate, int years) For example, futureInvestmentValue(10000, 0.05/12, 5) returns 12833.59. Write a test program that prompts the user to enter the investment amount (e.g.., 1000) and the interest rate (e.g., 9%) and prints a table that displays future value for the years from 1 to 30, as shown below: The amount invested: 1000 Enter Annual interest rate: 9 Enter Years Future Value 1 1093.80 1196.41 29 13467.25 30 14730.57

*6.7 (Financial application: compute the future investment value) Write a method that computes future investment value at a given interest rate for a specified number of years. The future investment is determined using the formula in Programming Exercise 2.21. Use the following method header: public static double futureInvestmentValue( double investmentAmount, double monthlyInterestRate, int years) For example, futureInvestmentValue(10000, 0.05/12, 5) returns 12833.59. Write a test program that prompts the user to enter the investment amount (e.g.., 1000) and the interest rate (e.g., 9%) and prints a table that displays future value for the years from 1 to 30, as shown below: The amount invested: 1000 Enter Annual interest rate: 9 Enter Years Future Value 1 1093.80 1196.41 29 13467.25 30 14730.57

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

Create the table that results from applying a UNION relational operator to the two tables BOOTH and MACHINE
Which of the following are equivalent to WHERE attribute IN (123, 200)? a. WHERE attribute BETWEEN 123 AND attribute = 200 b. WHERE attribute = 123 AND attribute = 200 c. WHERE attribute <= 123 AND attribute >= 200 d. WHERE attribute = 123 OR attribute = 200
Ch2 Question 9: Cell entries can be indented from either the left or right edge of the cell. Answer: A. True B. False Question 10: Using the Merge & Center command can give the same result as using the Merge Across and Center alignment commands together. Answer: A. True B. False
How do you tell the difference between a team and a domain?
question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
write the code for the following triggers in MySQL following the style shown in the text. A: When adding a customer, add the customer balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. B: When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. C: When deleting a customer, subtract the balance multiplied by the sales rep's commission rate from the commission for the corresponding sales rep. CREATE TABLE REP(REP_NUM CHAR(2) PRIMARY KEY,LAST_NAME CHAR(15),FIRST_NAME CHAR(15),STREET CHAR(15),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),COMMISSION DECIMAL(7,2),RATE DECIMAL(3,2) );CREATE TABLE CUSTOMER(CUSTOMER_NUM CHAR(3) PRIMARY KEY,CUSTOMER_NAME CHAR(35) NOT NULL,STREET CHAR(20),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),BALANCE DECIMAL(8,2),CREDIT_LIMIT DECIMAL(8,2),REP_NUM CHAR(2) );INSERT INTO…
Stal >>> Run PS6_P2_solution.py Vehicle: Make: Tesla Model: Model 3 Year: 2022 Age: 1 years Vehicle: Make: Ford Model: F-150 Year: 2020 Max Load: 10000 lbs Age: 3 years Can the truck carry 11000 lbs? No >>>
1) What is a valid statement to create a table called "devices"? Group of answer choices CREATETABLE(devices{devid:INTEGER,devtype:CHARACTER,devname:VARCHAR}); CREATETABLEdevicesASdevIdINTEGER,devTypeCHARACTER,devNameVARCHAR; CREATETABLEdevices(devIdINTEGER;devTypeCHARACTER(10);devNameVARCHAR(45);); CREATETABLEdevices(devIdINTEGER,devTypeCHARACTER(10),devNameVARCHAR(45)); 2) What is output to the browser? <?phpfunctionsomethingNew(){try{echo"Trying something new...";thrownewException("Errors found >> ");}catch(Exception$e){echo"[Error]";}finally{echo"Made it! ";}echo"One last thing ";}somethingNew();?> Group of answer choices Trying something new... Made it! One last thing Trying something new...Errors found >>[Error] Trying something new...[Error]Made it! Trying something new...[Error]One last thing 3) When using the file upload widget, the uploaded file is placed in _____ on the web server. Group of answer choices the destination…
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.
below: 1 2 3 In Microsoft Excel calculate the result of each cell in the C column of the table 45 A 50 22 14 0 C Average (B1:B5) B 3 10 = A1^2 7 16 8 - Count (A1:A4) = A1*B3 = Sum (A1:A5) Your answer