SQL DATABASE Make tables to compile the database for confectionery workshop This is what database include:...

Transcribed Image Text:

SQL DATABASE Make tables to compile the database for confectionery workshop This is what database include: 1. To make a statement of the articles that are intended for diabetics. 2. To bring out the sales of all type X sweets 3. To display information about the manufactured products during the day X. 4. To be able to find an item in the database by entering part of its name. 5. To display all one-time sales of more than 10 pieces for a given product in the database. Make a 15% discount. 6. By assigning the name of a confectioner to the base to display the names of all products made by him. 7. Find the average for the products from each group (cakes, pickles, etc.) 8. To calculate the number of offered products workshop in groups. 9. To compile requests for modification and deletion of data from the tables in the database. 10. To draw up a statement with all articles except articles X, Y and Z. 11. Create a stored procedure returning as a result the name of the confectioner and the name of the manufactured product. Give an example of performing the stored procedure. SQL DATABASE Make tables to compile the database for confectionery workshop This is what database include: 1. To make a statement of the articles that are intended for diabetics. 2. To bring out the sales of all type X sweets 3. To display information about the manufactured products during the day X. 4. To be able to find an item in the database by entering part of its name. 5. To display all one-time sales of more than 10 pieces for a given product in the database. Make a 15% discount. 6. By assigning the name of a confectioner to the base to display the names of all products made by him. 7. Find the average for the products from each group (cakes, pickles, etc.) 8. To calculate the number of offered products workshop in groups. 9. To compile requests for modification and deletion of data from the tables in the database. 10. To draw up a statement with all articles except articles X, Y and Z. 11. Create a stored procedure returning as a result the name of the confectioner and the name of the manufactured product. Give an example of performing the stored procedure.

Answer rating: 100% (QA)

1 To make a statement of the articles that are intended for diabetics Answer To make a statement of the articles that are intended for diabetics a database table should be created with the following c... View the full answer