Computer Science

Create table Employee as per following Table Instance Chart.

Column NameEmpIDEmpNameEmpAddressEmpPhoneEmpSalDeptID
Key TypePrimary    Foreign
Nulls/Unique NOT NULL    
Fk Table     Department
Fk Column     Dept_ID
DatatypeNUMBERVARCHARVARCHARVARCHARNUMBERVARCHAR
Length62030109, 22

DDL & DML

9 Likes

Answer

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
);

Answered By

7 Likes


Related Questions