【正文】 *******************/CREATE DATABASE FactoryManageON PRIMARYmdf文件(NAME=FactoryManage_data,FILENAME=39。,數(shù)據(jù)庫存儲地址SIZE=50MB,MAXSIZE=70MB,FILEGROWTH=1MB)LOG ONldf文件(NAME=FactoryManage_log,FILENAME=39。,數(shù)據(jù)庫日志存儲地址SIZE=10MB,MAXSIZE=15MB,FILEGROWTH=1MB)/***********************************************************************************/USE FactoryManage/**********************************************************************************//*********************主題：工廠表主鍵：工廠編號屬性：工廠編號、工廠名稱、廠長編號**********************/CREATE TABLE Factory(FactoryID NCHAR(8) PRIMARY KEY,工廠編號,主鍵FactoryName NCHAR(50) NOT NULL,工廠名稱,非空FactoryDirectorID NCHAR(8) UNIQUE NOT NULL廠長編號，唯一，非空)/*testINSERT INTO Factory VALUES(39。,39。,39。)SELECT *FROM FactoryDELETE FactoryDROP TABLE Factory*//*********************主題：廠長表主鍵：廠長編號屬性：廠長編號、姓名、年齡、性別、工資*********************/CREATE TABLE FactoryDirector(FactoryDirectorID NCHAR(8) PRIMARY KEY,廠長編號，主鍵FactoryDirectorName NCHAR(20) NOT NULL,廠長姓名，非空FactoryDirectorAge NCHAR(3),廠長年齡FactoryDirectorSex NCHAR(4) CHECK (FactoryDirectorSex IN(39。,39。)),性別，非空，檢測錯誤FactoryDirectorSalary MONEY DEFAULT(0),廠長工資，默認(rèn)為0FOREIGN KEY (FactoryDirectorID) REFERENCES Factory(FactoryDirectorID),建立關(guān)系，外鍵引用)/*testINSERT INTO FactoryDirector VALUES(39。,39。,39。,39。,15000)SELECT *FROM FactoryDirectorDELETE FactoryDirectorDROP TABLE FactoryDirector*//*************************主題：主任表主鍵：主任編號屬性：主任編號、姓名、年齡、性別、工資**************************/CREATE TABLE Master(MasterID NCHAR(8) PRIMARY KEY,主任編號，主鍵MasterPosition NCHAR(50) NOT NULL,主任職位，非空MasterName NCHAR(20) NOT NULL,主任姓名，非空MasterAge NCHAR(3),主任年齡MasterSex NCHAR(4) CHECK (MasterSex IN(39。,39。)),性別，檢測MasterSalary MONEY DEFAULT (0),主任工資，默認(rèn)0)/*testINSERT INTO Master VALUES(39。,39。,39。,39。,39。,10000)INSERT INTO Master VALUES(39。,39。,39。,39。,39。,10000)SELECT *FROM MasterDELETE MasterDROP TABLE Master*//*********************主題：車間表主鍵：車間編號屬性：車間編號、車間主任編號、車間地址、車間電話、工廠編號**********************/CREATE TABLE Workshop(WorkshopID NCHAR(8) PRIMARY KEY,車間編號,主鍵WorkshopMasterID NCHAR(8) NOT NULL,車間主任編號，非空WorkshopAdd NCHAR(50) NOT NULL,車間地址，非空WorkshopTel NCHAR(20) NOT NULL,車間電話，非空FactoryID NCHAR(8) NOT NULL,工廠編號，外鍵FOREIGN KEY (FactoryID) REFERENCES Factory(FactoryID),建立關(guān)系，外鍵引用FOREIGN KEY (WorkshopMasterID)REFERENCES Master(MasterID),建立關(guān)系，外鍵引用)/*testINSERT INTO Workshop VALUES(39。,39。,39。,39。,39。)SELECT *FROM WorkshopDELETE WorkshopDROP TABLE Workshop*//*********************主題：工人表主鍵：職工號屬性：職工號、姓名、性別、工種、工資、工作車間編號**********************/CREATE TABLE Worker(WorkerID NCHAR(8) PRIMARY KEY,職工號,主鍵WorkerName NCHAR(20) NOT NULL,姓名，非空WorkerSex NCHAR(4) NOT NULL CHECK (WorkerSex IN(39。,39。)),性別，非空，檢測錯誤WorkerType NCHAR(50) NOT NULL,工種，非空WorkerSalary MONEY DEFAULT(0),工資，默認(rèn)為0WorkshopID NCHAR(8) NOT NULL,工作車間編號，非空FOREIGN KEY (WorkshopID) REFERENCES Workshop(WorkshopID)建立關(guān)系，外鍵引用)/*testINSERT INTO Worker VALUES(39。,39。,39。,39。,3000,39。)INSERT INTO Worker VALUES(39。,39。,39。,39。,2500,39。)INSERT INTO Worker VALUES(39。,39。,39。,39。,3000,39。)SELECT *FROM WorkerDELETE WorkerDROP TABLE Worker*//*********************主題：產(chǎn)品表主鍵：產(chǎn)品號屬性：產(chǎn)品號、產(chǎn)品名稱、產(chǎn)品價格**********************/CREATE TABLE Product(ProductID NCHAR(8) PRIMARY KEY,產(chǎn)品號,主鍵ProductName NCHAR(50) NOT NULL,產(chǎn)品名稱，非空ProductPrice MONEY NOT NULL,產(chǎn)品價格，非空)/*testINSERT INTO Product VALUES(39。,39。,)INSERT INTO Product VALUES(39。,39。,)SELECT *FROM ProductDELETE ProductDROP TABLE Product*//*********************=====================================================車間產(chǎn)品中間表主題：車間產(chǎn)品表主鍵：車間號、產(chǎn)品號屬性：車間號、產(chǎn)品號**********************/CREATE TABLE WorkshopProduct(WorkshopID NCHAR(8) NOT NULL,車間號，非空ProductID NCHAR(8) NOT NU