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 is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def

Describe in brief about the Sequence Diagrams Sequence diagrams are interaction diagrams which emphasize time ordering of messages. In UML, it is shown as a table which shows

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Entities Let us first be aware of the question: What are entities? An entity is an object of concern used to show the things in the actual world, e.g., table, car, bo

Nested Queries Let us see some more complex queries in this section. Sub-queries: Some of the basic concerns of sub-queries are: A sub-query is a SELECT statemen

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl

differences between a classified catalog and a dictionary catalog