Director of the audio shop (coursework)

Option C

PKI for the job of the store director. The PKI should work with data on goods sold, producers of goods, goods in stock, contracts for the supply of goods, the sale of goods, the maintenance of calculations and invoices for the purchased goods, the maintenance of settlements of the sold goods.

Data on manufacturers of goods: name, address, director, chief accountant, manufactured goods, bank details.
Data on the supply contract: contract number, date of conclusion, short text, goods (name, price, quantity), delivery conditions, supplier, amount.
Account data: account number, contract number, date of sale, amount, VAT, payment mark, receipt mark.
Product data: name, characteristics, price per unit, packaging, shipment, note, etc.

Requests required:

Nomenclature, quantity of goods sold;
Nomenclature, quantity and value of goods in the warehouse;
- Suppliers of goods by type of goods;
- on concluded contracts for the supply of goods;
- Payment of bills and amounts of payment;
- Sales for the period (day, decade, month) (nomenclature, quantity, value)
- On deliveries for the period (day, decade, month) (nomenclature, quantity, cost).
-
Reports:
Documented standard requests.