Display account number and balance for all customers

Assignment Help PL-SQL Programming
Reference no: EM13317707

Objectives

This assessment item is designed to test your understanding of arrays/arraylists, objects, classes, methods, sorting and searching.

Assessment task

Write a java application that allows the user to read, validate, store, display, sort and search the account number and balance for N bank customers. N should be declared as a constant and it should be equal to the largest digit of your student id number (e.g. if your ID number is S0159226 then N should be equal to 9 and you can declare it as final int N=9;). The account number and balance must be stored in two separate single dimension arrays/arrayLists (index 0 for customer 1 and index N-1 for customer N). The minimum and maximum account numbers which can be stored are 999 and 9999. The minimum and maximum account balances which can be stored are $1 and $100000. The account number and balance must be entered from the keyboard and a validation for minimum and maximum values must be done.

Your application should display and execute a menu with the following options. A switch statement must be used to execute the following menu options.
1. Read, validate and store account number and balance for N customers
2. Display account number and balance for all customers
3. Display all account numbers which have $1 balance
4. Find and display the account balances which have below the average balance
5. Find and display the account number with the largest balance
6. Sort and display the account balances in descending order
7. Search and display the accounts which have balance equal to the given balance
8. Exit from application

1. Read, validate and store account number and balance for N customers This option reads account number and balance for all customers from the keyboard and stores them in two separate single dimension arrays/arrayLists. If the account number is less than 999 and greater than 9999 then an appropriate message should be displayed and the user should be asked to enter a new account number. Similarly if the balance is less than $1 and greater than $100000 then an appropriate message should be displayed and the user should be asked to enter a balance.

2. Display account number and balance for all customers This option displays the account number and balance stored in Arrays/ArrayLists for all customers.

3. Display all account numbers which have $1 balance This option displays all account numbers stored in Array/ArrayList which have $1 balance.

4. Find and display the account balances which have below the average balance This option finds and displays the account balances stored in Array/ArrayList which have balance below the average balance.

5. Find and display the account number with the largest balance This option finds and displays the account number stored in Array/ArrayList which has largest balance. If there is more than one account with the same balance (largest balance) then it displays all of them.

6. Sort and display the account balances in descending order This option sorts and displays account balances stored in Array/ArrayList for all customers in descending order. You must use the Selection Sort algorithm. A built-in sort algorithm for sorting is not allowed in this assignment.

7. Search and display the accounts which have balance equal to the given balance This option searches Array/ArrayList and displays the accounts which have balance equal to the given balance. The application asks the user to enter a balance using the keyboard and searches for it. If the balance entered from the keyboard is found then the application displays account number and balance otherwise it displays an appropriate message. A built-in search algorithm for searching can be used in this assignment.

8. Exit from application The application should display the message "Thank you" and your student id number and then exit from application.

The application should work in a loop to enable the user to read, validate and store account number and balance for N customers, display account number and balance for all customers, display all account numbers which have $1 balance, find and display the account balances which have below the average balance, find and display the account number with the largest balance, sort and display the account balances in descending order, search and display the customers which have balance equal to the given balance and exit from application.

Reference no: EM13317707

Questions Cloud

Compute the pw for the pessimistic and optimistic : An energy efficiency project has a first cost of $300,000, a life of 10 years, and no salvage value. Assume that the interest rate is 9%. The most likely value for annual savings is $60,000.
Calculate the magnitude of the total force supported : The uniform 4 meter boom has a mass of 60 kg and is pivoted to the back of the truck at A and secured by a cable at C. Calculate the magnitude of the total force supported by the connection at A
Calculate the change in entropy of a gas of mass : calculate the change in entropy of a gas of mass 8kg when 100 kj of heat energy is supplied to the gas. the temperature of the gas remains constant at 100 c during the heat transfer process
What is the settling velocity of a floc of diameter in water : What is the settling velocity of a floc of diameter 0.15 mm and density 2.12 g/cm3 in water. Will the floc from problem 4 be completely removed in a typical sedimentation basin if alum was used as the coagulant.
Display account number and balance for all customers : This assessment item is designed to test your understanding of arrays/arraylists, objects, classes, methods, sorting and searching.
By how much does its volume decrease : The deepest place in all the oceans is the Marianas Trench, where the depth is 10.9 km and the pressure is 1.10×10^8Pa. by how much does its volume decrease
How is the time spent on leisure likely to change : As the skill level (and therefore earnings rate) of, say, an architect, computer specialist, or chemist increases, what happens to his or her opportunity cost of doing other things? How is the time spent on leisure likely to change?
During the last three decades entrepreneurs like michael : During the last three decades entrepreneurs like Michael Dell, Sam Walton, and Ted Turner earned billions of dollars. Do you think the average American is better or worse off as the result of the economic activities of these individuals? Explain your..
Which of the two groups will participate more in the work : Consider the choices of two groups of women ages 30 to 50. All the women in one group have a college education. All the women in the other group have less than a high school education

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write sql create table statement to create pet table

Write an SQL CREATE TABLE statement to create the PET table without referential integrity constraint on OwnerID in PET.

  Write a perl subroutine for temperature conversion

Write a perl subroutine for temperature conversion named 'convert_temp'. It should be able to handle both Fahrenheit to Celsius conversions as well as Celsius to Fahrenheit conversions.

  Write pl-sql block that displays last name

Write PL/SQL block which displays last name and salary of following people. Each of these can be done separately as PL/SQL, first to test and get output lines.

  Find the sum of the elements of a

A is an ArrayList of size N. The elements of A are integers, they are in sorted order increasing from the low end of the array, and no two integers are the same. Variable x is an integer. Which of the following operations takes time that is less t..

  Can we offer an example of a query

Can we offer an example of a Query in which we can use a parentheses to affect the order of execution in which the WHERE Clause has both AND and OR Logical Operators?

  Sql script-creating the database and inserting data

Understanding the SQL script, creating the database and inserting data and display all product information for products that contain the string ‘saw' in their description.

  Write a select statement

Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1.

  What is the expected profit for one month

Investigate the profitability that would result if instead of baking 30 batches each morning, they bake 25, 30, 35, or 40 batches. Which would you recommend and why? (You should use Decision Table with Crystal Ball, or Scenario Manager if plain Ex..

  Decomposition for r = (a,b,c,d,e )

Give a good decomposition for R = (A,B,C,D,E ) with the following functional dependencies:

  Calculate days between ordering and shipping

Calculate the Tax on an Order, Calculate the Total Shopper Spending - Develop a SELECT statement using the BB_SHOPPER table to produce a list of each shopper in the database and his or her respective totals.

  Convert requirement to logic and then to sql

Prepare the SQL query for each of given requirements. Convert requirement to logic, then to SQL. Illustrate the names of all products which have been sold.

  F does not logically imply

Given R = (J,K,L ) and the set F of FDs J -> K and L -> K , show that F does NOT logically

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd