最新機(jī)票預(yù)訂系統(tǒng)課程設(shè)計(編輯修改稿)
2025-07-26 03:12 本頁面
【文章內(nèi)容簡介】 信息。USE MARKET INSERT INTO Passenger VALUES(39。0000139。,39。大衛(wèi)39。,39。123456639。,39。男39。,39。1824725678939。)。 添加功能圖53可以實現(xiàn)對一些變更的信息刪除，從而能夠達(dá)到一定的效果。USE MARKET DELETE FROM Booking_Ticket WHERE Booking_Number=39。B0000139。 刪除功能圖54通過更改功能我們可以對其信息修改，比如機(jī)票座位類型，目的地等做相應(yīng)的修改USE MARKET SELECT * FROM Flight WHERE Flight_Number=A01 Update FlightSET Destination=39。呼和浩特39。 where Flight_Number=A01SELECT * FROM Flight Where Flight_Number=A0 更改功能圖55視圖就是創(chuàng)建一個可以實現(xiàn)添加創(chuàng)建的續(xù)表，從而實現(xiàn)效果。 視圖56 第六章 源代碼建庫：create database [MARKET] on primary(name = 39。ticket_db39。,filename = 39。E:\數(shù)據(jù)庫課程設(shè)計\39。,size = 5mb,maxsize = 30mb,filegrowth = 5%)log on(name = 39。ticket39。,filename = 39。E:\數(shù)據(jù)庫課程設(shè)計\39。,size = 1mb,maxsize = 10mb,filegrowth = 10%)建表：CREATE TABLE Booking_Ticket/訂單信息表的創(chuàng)建/(Booking_Number varchar(50) primary key,/設(shè)置主鍵/Flight_Number varchar(50) not null,Seat_Number varchar(50) not null,Passenger_Number varchar(50) not null,Amount varchar(50) not null,Price varchar(50) not null,Time 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)。USE MARKETCREATE TABLE Passenger/旅客信息表的創(chuàng)建/(Passenger_Number varchar(50) primary key,/設(shè)置主鍵/Passenger_Name varchar(50) not null,ID_Number varchar(50) not null,Sex varchar(50) not null,Telephone 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 Ticket(Ticket_Number varchar(50) primary key,/設(shè)置主鍵/Destination varchar(50) not null,Price varchar(50) not null,Takeoff_Time varchar(50) not nullSeat_Number varchar(50) not null)。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 Refund/退票信息表的創(chuàng)建/(Order_Number varchar(50) primary key,/設(shè)置主鍵/Passenger_Number varchar(50) not null,Booking_Number varchar(50) not null,)。設(shè)置外鍵：use MARKETgoalter table Booking_Ticketadd constraint fk_storeDI foreign key(Seat_Number) references Seat(Seat_Number)use MARKETgoalter table Booking_Ticketadd constraint fk_storeADI foreign key(Flight_Number) references Flight(Flight_Number)use MARKETgoalter table Booking_Ticketadd constraint fk_storeI foreign key(Passenger_Number) references Pas
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1