Product (code-product, Name-product, price);
Stock (code-product, code-Dep, quantity);
Depot (code -id, address);
1.Create sql tables out of the schemas
2. List the code and price of all the products
3. List the names of all the product
4. List the product whose price is > 100
5. List the name of product starting with letter and whose price is unknown
1.
CREATE TABLE Product (
code_product INT PRIMARY KEY,
Name_product VARCHAR(50),
price DECIMAL(10,2)
);
CREATE TABLE Stock (
code_product INT,
code_Dep INT,
quantity INT,
PRIMARY KEY (code_product, code_Dep),
FOREIGN KEY (code_product) REFERENCES Product(code_product)
);
CREATE TABLE Depot (
code_id INT PRIMARY KEY,
address VARCHAR(100)
);
2.
SELECT code_product, price
FROM Product;
3.
SELECT Name_product
FROM Product;
4.
SELECT *
FROM Product
WHERE price > 100;
5.
SELECT Name_product
FROM Product
WHERE Name_product LIKE 'letter%'
AND price IS NULL;