超市數(shù)據(jù)庫系統(tǒng)(參考版)
2025-05-19 08:11本頁面
【正文】 000439。王楠39。)。,39。,39。插入倉庫：INSERTINTO StowageVALUES(39。查詢商品所在的倉庫：SELECT GoodsName,StowagePrincipalFROM Goods,Stowage,StowageGoodsWHERE = AND =。商品名商品價格查詢：SELECT GoodsName,PriceFROM Goods,GoodsCustomerWHERE = AND GoodsAmont=39。各表之間的關(guān)系：、數(shù)據(jù)載入 注：在數(shù)據(jù)庫中已輸入、設(shè)計視圖顧客視圖：CREATE VIEW 顧客ASSELECT , , , , , FROM INNER JOIN ON = INNER JOIN ON = INNER JOIN ON = , , , , , , FROM INNER JOIN ON = INNER JOIN ON = INNER JOIN ON = 員工視圖：CREATE VIEW 員工ASSELECT TOP 100 PERCENT , , , , , FROM INNER JOIN ON = ORDER BY 倉庫主管視圖：CREATE VIEW 倉庫主管ASSELECT TOP 100 PERCENT , , , , , FROM INNER JOIN ON = ORDER BY 部門主管視圖：CREATE VIEW 部門主管ASSELECT TOP 100 PERCENT , , , , , , , , FROM INNER JOIN ON = INNER JOIN ON = ORDER BY , , 、建立索引 數(shù)據(jù)庫運(yùn)行會員查詢：SELECT SerialNumberFROM CustomerWHERE IsMember=39。員工：CREATE TABLE Employment( EmployeeNumber CHAR(6) NOT NULL UNIQUE, EmployName VARCHAR(8) NOT NULL, PostNumber CHAR(6), Birth DATETIME, Tel NUMERIC(10,0) NOT NULL, DepartmentNumber CHAR(6), IDcard NUMERIC(18,0) NOT NULL, BankNumber NUMERIC(20,0), Seniority INT NOT NULL, PRIMARY KEY(EmployeeNumber), CONSTRAINT C6 FOREIGN KEY(PostNumber) REFERENCES Post(PostNumber), CONSTRAINT C7 FOREIGN KEY(DepartmentNumber) REFERENCES Department(DepartmentNumber))。職位：CREATE TABLE Post( PostNumber CHAR(6) NOT NULL UNIQUE, PostName VARCHAR(8) NOT NULL, Wage MONEY NOT NULL, PRIMARY KEY(PostNumber))。顧客：CREATE TABLE Customer( SerialNumber VARCHAR(20) NOT NULL UNIQUE, IsMember CHAR(5) NOT NULL, Payment VARCHAR(20) NOT NULL, PurchaseTime DATETIME
公司管理相關(guān)推薦
鄂ICP備17016276號-1