Blog

Coursehelp
May 23, 2019
Uncategorized No Comments

(Solved) : Use Reps Regionsxls Worksheet Follow Steps Complete Spreadsheet 1 Create Dashboard Includi Q31102570 . . .

• Use Reps and Regions.xls Worksheet Follow the steps below tocomplete the spreadsheet: 1. Create Dashboard including a chart. 2.Arrange slicers. 3. Make each slicer a different color. 4. Putthree columns in “Order Date” 5. Put two columns in “Rep” 6. Putuseful number of columns in “Units” 7. Add column(s) to “Total” 8.On what item did Jones have the largest dollar sales? 9. On whatdate did Howard sell the most pens? 10. On 9/10/2016, what productdid Sorvino sell? 11. Is Kivell or Parent the best overallsalesperson?

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Relational Algebra Alg Tuple Relational Calculus Trc Express Following Queries Based G Q26658976 . . .

Use both Relational Algebra (ALG) and Tuple Re culus (IRC) to express the following queries based on the given Bank-Customer database. Submit your ALG and TRC query expressions for these queries as well as the final query resuls. Each ALG or TRC query is 3 marks and the result is 2 marks Bank B Name City B1 England London B2 America New York B3 Royal Toronto B4 France Paris Account Ical el Balance CI B1 1000 CI B2 2000 CI B3 3000 CI B4 4000 C2 B 2000 C2 B2 3000 C2 B3 4000 C3 B1 3000 C3 B2 4000 CA B1 4000 C4 B2 5000 Customer C Name Age City C1 Adams 20 London C2 Blake C3 Clark25 Paris C4 Your Lastname 20 Ottawa CS Smith 30 Toronto 30 Paris 1. Get the name of the bank that Your Lastname banks. 2. Get the name of the customer who banks in Royal bank. 3. Get the name of the customer who has an account with balance less than 3000. 4. Get the name of the customer who banks in Royal or America bank. 5. Get the customer name/bank name pairs such that the indicated customer has an account in the indicated bank. 6. Get the name of the customer who does not have any bank account. 7. Get the name of the customer who has an account in every bank. 8. Get the name of the customer who has an account in every bank except France Bank. 9. Get the name of the customer who has an account in every bank that Clark banks. 10. Get the name of the customer who banks only in the banks that Clark banks 11. Get the name of the customer, the number of banks he/she banks, and total balance he/she has. 12. Get the name of the customer who banks in more than two bank.

Use both Relational Algebra (ALG) and Tuple Relational Calculus(TRC) to express the following queries based on the givenBank-Customer database.

Use both Relational Algebra (ALG) and Tuple Re culus (IRC) to express the following queries based on the given Bank-Customer database. Submit your ALG and TRC query expressions for these queries as well as the final query resuls. Each ALG or TRC query is 3 marks and the result is 2 marks Bank B Name City B1 England London B2 America New York B3 Royal Toronto B4 France Paris Account Ical el Balance CI B1 1000 CI B2 2000 CI B3 3000 CI B4 4000 C2 B 2000 C2 B2 3000 C2 B3 4000 C3 B1 3000 C3 B2 4000 CA B1 4000 C4 B2 5000 Customer C Name Age City C1 Adams 20 London C2 Blake C3 Clark25 Paris C4 Your Lastname 20 Ottawa CS Smith 30 Toronto 30 Paris 1. Get the name of the bank that “Your Lastname” banks. 2. Get the name of the customer who banks in Royal bank. 3. Get the name of the customer who has an account with balance less than 3000. 4. Get the name of the customer who banks in Royal or America bank. 5. Get the customer name/bank name pairs such that the indicated customer has an account in the indicated bank. 6. Get the name of the customer who does not have any bank account. 7. Get the name of the customer who has an account in every bank. 8. Get the name of the customer who has an account in every bank except France Bank. 9. Get the name of the customer who has an account in every bank that Clark banks. 10. Get the name of the customer who banks only in the banks that Clark banks 11. Get the name of the customer, the number of banks he/she banks, and total balance he/she has. 12. Get the name of the customer who banks in more than two bank. Show transcribed image text Use both Relational Algebra (ALG) and Tuple Re culus (IRC) to express the following queries based on the given Bank-Customer database. Submit your ALG and TRC query expressions for these queries as well as the final query resuls. Each ALG or TRC query is 3 marks and the result is 2 marks Bank B Name City B1 England London B2 America New York B3 Royal Toronto B4 France Paris Account Ical el Balance CI B1 1000 CI B2 2000 CI B3 3000 CI B4 4000 C2 B 2000 C2 B2 3000 C2 B3 4000 C3 B1 3000 C3 B2 4000 CA B1 4000 C4 B2 5000 Customer C Name Age City C1 Adams 20 London C2 Blake C3 Clark25 Paris C4 Your Lastname 20 Ottawa CS Smith 30 Toronto 30 Paris 1. Get the name of the bank that “Your Lastname” banks. 2. Get the name of the customer who banks in Royal bank. 3. Get the name of the customer who has an account with balance less than 3000. 4. Get the name of the customer who banks in Royal or America bank. 5. Get the customer name/bank name pairs such that the indicated customer has an account in the indicated bank. 6. Get the name of the customer who does not have any bank account. 7. Get the name of the customer who has an account in every bank. 8. Get the name of the customer who has an account in every bank except France Bank. 9. Get the name of the customer who has an account in every bank that Clark banks. 10. Get the name of the customer who banks only in the banks that Clark banks 11. Get the name of the customer, the number of banks he/she banks, and total balance he/she has. 12. Get the name of the customer who banks in more than two bank.

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Round Robin Scheduling Find Completion Time Turnaround Time Average Wating Time Q31474887 . . .

