Database, Sql, Data Science, Data Analysis, Data Visualization.
transaction is entered with a product_id that does not exist in products table, database raises an error. -- Here, products table is created with primary key CREATE TABLE products ( product_id INTEGER PRIMARY KEY, product_name VARCHAR(50) ); -- Then orders table is created with product_id as a