Question:
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 database program | relational database management system software | rdbms lab programs | rdbms lab programs pdf | dbms programs | database management software | database management system software | examples of database software| list of database applications | database system applications | examples of database | application database application software | database management application
rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program
ConversionConversion EmoticonEmoticon