Processing arrays, Database Management System

1. A company wants a report containing a breakdown of payroll by department. Input, which should be stored in 3 parallel arrays, includes each employee's department number, hourly salary, and number of hours worked. The output is a list of the seven departments in the company (NOT the department number), the total gross payroll (rate times hours) for each department, and the total gross payroll for the company. Departments are listed in the table below.   

Dept. Number

Dept. Name

1

Personnel

2

Marketing

3

Manufacturing

4

Computer Services

5

Sales

6

Accounting

7

Shipping

2. An instructor has 25 students. Each student is identified by a number from 1 to 35. All tests are stored in a two-dimensional array, with each column containing the grades for each test. The instructor would like to enter the student number and the test number and have the grade for that test printed. Develop pseudocode to output the needed information. (Hint: you may want to draw a picture or use a spreadsheet to get an idea of how the data is laid out).

 

Posted Date: 3/12/2013 3:36:24 AM | Location : United States







Related Discussions:- Processing arrays, Assignment Help, Ask Question on Processing arrays, Get Answer, Expert's Help, Processing arrays Discussions

Write discussion on Processing arrays
Your posts are moderated
Related Questions
Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

external and internal mapping with examples

Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

Define the Traditional System Analysis and Design Traditional System Analysis and Design (SAD) have three basic life cycle models. A typical software lifecycle consists of the

Create an index for the table Client, field CLIENT_NO of Q ? Command:   CREATE INDEX client_client_no ON client(client_no);

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric