1CREATE TABLE supplier
2( supplier_id numeric(10) not null,
3 supplier_name varchar2(50) not null,
4 contact_name varchar2(50),
5 CONSTRAINT supplier_pk PRIMARY KEY (supplier_id)
6);
7
8CREATE TABLE products
9( product_id numeric(10) not null,
10 supplier_id numeric(10) not null,
11 CONSTRAINT fk_supplier
12 FOREIGN KEY (supplier_id)
13 REFERENCES supplier(supplier_id)
14);