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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!