數(shù)據(jù)庫課程方案(自己做)-文庫吧
2025-04-25 07:09 本頁面
【正文】 項含義類型長度說明類型編號Tno物品的類型的編號char5主鍵類型名稱Tname物品的類型的名稱char20類型描述Tdescription物品的類型的描述char50：Manager數(shù)據(jù)項名對應(yīng)英文名數(shù)據(jù)項含義類型長度說明管理員編號Mno管理員的編號char5主鍵管理員姓名Mname管理員的姓名char20密碼PW該管理員的密碼Char6: Stock數(shù)據(jù)項名對應(yīng)英文名數(shù)據(jù)項含義類型長度說明物品編號Gno貨物表中物品編號Char5外鍵、主鍵倉庫編號Sno倉庫的編號Char5外鍵物品名稱Gname貨物的名稱Char10類型名稱Tname貨物的分類Char20物品數(shù)量Gnum貨物的存儲量Int入庫合計）出庫合計）:Stock_In數(shù)據(jù)項名對應(yīng)英文名數(shù)據(jù)項含義類型長度說明物品編號Gno貨物表中物品編號Char5外鍵、主鍵供應(yīng)商編號Pno供應(yīng)商的編號Char5外鍵、主鍵物品名稱Gname貨物的名稱Char10類型名稱Tname貨物的分類Char20購入單價Ginprice貨物購入的價格Real入庫數(shù)量Innum入庫的數(shù)量Int采購金額Inprice本次采購的金額Real購入單價*入庫數(shù)量入庫日期Indate入庫的時間Char20:Stock_Out數(shù)據(jù)項名對應(yīng)英文名數(shù)據(jù)項含義類型長度說明物品編號Gno貨物表中物品編號Char5外鍵、主鍵客戶編號Cno客戶的編號Char5外鍵、主鍵物品名稱Gname貨物的名稱Char10類型名稱Tname貨物的分類Char4出售單價Goutprice貨物出售的價格Real出庫數(shù)量Outnum出庫的數(shù)量Int出庫金額Outprice本次出庫的金額Real出庫數(shù)量*出售單價出庫日期Outdate出庫的時間Char20五、系統(tǒng)開發(fā)1. 數(shù)據(jù)庫建立Create database storage_manage。供應(yīng)商 Providercreate table Provider(Pno char(5 primary key,Pname char(20,Padddr char(40,Postcode char(6,Ptel char(11。客戶 Clientcreate table Client(Cno char(5 primary key,Cname char(20,Caddr char(40,Ctel char(11。貨物類型 Typecreate table Type(Tno char(5 primary key,Tname char(20,Tdescription char(50。貨物 Goodscreate table Goods(Gno char(5 primary key,Gname char(20,Tno char(5,foreign key(Tno references Type(Tno。管理員 Managercreate table Manager(Mno char(5 primary key,Mname char(20,PW char(6。倉庫 Storagecreate table Storage(Sno char(5 primary key,Sname char(20,Saddr char(40,Mno char(5,Ssize int,foreign key(Mno references Manager(Mno。庫存 Stockcreate table Stock(Gno char(5,Sno char(5,Gname char(10,Tname char(20,Gnum int,primary key(Gno,foreign key(Gno references Goods(Gno,foreign key(Sno references Storage(Sno。入庫Stock_Increate table Stock_In(Gno char(5,Pno char(5,Gname char(10,Tname char(20,Ginprice real,Innum int,Inprice real,Indata char(20,primary key(Gno,Pno,foreign key(Gno references Goods(Gno,foreign key(Pno references Provider(Pno。出庫Stock_Outcreate table Stock_Out(Gno char(5,Cno char(5,Gname char(10,Tname char(20,Goutprice real,Outnum int,Outprice real,Outdata char(20,primary key(Gno,Cno,foreign key(Gno references Goods(Gno,foreign key(Cno references Client(Cno。界面設(shè)計Form1//include pragma hdrstopinclude include //
公司管理相關(guān)推薦
鄂ICP備17016276號-1