文档介绍::..构成产品编号cha「⑼零件号ch頭9)制成■零件号char(9)编号char(9)1产品产品编号宀3?面__名称 varchar(40)价格 numeric(2)生产日期datetime零件零件号cha「⑼规格 ch曲40)名称char(40)1存储零件号char⑼char(9)1仓库仓库号cha「(9V电话char(12)主任名char(3)材料编号ch引⑼价格numeric(3)材料名ch刃(40)订单号char(9)存放编号材料库号char⑼char⑻材料库材料库号chs「⑻负责人ch8«3)*//*DBMSname:*//*Createdon:2012-10-17 15:16*/*/*//*Table:PRODUCTS*/createtablePRODUCTSPNUMPNAMEPRICEDATEchar(9)varchar(40)numeric(2)datetimenotnull,notnull,null,nullconstraintPK_PRODUCTSprimarykey(PNUM))*//*Table:PART*/*/createtablePARTPNUMSTANDARPNAMchar(9)char(40)char(40)notnull,nullnotnull,constraintPK_PARTprimarykey(PNUM))go*//*Databasename:MODEL1/*Table:MATERIALS*/createtableMATERIALSMNUMchar(9)notnull,MPRICEnumeric(3)null ,MNAMEchar(40)notnull,MORDERchar(9)(MNUM)go/*Table:STORAGE*/*/*/*/createtableSTORAGESNUMPHONENUMSPRINC1PALnotnull,nullnullchar(9)char(12)char(3)constraintPK_STORAGEprimarykey(SNUM))go/*============================================================*//*Table:MSTORAGE *//*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/createtableMSTORAGE(MSTORNUMchar(8) notnull,MPRINCIPALchar(3) null,constraintPK_MSTORAGEprimarykey(MSTORNUM))go二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*//*Table:FORM *//*————————————————————————————————————————————————————————————*/createtableFORM(PNUM char(