Question: In this assignment, you will create a program using Raptor and written in SQL language. Scenario: You work as the night manager for a local
In this assignment, you will create a program using Raptor and written in SQL language.
Scenario: You work as the night manager for a local grocery store chain. One of your duties includes to go to several store locations at closing time to collect cash and checks on hand at the end of the day. After collecting, you must record how much money (specifically bill denominations) was collected from each store and then calculate the grand total. You currently are counting by hand, using a simple calculator and recording this in a notebook. Create a program to help you with this nightly task. You know that if this is successful, you can promote this to the other managers as well as other local stores that have chains, so you want to create proper documentation.
The program will do the following:
- Collect check amounts, if there are any available, for each store.
- Collect cash amounts by denominations for each store, including coins, if there are any.
- Display the total amount, including cash and checks, for each store.
- Display the total amount of cash and checks collected from all store.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
