In an electronics store, to manage the inventory of electronic products. The system maintains a table named "Products" containing information about various electronic devices, including their ProductID, ProductName, and Price.To handle dynamic pricing updates, you are tasked with creating a stored procedure named 'UpdateProductPrice'. This procedure takes two parameters: p_ProductID (the ID of the product to be updated) and p_NewPrice (the new price to be set for the product).The following table is already created, and the records are inserted into the table.TABLE: Products ProductID INT PRIMARY KEY, ProductName VARCHAR(50), Price DECIMAL(10, 2).Prepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The stored procedure updates the price of the specified product in the "Products" table.The output should display the updated product details as shown below.

In an online electronics store, a database system is used to manage product information. The database contains a table named "Products" that stores details about various electronic products, such as laptops, smartphones, coffee makers, and desk chairs.The store administrators want to add a new product, a "Bluetooth Speaker," to the database. To achieve this,your job is to create a stored procedure named 'AddProduct' needs to be created. The procedure should take three parameters: p_ProductName (the name of the new product), p_Category (the category of the product), and p_Price (the price of the product).The following table is already created, and the records are inserted into the table.TABLE: Products ProductID INT PRIMARY KEY AUTO_INCREMENT, ProductName VARCHAR(50) NOT NULL, Category VARCHAR(50), Price DECIMAL(10, 2) NOT NULLHAR(50), score INTPrepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The stored procedure, 'AddProduct,' inserts a new record into the "Products" table with the provided information.The output should display the updated product details as shown below.

Create a table named "products" with columns "product_id" (int), "product_name" (varchar), "description" (varchar), "unit_price" (decimal), and "available_stock" (int). Additionally, the table should have constraints such that "product_id" acts as the primary key and "product_name" is unique.The table structure is given below:

Create Table SALE(        SaleID integer,        SaleDate date,        Tax decimal,        Total decimal);Create Table ITEM(        ItemID integer,        Name char(30),        Cost decimal,        Price decimal);Create Table SALE_ITEM(        SaleID integer,        SaleItemID integer);Considering the SQL create statements; assume that SALE, SALE_ITEM and ITEM tables were created without Primary Keys and Foreign Keys.  Which of the following SQL statements gives an error?Question 12Select one:a.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM;b.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM (SaleID);c.Alter Table SALE Add Primary Key (SaleID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table ITEM Add Primary Key (ItemID);Alter Table SALE Add Foreign Key (SaleID) References SALE_ITEM;d.Alter Table ITEM Add Primary Key (ItemID);Alter Table SALE_ITEM Add Primary Key (SaleID, SaleItemID);Alter Table SALE_ITEM Add Unique (SaleID);Alter Table ITEM Add Foreign Key (ItemID) References SALE_ITEM;

Problem StatementCreate a table named "products" with columns "product_id" (int), "product_name" (varchar), "description" (varchar), "unit_price" (decimal), and "available_stock" (int). Additionally, the table should have constraints such that "product_id" acts as the primary key and "product_name" is unique.The table structure is given below:Input format :No console input.Output format :The output should display a detailed description of the created 'products' table.Refer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Problem StatementWrite a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table. Note: All records are prepopulated.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The result of the query will be the seller ID(s) who achieved the highest total sales based on the cumulative sum of prices for all their sales as shown below.seller_id13