Formulation of the problem.
You work for a wholesale and retail company. Your task is to monitor the financial side of the company.
The activities of your company are organized as follows: Your company sells goods from a certain range. Each of these products is characterized by a name, wholesale price, retail price and reference information. Customers contact your company. For each of them, you memorize standard data in the database (name, address, phone number, contact person) and draw up a document for each transaction, remembering, along with the buyer, the quantity of goods purchased by him and the date of purchase.
Object classes:
– Goods (name, wholesale price, retail price, description);
– Buyers (telephone, contact person, address);
– Transactions (transaction date, product, quantity, buyer, sign of wholesale).
I enclose the text of the term paper on 24 sheets.
I post some screenshots of the database.
Development environment: Microsoft Office Access.
No feedback yet