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
What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

Extend your CREATE TABLE statement from problem 3 with referential integrity constraints. Updates and deletes on related rows are restricted. 6. From examination of the sample data

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin

What is inheritance? Define it in detail?  Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one