Project translated automatically. Log in or register, to view the original The work is performed using the MySQL or MariaDB server and the HeldiSQL client.Variant 5 The supplier makes a contract for the delivery of goods with the customers.At the same time, it provides the following benefits: when ordering from 50 t to 100 t, the cost decreases by 10%, from 100 t to 200 t - by 15%, above 200 t - by 17%.Create a database that must carry out the registration of goods orders, and also solve the following tasks: 1. provide information about such requests of the customer, such as his legal name and address, phone and name of the manager, bank account; 2. provide information about the name of the goods, their manufacturer, the standard of use per hectare, storage period; 3. reflect all orders with all their requests (the fields of order), ordering them by the name of the customer, the name of the goods and their manufacturer; 4. find a certain date (the satisfactory date that you determine yourself) all orders; 5. find a certain date (the satisfactory date that you determine yourself) of all the customer, the fact of which they have been ordered, the rate of use per hectare, the time of storage; 3. reflect all orders with all their specific requests (the fields of order), ordering them by ordering them, the maximum of goods and their manufacturer;

Proposals 2