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
Given the following relations TRAIN (NAME, START, DEST) TICKET (PNRNO., START, DEST, FARE) PASSENGER (NAME, ADDRESS, PNRNO.) Write SQL expressions for the following queries: No

explain exhausitively the problems associated with er diagrams with ellustrations

Data Replication "If a relation R has its copies kept at two or more sites, then it is considered replicated". But why do we replicate a relation? There are several advan

Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

A student entity type has the following attributes,name..

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A