assignment

CREATE TABLE Customers(
customer_id INT PRIMARY KEY,
name VARCHAR(100),
address VARCHAR(200)
);

CREATE TABLE Products(
product_id INT PRIMARY KEY,
product_name VARCHAR(100),
price DECIMAL(5,2) CHECK(price>0)
);

CREATE TABLE Orders(
order_id INT PRIMARY KEY,
customer_id INT FOREIGN KEY REFERENCES Customers(customer_id),
product_id INT FOREIGN KEY REFERENCES Products(product_id),
quantity INT,
order_date DATE

);