电脑销售数据库设计
实体之间的联系: 采购表:
CREATE TABLE Buy (bID CHAR(6), gID CHAR(6), shopperID CHAR(6), bQUA CHAR(10), bTIME dateTIME,
PRIMARY KEY(bID,gID,shopperID)
FOREIGN KEY (gID) REFERENCES goods(gID),
FOREIGN KEY (shopperID) REFERENCES shopper(shopperID) ) 进货表:
CREATE TABLE Stock (stockID CHAR(6), sID CHAR(6), shID CHAR(6), stockQUA CHAR(10), stockTIME DATETIME,
PRIMARY KEY(stockID,sID,shID)
FOREIGN KEY (sID) REFERENCES store(sID), FOREIGN KEY (shID) REFERENCES shop(shID) ) 销售表:
CREATE TABLE Sell (sellID CHAR(6),
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说教育文库数据库课程设计之电脑销售信息管理系统(17)在线全文阅读。
相关推荐: