本次課程設(shè)計(jì)(論文)任務(wù)及主要內(nèi)容和要求(包括原始數(shù)據(jù)、技術(shù)參數(shù)、-在線(xiàn)瀏覽
2025-03-07 15:51本頁(yè)面
【正文】 0 供貨商地址ProvidePhone Varchar 25 供貨商電話(huà)廠(chǎng)商表(Provide)字段名 字段類(lèi)型 長(zhǎng)度 主/外鍵 字段值約束 對(duì)應(yīng)中文名FactoryID varchar 10 P Not null 廠(chǎng)商編號(hào)FactoryName Varchar 50 Not null 廠(chǎng)商名稱(chēng)FactoryAddress Varchar 250 廠(chǎng)商地址FactoryPhone Varchar 25 廠(chǎng)商電話(huà)物理設(shè)計(jì)文檔/*創(chuàng)建數(shù)據(jù)庫(kù)*/create database SuperMarketdbon primary(name=SuperMarketdb,filename=39。,size=100MB,maxsize=200MB,filegrowth=20MB)log on(name=SuperMarketlog,filename=39。,size=60MB,maxsize=200MB,filegrowth=20MB)go/*創(chuàng)建基本表*/use [SuperMarketdb]go/*創(chuàng)建交易表*/CREATE TABLE Dealing ( DealingID int identity(1,1) Primary key , DealingDate datetime NOT NULL , DealingPrice money NOT NULL , UserName varchar(25) NULL , MemberCard varchar(20) NULL) GO/*創(chuàng)建廠(chǎng)商表*/CREATE TABLE Factory ( FactoryID varchar(10) Primary key , FactoryName varchar(50) NOT NULL , FactoryAddress varchar(250) NULL , FactoryPhone varchar(50) NULL )GO/*創(chuàng)建會(huì)員表*/CREATE TABLE Member ( MemberID varchar(10) Primary key , MemberCard varchar(20) NOT NULL , TotalCost money NOT NULL , RegDate datetime NOT NULL )GO/*創(chuàng)建商品信息表*/CREATE TABLE MerchInfo ( MerchID int identity(1,1) Primary key , MerchName varchar(50) Unique NOT NULL , MerchPrice money NOT NULL , MerchNum int NOT NULL , CautionNum int NOT NULL , PlanNum int NOT NULL , BarCode varchar(20) Unique NOT NULL , SalesProPrice money NULL , SalesProDateS datetime NULL , SalesProDateE datetime NULL , AllowAbate int NOT NULL , AllowSale int NOT NULL , FactoryID int NOT NULL , ProvideID int NOT NULL) GO/*創(chuàng)建供應(yīng)商表*/CREATE TABLE Provide ( ProvideID varchar(10) Primary key , ProvideName varchar(50) NOT NULL , ProvideAddress varchar(250) NULL , ProvidePhone varchar(25) NULL )GO/*創(chuàng)建銷(xiāo)售表*/CREATE TABLE Sale ( SaleID int identity(1,1) Primary key , MerChID int NOT NULL , SaleDate datetime NOT NULL , SaleNum int NOT NULL, SalePrice money NOT NULL) GO/*創(chuàng)建入庫(kù)表*/CREATE TABLE Stock ( StockID int identity(1,1) Primary key , MerchID int NOT NULL , MerchNum int NOT NULL , MerchPrice money NULL , TotalPrice money NULL , PlanDate datetime NULL , StockDate datetime NULL, StockState int NOT NULL) GO/*創(chuàng)建用戶(hù)表*/CREATE TABLE User ( UserID varchar(10) Primary key , UserN
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1