Table Creation and Data Manipulation Commands — Question 24

CREATE TABLE Employee (
    EmpID NUMBER(6) PRIMARY KEY,
    EmpName VARCHAR(20) NOT NULL,
    EmpAddress VARCHAR(30),
    EmpPhone VARCHAR(10),
    EmpSal NUMBER(9, 2),
    DeptID VARCHAR(2),
    FOREIGN KEY (DeptID) REFERENCES Department (Dept_ID)
    ON DELETE CASCADE ON UPDATE CASCADE
);