Question: Construct the following company database 2. tables assign properties for fields as required 3. use insert command to fill tables with data as in the


Construct the following company database 2. tables assign properties for fields as required 3. use insert command to fill tables with data as in the following pictures One possible database state for the CoMRANY relational database schema IM 4000000066555 5 T Wong 333445555 1055-120e 63 Vos Houston To 5975 Fire Oai, Humble, TX M CREATE TABLE EMPLOYEE NOT NULL. 15) Minit NOT NULL, 15) NOT NULL CHAR(9) DATE, ARCHAR(30), CHAR, DECIMAL 10,2), Super-ssn CHAR09), NOT NULL. PRIMARY KEY (Ssn), FOREIGN KEY (Super ssn) REFERENCES EM PLOYEESsn), FOREIGN KEY (Dino) REFERENCES DEPARTMENT (Dmumber) CREATE TABLE DEPARTMENT NOT NULL 5) NOT NULL Dnumber Mgr ssn CHAR(9) NOT NULL. Mgr start date DATE, PRIMARY KEY (Dnumber), UNiaUE (Dinamo), FOREIGN KEY (Mgr ssn) REFERENCES EMPLOYEESsn) WORKS ON
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
