某企業(yè)的數(shù)據(jù)庫系統(tǒng)中有如下所示的員工關(guān)系和倉庫關(guān)系,每個倉庫可有多名員工,但只有一名負(fù)責(zé)人。
則創(chuàng)建倉庫表結(jié)構(gòu)的SQL語句為()。
A.CREATE TABLE(employeeID CHAR(2)NOTNULL UNIQUE, name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3));
B.CREATE warehouse(warehouseID CHAR(2)PRIMARY KEY, name CHAR(30), address CHAR(40), pricipalID CHAR(3));
C.CREATE TABLE warehouse(warehouseID CHAR(2)PRIMARY KEY, name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), FOREIGN KEY(pricipalID)REFERENCES employee(employeeID));
D.CREATE TABLE warehouse(warehouseID CHAR(2), name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), PRIMARY REY(warehouseID), FOREIGN KEY(employeeID)REFERENCES employee(employeeID));