Process Arrival Time Burst Time Priority P1 P2 P3 P4 P5 1 12 3 1 4 16 10 2 1

Use Round Robin scheduling to find completion time, turnaroundtime, and average wating time

Process Arrival Time Burst Time Priority P1 P2 P3 P4 P5 1 12 3 1 4 16 10 2 1 Show transcribed image text

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Recursion Tree Method Guess Tight Asymptotic Bounds Recurrene Use Substantiation Meth Q28149866 . . .

Use the recursion tree method to guess tight asymptotic boundsfor the recurrene T(n) = 4T (n/2) + n . Use substantiation method to prove it

T(n) = 4T (n/2) + n Show transcribed image text

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Recursion Tree Determine Good Upper Bound Recurrence T N 4t N 2 2 N Q31072928 . . .

)Use a recursion tree to determine a good upper bound on therecurrence T(n) = 4T(n/2 + 2) + n.

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use References Access Important Values Needed Question Ruthenium Iv Oxide Prepared Heating Q31043678 . . .

Use the References to access important values if needed for this question. Ruthenium(IV) oxide can be prepared by heating ruthenium(VIII) oxide in vacuo t high temperature The reaction of 436.5 g of Ruo4 yields 297.5 g of Ruo2 Calculate the theoretical ield of RuO2 (assuming complete reaction) and its percentage yield. Theoretical yield Percentage yield Submit Answer 5 question attempts remainingUse the References to access important values if needed for this question. Ruthenium(IV) oxide can be prepared by heating ruthenium(VIII) oxide in vacuo t high temperature The reaction of 436.5 g of Ruo4 yields 297.5 g of Ruo2 Calculate the theoretical ield of RuO2 (assuming complete reaction) and its percentage yield. Theoretical yield Percentage yield Submit Answer 5 question attempts remaining Show transcribed image text

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Repeated Substitution Find Running Time T N 4n T N 3 Assume T 1 1 Q27561572 . . .

Use repeated substitution to find the running time of T(n) = 4n+ T(n/3). Assume T(1) = 1.

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Repeated Substitution Find Running Time T N N 2 4t N 2 Assume T 1 1 Q27561577 . . .

Use repeated substitution to find the running time of T(n) = n^2+ 4T(n/2). Assume T(1) = 1.

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Repeated Substitution Find Running Time T N 4n T N 1 Assume T 1 1 Q27561560 . . .

Use repeated substitution to find the running time of T(n) = 4n+ T(n-1). Assume T(1) = 1.

Expert Answer


. . .

READ MORE
Coursehelp
Uncategorized No Comments

(Solved) : Use Sample Code Write Program Calculate Compound Interest Comments Give Hints Code Need Q27336324 . . .

