Ready database access «Accounting of office expenses»
Accounting for office expenses
Description of the subject area
You work in the accounting of a private company. Employees of the company have the opportunity to make small purchases for the needs of the firm, providing a check to the accounts department. Your task is to track internal office expenses. Your company consists of departments. Each department has a name. Each department has a certain number of employees. Employees can make purchases in accordance with the types of expenses. Each type of expenditure has a name, a description and the maximum amount of funds that can be spent on this type of expenditure per month. With each purchase, the employee draws up a document indicating the type of expense, date, amount and department.
Departments (Department code, Name, Number of employees).
Types of costs (Type code, Name, Description, Limit rate).
Expenses (Expense code, View code, Department code, Amount, Date).
The development of the formulation of the problem
Now the situation has changed. It turned out that you need to store data on expenses, not only in the whole for the department, but also for individual employees. The standards for spending money are set not in general, but for each department for each month. Unused money this month can be used later. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)plati.market