sql工廠數(shù)據(jù)庫(kù)系統(tǒng)課程設(shè)計(jì)說(shuō)明書和代碼-資料下載頁(yè)
2025-05-23 18:08本頁(yè)面
【正文】 duct VALUES(39。W139。,39。Pr239。)SELECT *FROM WorkshopProductDELETE WorkshopProductDROP TABLE WorkshopProduct*//*********************主題：零件表主鍵：零件號(hào)屬性：零件號(hào)、重量、零件價(jià)格、零件生產(chǎn)車間**********************/CREATE TABLE Part(PartID NCHAR(8) PRIMARY KEY,零件號(hào),主鍵PartWeight NCHAR(10) NOT NULL,重量，非空PartPrice MONEY NOT NULL,零件價(jià)格，非空)/*testINSERT INTO Part VALUES(39。Pa139。,39。昭陽(yáng)E43L主板39。,)INSERT INTO Part VALUES(39。Pa239。,39。昭陽(yáng)E43L鍵盤39。,)INSERT INTO Part VALUES(39。Pa339。,39。聯(lián)想V800手機(jī)39。,)SELECT *FROM PartDELETE PartDROP TABLE Part*//*********************=====================================================車間零件中間表主題：車間零件表主鍵：車間號(hào)、零件號(hào)屬性：車間號(hào)、零件號(hào)**********************/CREATE TABLE WorkshopPart(WorkshopID NCHAR(8) NOT NULL,車間號(hào)PartID NCHAR(8) NOT NULL,零件號(hào)PRIMARY KEY(WorkshopID,PartID),主鍵，車間號(hào)、零件號(hào)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)品號(hào)、零件號(hào)屬性：產(chǎn)品號(hào)、零件號(hào)**********************/CREATE TABLE ProductPart(ProductID NCHAR(8) NOT NULL,產(chǎn)品號(hào),非空PartID NCHAR(8) NOT NULL,零件號(hào)，非空PRIMARY KEY(ProductID,PartID),產(chǎn)品號(hào)、零件號(hào)設(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*//*********************主題：倉(cāng)庫(kù)表主鍵：倉(cāng)庫(kù)號(hào)屬性：倉(cāng)庫(kù)號(hào)、倉(cāng)庫(kù)主任編號(hào)、倉(cāng)庫(kù)電話、從屬工廠**********************/CREATE TABLE Warehouse(WarehouseID NCHAR(8) PRIMARY KEY,倉(cāng)庫(kù)號(hào)，主鍵WarehouseMasterID NCHAR(8) NOT NULL,倉(cāng)庫(kù)主任編號(hào)，非空WarehouseTel NCHAR(20) NOT NULL,倉(cāng)庫(kù)電話，非空FactoryID NCHAR(8) NOT NULL,從屬工廠編號(hào)，外鍵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*//*********************=======================================================倉(cāng)庫(kù)產(chǎn)品中間表主題：倉(cāng)庫(kù)產(chǎn)品表主鍵：倉(cāng)庫(kù)號(hào)、產(chǎn)品號(hào)屬性：倉(cāng)庫(kù)號(hào)、產(chǎn)品號(hào)、產(chǎn)品庫(kù)存量**********************/CREATE TABLE WarehouseProduct(WarehouseID NCHAR(8) NOT NULL,倉(cāng)庫(kù)號(hào)，非空ProductID NCHAR(8) NOT NULL,產(chǎn)品號(hào)非空Quantity INT DEFAULT (0),產(chǎn)品庫(kù)存量PRIMARY KEY(WarehouseID,ProductID),主鍵，倉(cāng)庫(kù)號(hào)、產(chǎn)品號(hào)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*//*********************=======================================================倉(cāng)庫(kù)零件中間表主題：倉(cāng)庫(kù)零件表主鍵：倉(cāng)庫(kù)號(hào)、零件號(hào)屬性：倉(cāng)庫(kù)號(hào)、零件號(hào)、零件庫(kù)存量**********************/CREATE TABLE WarehousePart(WarehouseID NCHAR(8) NOT NULL,倉(cāng)庫(kù)號(hào)，非空PartID NCHAR(8) NOT NULL,零件號(hào)，非空Quantity INT DEFAULT (0),零件庫(kù)存量PRIMARY KEY (WarehouseID,PartID),主鍵，倉(cāng)庫(kù)號(hào)、零件號(hào)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*/寧可累死在路上，也不能閑死在家里！寧可去碰壁，也不能面壁。是狼就要練好牙，是羊就要練好腿。什么是奮斗？奮斗就是每天很難，可一年一年卻越來(lái)越容易。不奮斗就是每天都很容易，可一年一年越來(lái)越難。能干的人，不在情緒上計(jì)較，只在做事上認(rèn)真；無(wú)能的人！不在做事上認(rèn)真，只在情緒上計(jì)較。拼一個(gè)春夏秋冬！贏一個(gè)無(wú)悔人生！早安！—————獻(xiàn)給所有努力的人. 學(xué)習(xí)好幫
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1