Question: Create the SQL code for the table below Hint: Multiple ways exist to do things in SQL two ways to define foreign keys: one is

Create the SQL code for the table below
Hint: Multiple ways exist to do things in SQL two ways to define
foreign keys: one is to define foreign key within the CREATE
TABLE statement, for example:
CREATE TABLE products
(product_id numeric(10) not null, supplier_id numeric(10),
CONSTRAINT fk_supplier FOREIGN KEY (supplier_id)
REFERENCES supplier(supplier_id) ON DELETE SET NULL)
Another way is to create table without defining foreign key and add
foreign key later using the ALTER TABLE statement (sometimes you
might have to do like this), for example:
ALTER TABLE Products ADD CONSTRAINT fk_supplier
FOREIGN KEY (supplier_id) REFERENCES supplier(supplier_id)
ON DELETE SET NULL
 Create the SQL code for the table below Hint: Multiple ways

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!