某企业的数据库系统中有如下所示的员工关系和仓库关系,每个仓库可有多名员工,但只有一名负责人。
则创建仓库表结构的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));