Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Bartleby Related Questions Icon
Related questions
Question
You can Use C++
The following table contains quarterly sales figures for five (5) departments:
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total
Department 1
750
660
910
800
Department 2
800
700
950
900
Department 3
700
600
750
600
Department 4
850
800
1000
950
Department 5
900
800
960
980
Total
Design and write a Windows program/module named SalesAnalysis that will:
- Declare a two-dimensional integer array named sales – (Note: you have 6 rows and 5 columns) - that will hold the 4 quarterly sales for 5 departments
- Populate the first four columns for the 5 departments using the data in the preceding table.
- Contain a loop to compute and populate the total column. Store each department’s total in the array as it is being computed.
- Contain a loop to compute and populate the total row. Store each quarter’s total in the array as it is being computed.
- Using a Procedure (sub program – Private or Public) format and display the table with both the row and column totals. Pass the array as an argument – ByVal. Make sure to document and/or provide comments as much as you can. Remember to include comments in the program body to explain the codes. Provide the
algorithm for the program
Expert Solution
Check MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
bartleby
Trending nowThis is a popular solution!
bartleby
Step by stepSolved in 3 steps with 1 images
Knowledge Booster
Background pattern image
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Please help me in creating a tic tac toe game using java. Requirements are below. Thank youarrow_forwardPLEASE HELP ME WITH THIS! THANK YOU! Develop a program that will define and store a student record. The data will be entered by the user. Afterwards, calculate and display the GPA of each student. You will need to use structure with array. In case you don't know how to calculate GPA, here's the formula: Sample Console Input Expected Console Output 2John Anthony10912345ECEPhysics1003Mathematics702Geology501Jose10854321CPEPhysics803Mathematics602Geology901 Enter number of students to record: 2student name: John AnthonyID number: 10912345degree: ECEcourse 1 name: Physicscourse 1 grade: 100course 1 total units: 3course 2 name: Mathematicscourse 2 grade: 70course 2 total units: 2course 3 name: Geologycourse 3 grade: 50course 3 total units: 1student name: JoseID number: 10854321degree: CPEcourse 1 name: Physicscourse 1 grade: 80course 1 total units: 3course 2 name: Mathematicscourse 2 grade: 60course 2 total units: 2course 3 name: Geologycourse 3 grade: 90course 3 total units:...arrow_forwardCreate the following program in java: Write a java program that lets a meteorologist record day and evening temperature for a certain number of days. The temperatures must be stored in a two-dimensional array. Your program should: · Ask the meteorologist the number of days he/she wants to record temperatures for. · Read the temperatures. · Report the number of days where both the day and evening temperature are below average. · The number of days where the difference between the day and evening temperature is less than 10. · The highest and lowest day and evening temperature.arrow_forward
- This is need in Java Declare an array named temperatures that can hold 10 doubles.arrow_forwardModule main() // Local variables Constant Integer SIZE = 18 Declare Integer numbers[SIZE] = 5658845, 4520125, 7895122, 8777541, 8451277, 1302850, 8080152, 4562555, 5552012, 5050552, 7825877, 1250255, 1005231, 6545231, 3852085, 7576651, 7881200, 4581002 Declare Integer inputNumber, found = 0 // Get number Display "Enter number to validate: " Input inputNumber // Validate number For index = 0 to SIZE – 1 If inputNumber == numbers[index] Then Set found = 1 Set index = SIZE End If End For // Show if valid If found == 1 Then Display "Number is valid." Else Display "Number is not valid." End If End Module Flowchart pleasearrow_forwardThe Java language definition demands that all references to array elements be checked to ensure that the index or indices are in their legal ranges, is an example of VS ____. (one word answers) Blank # 1 Blank # 2 A A/arrow_forward
- Java Programming language Please help me with this. Thanks in advance.arrow_forwarda. Describe Conditional Statements in Visual Basic.Net. Create a software that accepts array items and performs array sorting and reversal.arrow_forwardYou can use any C# compiler or the method you already know. The following table contains quarterly sales figures for five (5) departments: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Department 1 750 660 910 800 Department 2 800 700 950 900 Department 3 700 600 750 600 Department 4 850 800 1000 950 Department 5 900 800 960 980 Total Design and write a Windows program/module named SalesAnalysis that will: Declare a two-dimensional integer array named sales – (Note: you have 6 rows and 5 columns) - that will hold the 4 quarterly sales for 5 departments Populate the first four columns for the 5 departments using the data in the preceding table. Contain a loop to compute and populate the total column. Store each department’s total in the array as it is being computed. Contain a loop to compute and populate the total row. Store each quarter’s total in the array as it is being computed....arrow_forward
- Java CLIarrow_forwardJava program to check whether there is zero (0) value or -1 , if its there then display true otherwise false. Consider the output as follow:arrow_forwardCreate an application that simulates a game of Tic Tac Toe in C# using a two-dimensional array. At the end of the game make sure to declare who the winner is by reading the array.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education