make 2 different -stored procedure- query and explain.
USE supermarkett;
CREATE TABLE product(
product_id INT NOT NULL,
product_name VARCHAR(45) NOT NULL,
price FLOAT NOT NULL,
prod_discount INT NOT NULL,
product_type VARCHAR(45) NOT NULL,
PRIMARY KEY (product_id)
);
CREATE TABLE stock (
stock_id INT NOT NULL,
product_id INT NOT NULL,
quantity INT NOT NULL,
product_status BOOLEAN NOT NULL,
PRIMARY KEY (stock_id),
FOREIGN KEY (product_id) REFERENCES product(product_id)
);
CREATE TABLE employee (
emp_id INT NOT NULL,
emp_name VARCHAR(45) NOT NULL,
emp_number INT NOT NULL,
address VARCHAR(45) NOT NULL,
PRIMARY KEY (emp_id)
);
CREATE TABLE supplier (
sup_id INT NOT NULL,
sup_name VARCHAR(45) NOT NULL,
sup_number INT NOT NULL,
address VARCHAR(45) NOT NULL,
PRIMARY KEY (sup_id)
);
CREATE TABLE login (
login_id INT NOT NULL,
password VARCHAR(45) NOT NULL,
PRIMARY KEY (login_id)
);
ALTER TABLE stock
ADD FOREIGN KEY (product_id) REFERENCES product(product_id);
-------------------------------------------------------------------------------
make 2 different -stored procedure- query and explain.
Step by step
Solved in 2 steps
