Question: SQL DATABASE Make tables to compile the database for confectionery workshop This is what database include: 1. To make a statement of the articles

SQL DATABASE Make tables to compile the database for confectionery workshop This

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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 full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!