(Solved) : Create Table Employee Fname Varchar2 15 Null Minit Char Lname Varchar2 15 Null Ssn Char 9 Q27335969 . . . .

CREATE TABLE EMPLOYEE (

FNAME         VARCHAR2(15)NOT NULL,

MINIT         CHAR,

LNAME         VARCHAR2(15)NOT NULL,

SSN          CHAR(9)        NOT NULL,

BDATE         DATE,

ADDRESS       VARCHAR2(30),

SEX          CHAR(1),

SALARY        NUMBER(10,2),

SUPER_SSN     CHAR(9),

DNO          NUMBER         NOT NULL,

CONSTRAINT EMPPK PRIMARY KEY (SSN) DISABLE,

CONSTRAINT EMPSUPERFK FOREIGN KEY (SUPER_SSN) REFERENCESEMPLOYEE(SSN) DISABLE);

CREATE TABLE DEPARTMENT (

DNAME         VARCHAR2(15)NOT NULL,

DNUMBER       NUMBER        NOT NULL,

MGR_SSN       CHAR(9)       NOT NULL,

MGR_START_DATE       DATE,

CONSTRAINT DEPTPK PRIMARY KEY (DNUMBER) DISABLE,

CONSTRAINT DEPTMGRFK FOREIGN KEY (MGR_SSN) REFERENCESEMPLOYEE(SSN) DISABLE);

INSERT INTO Employee (Fname, Minit, Lname, Ssn, Bdate, Address,Sex, Salary, Super_ssn, Dno)

VALUES (‘Jonn’, ‘B’, ‘Smith’, 123456789, ‘1965-02-09’, ‘731Fondren, Houston, TX’, M, 30000, 333445555, 5)

INSERT INTO Employee (Fname, Minit, Lname, Ssn, Bdate, Address,Sex, Salary, Super_ssn, Dno)

VALUES