电脑销售数据库设计
实体之间的联系: 采购表:
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),