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
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

please i request for your assistance in developing a case-based online phone repair

external and internal mapping with examples

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f