Untitled

CREATE database QLPHONG;

CREATE TABLE hotel
(
    idKS VARCHAR(20),
    tenKS varchar(50),
    diachi varchar(100),
    
    primary key (idKS)
);

CREATE TABLE phong
(
    idPhong varchar(20),
    idKS varchar(20),
    loaiP varchar(100),
    giaP float(30),
	
    PRIMARY key (idPhong),
    foreign key (idKS) REFERENCES hotel(idKS)
);
    
create table khach
(
    idKH varchar(20),
    hoten varchar(100),
    sdt varchar(20),
    
    primary key (idKH)
);

create table datphong
(
    idKS varchar(20),
    idKH varchar(20),
    
    ngaynhan date,
    ngaytra  date,
    
    idPhong varchar(20),
   	
    primary key (idKS, idKH),
    foreign key (idKS) references hotel(idKS), 
    foreign key (idKH) references khach(idKH),
    foreign key (idPhong) references phong(idPhong)
);