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

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

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