數(shù)據(jù)庫系統(tǒng)應(yīng)用大作業(yè)課程設(shè)計報告-商品管理系統(tǒng)數(shù)據(jù)庫設(shè)計(編輯修改稿)
2024-09-05 16:08 本頁面
【文章內(nèi)容簡介】 183011劉心20081183012武藝20081183013譚杰希20081183014李剛表311 交易表:TradeTimeGoodsIDGoodsNameClerkIDSalePriceMemberID0001百事可樂001200811830100002美年達002200811830010010青島啤酒003200811830040010青島啤酒004200811830040001百事可樂005200811830040002美年達006000000000000011雪花啤酒007000000000000004康師傅麻辣排骨面008200811830070005北京方便面009200811830080006伊利盒裝純牛奶010200811830090007蒙牛盒裝純牛奶011000000000000008王中王火腿腸012200811830110009漢堡火腿013200811830120010青島啤酒014200811830130011雪花啤酒015000000000000012心相印卷紙010200811830010013樂百氏礦泉水011200811830020014農(nóng)夫山泉011200811830020011雪花啤酒002000000000000001百事可樂00320081183009 物理設(shè)計 創(chuàng)建數(shù)據(jù)庫create database goodson(name=stu,filename=39。D:\SQL\39。,size=3MB,maxsize=500MB,filegrowth=10%)log on(name=stu_log,filename=39。D:\SQL\39。,size=3MB,maxsize=500MB,filegrowth=10%)Go 創(chuàng)建基本表use goodsgocreate table goods( GoodsID char(4) Primary key, GoodsName varchar(50) NOT NULL, GoodsPrice float NOT NULL, MemberPrice float NOT NULL, GoodsDate char(10) NOT NULL, GoodsLast varchar(10) NOT NULL, ProviderName varchar(20) NOT NULL)Gocreate table salesclerk( ClerkID char(3) Primary key, ClerkName varchar(8) NOT NULL, ClerkSex char(2) NOT NULL, ClerkAge char(2) NOT NULL)gocreate table job( ClerkID char(3) Primary key, ClerkName varchar(8) NOT NULL, WorkTime varchar(11) NOT NULL, ClerkPay int NOT NULL)gocreate table member( MemberID char(11) Primary key, MemberName varchar(8) NOT NULL, RegDate Datetime NOT NULL)gocreate table trade( TradeTime varchar(15) NOT NULL, goodsID char(4) NOT NULL, goodsName varchar(50) NOT NULL, ClerkID char(3) NOT NULL, SalePrice money NOT NULL, MemberID char(11) NOT NULL )goinsert into goodsselect * from OPENROWSET(39。39。 ,39。Excel 。IMEX=1。HDR=YES。DATABASE=C:\Documents and Settings\Administrator\桌面\39。 ,[Sheet1$])圖32 商品信息insert into salesclerkselect * from OPENROWSET(39。39。 ,39。Excel 。IMEX=1。HDR=YES。DATABASE=C:\Documents and Settings\Administrator\桌面\39。 ,[Sheet1$])圖33 售貨員信息insert into jobselect * from OPENROWSET(39。39。 ,39。Excel 。IMEX=1。HDR=YES。DATABASE=C:\Documents and Settings\Administrator\桌面\39。 ,[Sheet1$])圖34 工作信息insert into memberselect * from OPENROWSET(39。39。 ,39。Excel 。IMEX=1。HDR=YES。DATABASE=C:\Documents and Settings\Administrator\桌面\39。 ,[Sheet1$])圖35 會員信息insert into tradeselect * from OPENROWSET(39。39。 ,39。Excel 。IMEX=1。HDR=YES。DATABASE=C:\Documents and Settings\Administrator\桌面\39。 ,[Sheet1$])圖36 交易信息 插入記錄語句use goodsgoi
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1