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.

COLUMN NAME DATATYPE SIZE CONSTRAINT
dept_id number 4 Primary key
prod_id number 4 Foreign key
dept_name varchar2 25 Unique
dept_head varchar2 25 Not null

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

Leave a Comment

Scroll to Top