Design the logic for an application for a company that wants

Design the logic for an application for a company that wants a report containing a breakdown of payroll by department. Input includes each employee’s last name, first name, department number, hourly salary, and number of hours worked. The output is a list of the seven departments (name of department and corresponding department number) in the company (numbered 1 through 7) and the total gross payroll (rate times hours) for each department. Department Number Department Name 1 Personnel 2 Marketing 3 Manufacturing 4 Computer Services 5 Sales 6 Accounting 7 Shipping

Solution

the beginning based totally upon relational algebra and tuple relational calculus, sq. consists of a statistics definition language, data manipulation language, and information control Language. The scope of sq. consists of data insert, query, update and delete, schema advent and modification, and information get entry to control. despite the fact that sq. is regularly defined as, and to a incredible extent is, a declarative language (4GL), it is usually procedural factors.