Task for creating a database Bakery
Let it be required to create a software system designed for the grain mill. Such a system should ensure the storage of information about manufactured products and their sales, as well as the purchase of products necessary for production. Information about the products includes: product name, weight, energy value, production volume, production date, shelf life, brief description (notes), composition, selling price. Each ingredient stored in a combine´s warehouse is characterized by its name, quantity, delivery date, expiration date, energy value, unit price.
The management of the plant may need the following information:
How much is left in the warehouse in accordance with the costs of production?
What is the total cost of the products in the product?
What is the total energy value taking into account all constituent products?
What is the total profit from sales?
It is necessary to provide for the possibility of issuing a document presenting a report on the balances of products in the warehouse, a report on sales by months, a report on purchases by years.
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.)