[경영,경제] 항공사 관리 시스템 - 항공사 예약 관리

_ID CHAR(20) UNIQUE,
PASSWORD INT NOT NULL,
CUSTOMER_NAME CHAR(20),
CUSTOMER_SEX CHAR(10),
CUSTOMER_PHONE_NUMBER DECIMAL NOT NULL,
CUSTOMER_NUMBER DECIMAL NOT NULL,
CUSTOMER_ADDRESS CHAR(100),
PRIMARY KEY(CUSTOMER_ID)
);
환불
CREATE TABLE REFUND(
CUSTOMER_ID CHAR(20),
REFUND_NUMBER DECIMAL NOT NULL,
REFUND_BANK CHAR(20),
REFUND_REASON CHAR(200),
PRIMARY KEY(REFUND_NUMBER),
FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMER(CUSTOMER_ID),
);
6-2. 테이블 생성
항공사
CREATE TABLE AIRDEPARTMENT(
AIRPLANE_ID CHAR(30),
AIR_COMPANY CHAR(10),
KINDOF_AIRPLANE CHAR(10),
AIRPLANE_SEAT INT NOT NULL,
FLYING_POSSIBLE CHAR(10),
PRIMARY KEY(AIRPLANE_ID)
);
6-3. 테이블 생성
공항
CREATE TABLE AIRPORT(

AIRPORT_NO INT NOT NULL,
AIRNAME CHAR(25),
PRIMARY KEY(AIRPORT_NO)
);
6-4. 테이블 생성
비행정보
CREATE TABLE FLIGHT(
FLIGHT_NO CHAR(30) NOT NULL,
AIRPORT_NO INT NOT NULL,
DEPARTURE_D INT ,
FLIGHT_DISTANCE INT NOT NULL,
FLIGHT_TIME CHAR(10),
FLIGHT_DESTINATION CHAR(20) U

보관중인 자료가 없습니다