【正文】 K_SEX VARCHAR(50) NOT NULL,性別BirthOfDate DATE NOT NULL,出生日期CLERK_TELEPHONE VARCHAR(50) NOT NULL,電話CONSTRAINT FK_Clerk_COMPANY_NUMBER FOREIGN KEY(COMPANY_NUMBER)references CAMPANY(CAMPANY_NUMBER),)。男39。女39。ALTER TABLE BUY_TICKETSADDCONSTRAINT CK_REAL_PAY CHECK(REAL_PAY=0)ALTER TABLE BUY_TICKETSADDCONSTRAINT CK_BUY_TICKETS_LEN CHECK(LEN(PASSAGER_ID)=18)CREATE TABLE REFUND退票表(REFUND_TIME VARCHAR(50),退票時間PASSAGER_ID VARCHAR(50),旅客身份證號TICKET_ID INT IDENTITY(1,1) NOT NULL,機票編號CONSTRAINT PK_退旅客機票 PRIMARY KEY(PASSAGER_ID,TICKET_ID),CONSTRAINT FK_REFUND_PASSAGER_ID FOREIGN KEY(PASSAGER_ID) references PASSAGER(PASSAGER_ID),CONSTRAINT FK_REFUND_TICKET_ID FOREIGN KEY(TICKET_ID) references TICKET(TICKET_ID),)。ALTER TABLE SELL_TICKETSADDCONSTRAINT CK_TICKET_SUM CHECK(TICKET_SUM=0)INSERT INTO PASSAGERVALUES(39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。) INSERT INTO CAMPANYVALUES(39。,39。,39。,39。) INSERT INTO TICKETVALUES(39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。)INSERT INTO FIGHTVALUES(39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。) INSERT INTO CrewVALUES(39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。)INSERT INTO ClerkVALUES(39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。)INSERT INTO BUY_TICKETSVALUES(39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。), (39。,39。,39。,39。,39。,39。,39。)SELECT * FROM BUY_TICKETSuse 航空機票預(yù)售系統(tǒng)INSERT INTO REFUND(REFUND_TIME,PASSAGER_ID)VALUES(39。,39。)INSERT INTO SELL_TICKETS(SELL_TIME,TICKET_SUM,EmployeeNumber)VALUES(39。,39。,39。), (39。,39。,39。), (39。,39。,39。), (39。,39。,39。), (39。,39。,39。), (39。,39。,39。), (39。,39。,39。)、規(guī)則、索引、事物的建立USE 航空機票預(yù)售系統(tǒng)GOCREATE VIEW VIEW_TICKETAS SELECT FIGHT_NUMBER,TICKET_ID,SEAT_NUMBERFROM TICKETGO①創(chuàng)建規(guī)則USE 航空機票預(yù)售系統(tǒng)GOCREATE RULE RULE_SEAT_NUMBER1ASSEAT_NUMBER0 AND SEAT_NUMBER11②綁定規(guī)則use 航空機票預(yù)售系統(tǒng)GOEXEC sp_bindrule39。,39。③驗證規(guī)則 ①創(chuàng)建索引create unique index fight_number on fight (fight_number,seat_count) 索引②刪除索引drop index USE 航空機票預(yù)售系統(tǒng)事物GOBEGIN TRANSACTIONINSERT INTO CAMPANY VALUES(39。,39。,39。,39。)。只能有一個公司，插入失敗?。。?9。插入成功！！39。,分組查詢統(tǒng)計每個公司的業(yè)務(wù)員人數(shù)，要求顯示公司號，公司名，業(yè)務(wù)員員工人數(shù)USE 航空機票預(yù)售系統(tǒng)SELECT CAMPANY_NUMBER,COMPANY_NAME,COUNT(EmployeeNumber)FROM CAMPANY INNER JOIN Clerkon =group by CAMPANY_NUMBER,COMPANY_NAME。航班39。已售39。安陵容39。15040319941020000639。李宇宸39。15020119951006000739。1596496549639。女39。木子李39。1234567890139。15020119951006000739。Booking success! Wele to use the next!39。USE 航空機票預(yù)售系統(tǒng)GOEXEC PR_TICKE第六章心得經(jīng)過兩周的努力，本次課程設(shè)計終于完成。在本次課程設(shè)計和過程中，由于時間不是很長，再加上要求獨立完成，系統(tǒng)功能可能不是很全面，程序中還存在很多缺陷，希望老師能給予批評和指導(dǎo)。希望能在今后的不斷的學(xué)習(xí)中和努力中，把程序做得更好。參考文獻《數(shù)據(jù)庫系統(tǒng)教程》（第三版）,施伯樂，丁寶康，汪衛(wèi)編著，高等教育出版社，2008年。28