SQL untuk dbzoo
0 Responses
Berikut ini merupakan sintax SQL untuk membuat database dbzoo. CREATE DATABASE dbzoo; CREATE TABLE TheEmployees ( Ename varchar(20) NOT NULL, address varchar(25) default NULL, PRIMARY KEY (Ename)); CREATE TABLE TheSupervisors ( pathNum smallint(6) NOT NULL, Ename varchar(20) default NULL, PRIMARY KEY (pathNum), FOREIGN KEY (Ename) REFERENCES TheEmployees(Ename)); CREATE TABLE TheCages ( cNum smallint(6) NOT... [ Continue reading... ]