最新機(jī)票預(yù)訂系統(tǒng)課程設(shè)計(jì)-文庫(kù)吧資料
2025-07-05 03:12本頁(yè)面
【正文】 use MARKETgoalter table Booking_Ticketadd constraint fk_storeI foreign key(Passenger_Number) references Passenger(Passenger_Number)use MARKETgoalter table Refundadd constraint fk_storI foreign key(Passenger_Number) references Passenger(Passenger_Number)use MARKETgoalter table Refundadd constraint fk_sorI foreign key(Booking_Number) references Booking_Ticket(Booking_Number)use MARKETgoalter table Booking_Ticketadd constraint fk_sosI foreign key(Ticket_Number) references Ticket(Ticket_Number)use MARKETgoalter table Relationadd constraint fk_sowsI foreign key(Ticket_Number) references Ticket(Ticket_Number)use MARKETgoalter table Relationadd constraint fk_saI foreign key(Passenger_Number) references Passenger(Passenger_Number)use MARKETgoalter table Booking_Ticketadd constraint fk_saiI foreign key(Ticket_Number) references Ticket(Ticket_Number)設(shè)置約束條件：use MARKETgoalter table Passengeradd check (Sex in(39。USE MARKETCREATE TABLE Relation/關(guān)系的創(chuàng)建/(Number varchar(50) primary key ,/設(shè)置主鍵/Ticket_Number varchar(50) not null,Passenger_Number varchar(50) not null,)。USE MARKETCREATE TABLE Seat/座位信息表的創(chuàng)建/(Seat_Number varchar(50) primary key,/設(shè)置主鍵/Seat_Type varchar(50) not null,Ticket_Number varchar(50) not null,Destination varchar(50) not null)。USE MARKETCREATE TABLE Flight/航班信息表的創(chuàng)建/(Flight_Number varchar(50) primary key,/設(shè)置主鍵/akeoff_Time varchar(50) not null,ArTrival_Time varchar(50) not null,Flight_Time varchar(50) not null,Origin varchar(50) not null,Destination varchar(50) not null,Flight_Type varchar(50) not null)。E:\數(shù)據(jù)庫(kù)課程設(shè)計(jì)\39。ticket39。E:\數(shù)據(jù)庫(kù)課程設(shè)計(jì)\39。ticket_db39。 where Flight_Number=A01SELECT * FROM Flight Where Flight_Number=A0 更改功能圖55視圖就是創(chuàng)建一個(gè)可以實(shí)現(xiàn)添加創(chuàng)建的續(xù)表，從而實(shí)現(xiàn)效果。 刪除功能圖54通過更改功能我們可以對(duì)其信息修改，比如機(jī)票座位類型，目的地等做相應(yīng)的修改USE MARKET SELECT * FROM Flight WHERE Flight_Number=A01 Update FlightSET Destination=39。USE MARKET DELETE FROM Booking_Ticket WHERE Booking_Number=39。)。,39。,39。,39。,39。USE MARKET INSERT INTO Passenger VALUES(39。小青39。女39。USE MARKET SELECT * FROM Seat 查詢功能圖51 使用多條件查詢功能可以增加查詢的限制條件，這樣可以使查詢的結(jié)果更準(zhǔn)確。主鍵：藍(lán)色外鍵：下劃線表21 訂單信息的數(shù)據(jù)字典字段名描述數(shù)據(jù)類型長(zhǎng)度是否允許為空Booking_Number訂單的編號(hào)VARCHAR50否Flight_Number航班編號(hào)VARCHAR20否Seat_Number座位編號(hào)VARCHAR50否Passenger_Number旅客編號(hào)VARCHAR50否Ticket_Number機(jī)票的編號(hào)VARCHAR50否Price金額VARCHAR50否表22 航班信息的數(shù)據(jù)字典字段名描述數(shù)據(jù)類型長(zhǎng)度是否允許為空FlightNumber航班編號(hào)VARCHAR50否Takeoff_Time起飛時(shí)間VARCHAR50否Arrtival_Time到達(dá)時(shí)間VARCHAR50否Origin出發(fā)地VARCHAR50否Destination目的地VARCHAR50否Flight_Type航班型號(hào)VARCHAR50否表23 機(jī)票信息的數(shù)據(jù)字典字段名描述數(shù)據(jù)類型長(zhǎng)度是否允許為空Ticket_Number機(jī)票編號(hào)VARCHAR）50否Seat_Number座位號(hào)VARCHAR50否Price價(jià)格VARCHAR50否Takeoff_Time出發(fā)時(shí)間
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1