Scribd
Upload
11 views2 pages

Airline Database Schema Overview

The document outlines a database schema for an airline management system, detailing various entities such as aircraft, flights, tickets, invoices, employees, and customers. Each entity includes attributes such as IDs, names, dates, and monetary values, with relationships indicated by cardinalities. Key constraints and primary keys are also specified for data integrity.

Uploaded by

trinhdangxk
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views2 pages

Airline Database Schema Overview

The document outlines a database schema for an airline management system, detailing various entities such as aircraft, flights, tickets, invoices, employees, and customers. Each entity includes attributes such as IDs, names, dates, and monetary values, with relationships indicated by cardinalities. Key constraints and primary keys are also specified for data integrity.

Uploaded by

trinhdangxk
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

LoaiMayBay MayBay ChuyenBay Ve ChiTietHoaDon

0..1 0..1 0..1 0..1 *


MaLoai char(10) MaMB char(10) MaCB char(10) MaVe char(10) MaHD char(10)
*
HangSX nvarchar(50) SoGhe int NgayBay date GiaTien money MaVe char(10)

TinhTrang nvarchar(50) GioCatCanh time SoLuongCon int primary key(MaHD,MaVe)


*
MaLoai char(10) GioHaCanh time HangVe char(10)
NhanVien
*
0..1 SBDi varchar(50) MaCB char(10)
MaNV char(10)
SBDen varchar(50)
TenNV nvarchar(50) HoaDon
*
MaMB char(10)
0..1
NgaySinh date MaHD char(10) ThamGiaChuyenBay
*
DiaChi nvarchar(50) NgayHD date MaNV char(10)
*
GioiTinh nvarchar(5) ThanhTien money PhieuHoanTien MaCB char(10)
*
SDT char(15) MaNV char(10) MaHoan char(10) primary key(MaNV,MaCB)
*
ChucVu nvarchar(50) MaKhach char(10) NgayHoan date

ThanhTien money
*
MaHD char(10)
KhachHang
0..1
MaKhach char(10)

TenKhach nvarchar(50)

DiaChi nvarchar(50)

SDT char(15)
LoaiMayBay MayBay ChuyenBay Ve ChiTietHoaDon
0..1 0..1 0..1 0..1 *
MaLoai char(10) MaMB char(10) MaCB char(10) MaVe char(10) MaHD char(10)
*
HangSX nvarchar(50) SoGhe int NgayBay date GiaTien money MaVe char(10)

TinhTrang nvarchar(50) GioCatCanh time SoLuongCon int primary key(MaHD,MaVe)


*
MaLoai char(10) GioHaCanh time HangVe char(10)
NhanVien
*
0..1 SBDi varchar(50) MaCB char(10)
MaNV char(10)
SBDen varchar(50)
TenNV nvarchar(50) HoaDon
*
MaMB char(10)
0..1
NgaySinh date MaHD char(10) ThamGiaChuyenBay
*
DiaChi nvarchar(50) NgayHD date MaNV char(10)
*
GioiTinh nvarchar(5) ThanhTien money PhieuHoanTien MaCB char(10)
*
SDT char(15) MaNV char(10) MaHoan char(10) primary key(MaNV,MaCB)
*
ChucVu nvarchar(50) MaKhach char(10) NgayHoan date

ThanhTien money
*
MaHD char(10)
KhachHang
0..1
MaKhach char(10)

TenKhach nvarchar(50)

DiaChi nvarchar(50)

SDT char(15)

You might also like