【正文】 duct VALUES(39。W139。,39。Pr239。)SELECT *FROM WorkshopProductDELETE WorkshopProductDROP TABLE WorkshopProduct*//*********************主題：零件表主鍵：零件號屬性：零件號、重量、零件價格、零件生產(chǎn)車間**********************/CREATE TABLE Part(PartID NCHAR(8) PRIMARY KEY,零件號,主鍵PartWeight NCHAR(10) NOT NULL,重量，非空PartPrice MONEY NOT NULL,零件價格，非空)/*testINSERT INTO Part VALUES(39。Pa139。,39。昭陽E43L主板39。,)INSERT INTO Part VALUES(39。Pa239。,39。昭陽E43L鍵盤39。,)INSERT INTO Part VALUES(39。Pa339。,39。聯(lián)想V800手機39。,)SELECT *FROM PartDELETE PartDROP TABLE Part*//*********************=====================================================車間零件中間表主題：車間零件表主鍵：車間號、零件號屬性：車間號、零件號**********************/CREATE TABLE WorkshopPart(WorkshopID NCHAR(8) NOT NULL,車間號PartID NCHAR(8) NOT NULL,零件號PRIMARY KEY(WorkshopID,PartID),主鍵，車間號、零件號FOREIGN KEY (WorkshopID) REFERENCES Workshop(WorkshopID),建立關(guān)系，外鍵引用FOREIGN KEY (PartID) REFERENCES Part(PartID)建立關(guān)系，外鍵引用)/*testINSERT INTO WorkshopPart VALUES(39。W139。,39。Pa139。)INSERT INTO WorkshopPart VALUES(39。W139。,39。Pa239。)INSERT INTO WorkshopPart VALUES(39。W139。,39。Pa339。)SELECT *FROM WorkshopPartDELETE WorkshopPartDROP TABLE WorkshopPart*//*********************=========================================================產(chǎn)品零件中間表主題：產(chǎn)品零件表主鍵：產(chǎn)品號、零件號屬性：產(chǎn)品號、零件號**********************/CREATE TABLE ProductPart(ProductID NCHAR(8) NOT NULL,產(chǎn)品號,非空PartID NCHAR(8) NOT NULL,零件號，非空PRIMARY KEY(ProductID,PartID),產(chǎn)品號、零件號設(shè)置為主鍵FOREIGN KEY(ProductID) REFERENCES Product(ProductID),建立關(guān)系，外鍵引用FOREIGN KEY(PartID) REFERENCES Part(PartID)建立關(guān)系，外鍵引用)/*testINSERT INTO ProductPart VALUES(39。Pr139。,39。Pa139。)INSERT INTO ProductPart VALUES(39。Pr139。,39。Pa239。)SELECT *FROM ProductPartDELETE ProductPartDROP TABLE ProductPart*//*********************主題：倉庫表主鍵：倉庫號屬性：倉庫號、倉庫主任編號、倉庫電話、從屬工廠**********************/CREATE TABLE Warehouse(WarehouseID NCHAR(8) PRIMARY KEY,倉庫號，主鍵WarehouseMasterID NCHAR(8) NOT NULL,倉庫主任編號，非空WarehouseTel NCHAR(20) NOT NULL,倉庫電話，非空FactoryID NCHAR(8) NOT NULL,從屬工廠編號，外鍵FOREIGN KEY (WarehouseMasterID) REFERENCES Master(MasterID),建立關(guān)系，外鍵引用FOREIGN KEY (FactoryID) REFERENCES Factory(FactoryID),建立關(guān)系，外鍵引用)/*testINSERT INTO Warehouse VALUES(39。Wh139。,39。Whm139。,39。010125678939。,39。F139。)SELECT *FROM WarehouseDELETE WarehouseDROP TABLE Warehouse*//*********************=======================================================倉庫產(chǎn)品中間表主題：倉庫產(chǎn)品表主鍵：倉庫號、產(chǎn)品號屬性：倉庫號、產(chǎn)品號、產(chǎn)品庫存量**********************/CREATE TABLE WarehouseProduct(WarehouseID NCHAR(8) NOT NULL,倉庫號，非空ProductID NCHAR(8) NOT NULL,產(chǎn)品號非空Quantity INT DEFAULT (0),產(chǎn)品庫存量PRIMARY KEY(WarehouseID,ProductID),主鍵，倉庫號、產(chǎn)品號FOREIGN KEY(WarehouseID) REFERENCES Warehouse(WarehouseID),建立關(guān)系，外鍵引用FOREIGN KEY(ProductID) REFERENCES Product(ProductID),建立關(guān)系，外鍵引用)/*testINSERT INTO WarehouseProduct VALUES(39。Wh139。,39。Pr139。,5)INSERT INTO WarehouseProduct VALUES(39。Wh139。,39。Pr239。,5)SELECT *FROM WarehouseProductDELETE WarehouseProductDROP TABLE WarehouseProduct*//*********************=======================================================倉庫零件中間表主題：倉庫零件表主鍵：倉庫號、零件號屬性：倉庫號、零件號、零件庫存量**********************/CREATE TABLE WarehousePart(WarehouseID NCHAR(8) NOT NULL,倉庫號，非空PartID NCHAR(8) NOT NULL,零件號，非空Quantity INT DEFAULT (0),零件庫存量PRIMARY KEY (WarehouseID,PartID),主鍵，倉庫號、零件號FOREIGN KEY(WarehouseID) REFERENCES Warehouse(WarehouseID),建立關(guān)系，外鍵引用FOREIGN KEY(PartID) REFERENCES Part(PartID),建立關(guān)系，外鍵引用)/*testINSERT INTO WarehousePart VALUES(39。Wh139。,39。Pa139。,200)INSERT INTO WarehousePart VALUES(39。Wh139。,39。Pa239。,168)SELECT *FROM WarehousePartDELETE WarehousePartDROP TABLE WarehousePart*/寧可累死在路上，也不能閑死在家里！寧可去碰壁，也不能面壁。是狼就要練好牙，是羊就要練好腿。什么是奮斗？奮斗就是每天很難，可一年一年卻越來越容易。不奮斗就是每天都很容易，可一年一年越來越難。能干的人，不在情緒上計較，只在做事上認真；無能的人！不在做事上認真，只在情緒上計較。拼一個春夏秋冬！贏一個無悔人生！早安！—————獻給所有努力的人. 學(xué)習(xí)好幫