Use the sample code below to write a program that calculate compound interest .The comments (// …) give you hints about the code you need to add to make the program work. using System;namespace CompoundInterestCalculator { public class CompoundCalculator { const int EXIT = 0; const int CALCULATE_DAILY = 1; const int CALCULATE_QUARTERLY = 2; const int CALCULATE_VARIABLE = 3; const int NUM_OPTIONS = 3; public static void Main() { int menuOption; WelcomeMessage(); do { DisplayMenu(); menuOption = ReadOption(); if (menuOption != EXIT) { double finalAmount = CalculateInterest(menuOption); OutputResult(finalAmount); } } while (menuOption != EXIT); ExitProgram(); } // end Main // Fill in the appropriate modifier and return type (_ _) in the method declaration public _ _ WelcomeMessage() { Console.WriteLine(“nntCompound Interest Calculatorn”); } // end WelcomeMessage // Fill in the appropriate modifier and return type (_ _) in the method declaration public _ _ ExitProgram() { Console.Write(“nnPress enter to exit.”); Console.ReadLine(); } // end ExitProgram static void DisplayMenu() { string menu = “nn1) Calculate final amount after interest (compounded daily)” + “n2) Calculate final amount after interest (compounded quarterly)” + “n3) Calculate final amount after interest (define number of times compounded yearly)” + “nnEnter your option(1-3 or 0 to exit): “; Console.Write(menu); } // end DisplayMenu public static void OutputResult(double finalAmount) { // Display the message “The final amount of money plus interest is: $(amount)” // The amount should display as currency, with two decimal places, e.g. $10,000.00 } // end OutputResult static int ReadOption() { string choice; int option; bool okayChoice; do { choice = Console.ReadLine(); okayChoice = int.TryParse(choice, out option); if (!okayChoice || option < 0 || option > NUM_OPTIONS) { okayChoice = false; Console.WriteLine(“You did not enter a correct option.nn Please try again”); DisplayMenu(); } } while (!okayChoice); return option; } // end ReadOption public static double CalculateInterest(int menuOption) { // (For this exercise, we will assume the user is inputting correct input.) double principal; double interestRate; int numYears; double finalAmount; Console.Write(“Enter the principal amount: “); principal = Double.Parse(Console.ReadLine()); Console.Write(“Enter the interest rate: “); interestRate = Double.Parse(Console.ReadLine()); Console.Write(“Enter the number of years that interest is accumulated for: “); numYears = Int32.Parse(Console.ReadLine()); if (menuOption == CALCULATE_DAILY || menuOption == CALCULATE_QUARTERLY) { if (menuOption == CALCULATE_DAILY) { // Call the appropriate CalculateCompoundInterest method } else { // Call the appropriate CalculateCompoundInterest method } } else { Console.Write(“Enter the number of times the interest is compounded yearly: “); int numTimesCompounded = Int32.Parse(Console.ReadLine()); // Call the appropriate CalculateCompoundInterest method } Console.WriteLine(); // return the amount calculated by the compound interest method } // End CalculateInterest // Declare and implement the method CalculateCompoundInterest whose parameters are the principal, interest rate, and number of years (in that order)- make sure it is public! // For the declaration select an appropriate modifier, return type, and types for the parameters // This version assumes the interest is compounded daily (365 times a year) // Declare and implement the method CalculateCompoundInterest whose parameters are the principal, interest rate, number of years, and number of times compounded yearly – make sure it is public! // For the declaration select an appropriate modifier, return type, and types for the parameters // This version allows the number of times compounded yearly to be specified. }//end class}//end namespace

Write a program in C# that calculates compound interest The formula for compound interest is: A P+(r/m) Where ·A = Accrued Amount (principal plus interest) ·P-Principal Amount · r Annual interest rate (as decimal) · t = Number of years · Number of times interest is compounded per year Write the program using methods. Finish the method heading of two methods – WelcomeMessage0 and ExitProgram0 – by selecting the appropriate moditfiers and return types, and finish the header and method body of OutputResult0. Finally, implement two CalculateCompoundInterest0 methods which calculate the accrued amount – one which takes as parameters the principal, interest rate, and number of years accumulating interest, and assumes the number of times interest is compounded per year is daily (365), and another that allows the number of compounds per year to be specified Your code will be run by calling the two versions of the CalculateCompoundInterest0 method, OutputResult0 and ExitProgram0 methods directly. As a result, make sure you make these methods public. Show transcribed image text Write a program in C# that calculates compound interest The formula for compound interest is: A P+(r/m) Where ·A = Accrued Amount (principal plus interest) ·P-Principal Amount · r Annual interest rate (as decimal) · t = Number of years · Number of times interest is compounded per year Write the program using methods. Finish the method heading of two methods – WelcomeMessage0 and ExitProgram0 – by selecting the appropriate moditfiers and return types, and finish the header and method body of OutputResult0. Finally, implement two CalculateCompoundInterest0 methods which calculate the accrued amount – one which takes as parameters the principal, interest rate, and number of years accumulating interest, and assumes the number of times interest is compounded per year is daily (365), and another that allows the number of compounds per year to be specified Your code will be run by calling the two versions of the CalculateCompoundInterest0 method, OutputResult0 and ExitProgram0 methods directly. As a result, make sure you make these methods public.

Expert Answer


. . .

READ MORE