create database QLKS
use QLKS


create table khachhang
(mak char (10)primary key,
TenK nvarchar (25) not null
Diachi nvarchar(40,
SDT text)

create table Phong
(MaP nvarchar (10) primary key,
tenP nvarchar (20) not null ,
loaiP nvarchar(15),
Gia int)

create table Datphong
(MaK char (10) references khachhang(MaK),
MaP char (10) foreign key references phong(Map)
Ngaynhan datetime,
ngaytra datetime,
constraint kc primary key(MaK,MaP,ngaynhan))


create proc [endure] SP.tanggia
as
update phong
set gia=gia*1,05

create view vw Dangthue
as
select MaK,tenK,Diachi
from khach hang
where MaK in(select MaK from Datphong 
where ngay tra is null

create