數(shù)據(jù)庫實(shí)驗(yàn)報(bào)告-賓館信息管理系統(tǒng)項(xiàng)目研究報(bào)告-資料下載頁
2025-01-18 22:33本頁面
【正文】 ERM DATE, CCALL CHAR(11))。CREATE TABLE EQUIPMENT(EID CHAR(3) PRIMARY KEY, ENAME CHAR(20))。CREATE TABLE EAR(RID CHAR(3), EID CHAR(3), PRIMARY KEY(RID, EID), FOREIGN (RID) REFERENCES ROOM(RID), FOREIGN (EID) REFERENCES EQUIPMENT(EID))。CREATE TABLE MANAGEMENT(MID CHAR(3) PRIMARY KEY, MNAME CHAR(20), MSEX CHAR(1), MSALARY INT, MEMTERM DATE, MCALL CHAR(11))。CREATE TABLE BILL(BID CHAR(10) PRIMARY KEY, BDATE DATE, BITEM CHAR(20), BSUM ITN)。CREATE TABLE BILLBELONG(BID CHAR(10), GID CHAR(20), PRIMARY KEY(BID, GID), FOREIGN KEY (BID) REFERENCES BILL(BID), FOREIGN KEY (GID) REFERENCES GUEST(GID))。CREATE TABLE ORDERR(OID CHAR(10) PRIMARY KEY, CID CHAR(3), GID CHAR(20), RID CHAR(3), ODATE DATE, FOREIGN CID REFERENCES CLERK(CID), FOREIGN (GID) REFERENCES GUEST(GID), FOREIGN (RID) REFERENCES ROOM(RID))。CREATE TABLE ADMINISTRATE(MID CHAR(3), RID CHAR(3), PRIMARY KEY(MID, RID), FOREIGN (MID) REFERENCES MANAGEMENT(MID), FOREIGN (RID) REFERENCES ROOM(RID))。2. 查詢 （1）查詢姓名為“YI”的客人信息：SELECT *FROM GUESTWHERE GNAME=”ABC” （2）查詢具有空調(diào)的房間的房間號SELECT DISTINCT FROM ROOM, ERA, EQUIPMENTWHERE = AND = AND ENAME=空調(diào)（3）查詢年月日的賬單SELECT *FROM BILLWHERE =年月日附：小組成員自評分?jǐn)?shù)表：班級姓名學(xué)號分工內(nèi)部打分計(jì)算機(jī)三班許靜靜130104010070系統(tǒng)概念設(shè)計(jì)97計(jì)算機(jī)三班孫佳藝130104010071PPT講解與制作98計(jì)算機(jī)三班房甜甜130104010072系統(tǒng)概念設(shè)計(jì)97計(jì)算機(jī)三班黃旭敏130104010073搜查資料96計(jì)算機(jī)三班郭秋君130104010074系統(tǒng)邏輯設(shè)計(jì)97計(jì)算機(jī)三班張福生130104010075系統(tǒng)邏輯設(shè)計(jì)99計(jì)算機(jī)三班董賀130104010076實(shí)驗(yàn)報(bào)告98
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1