Ready database of access «Internet shop»
Description of the subject area
You are an employee of the commercial department of the company selling various products through the Internet. Your task is to track the financial component of the company´s work. The work of your company is organized as follows: some products are on the company´s website (for sale). Each of them has some name, price and unit of measurement (pieces, kilograms, liters). To conduct research and optimize the work of the store, you are trying to collect data from your customers. At the same time for you, the standard personal data, as well as the telephone number and e-mail address for communication, are of decisive importance. In the case of the purchase of goods worth more than 5000 rub. the customer goes to the category of "regular customers" and receives a discount for each purchase of 2%. For each sale fact you automatically fix the customer, the goods, the quantity, the date of sale, the date of delivery.
Goods (Item Code, Name, Price, Unit of Measurement).
Clients (customer code, last name, first name, patronymic, address, telephone, email, permanent customer).
Sales (Sales code, Product code, Customer code, Date of sale, Delivery date, Quantity).
The development of the formulation of the problem
As a result of the operation of the database, it was found out that sometimes there are problems associated with a lack of information about the availability of the necessary goods in the warehouse in the right amount. In addition, usually customers in the same order buy not one type of product, but several types. Based on the total cost of the order, the company provides additional discounts. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.