Test Your Understanding 2 in SQL

Question:

Test Your Understanding 2

Modify the given query appropriately in order to create the department table using the schema given below, considering the product table that you have already created.

CODE:–

CREATE table department
 ( dept_id number(4),
  prod_id number(4),
  dept_name varchar2(25) unique,
  dept_head varchar2(25) NOT NULL,
  PRIMARY KEY(dept_id),
  foreign KEY(prod_id) REFERENCES product(prod_id)
); 

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program