Bài 1:CREATE DATABASE QUANLYTAISANUSE QUANLYTAISANcreate table dmphong(map nvarchar(10)primary key,tenp nvarchar(30)not null)create table dmtaisan(mats nvarchar(10)primary key,tents nvarchar(30)not null,donvi nvarchar(20),--DON VI TINH--gia int)--DON GIAcreate table phanphoi(mats nvarchar(10)not null,map nvarchar(10)not null,soluong int,ngaypp datetime,--NGAY PHAN PHOI TAI SAN--ghichu nvarchar(20),constraint kc primary key (mats,map),constraint kn1 foreign key(mats)references dmtaisan(mats),constraint kn2 foreign key (map)references dmphong(map) )--2.TAO VIEW DE TONG HOP THONG TIN VE CAC TAI SAN CO DON GIA LON NHAT--CREATE VIEW VD2ASSELECT * FROM DMTAISANWHERE GIA IN (SELECT MAX(GIA) FROM DMTAISAN) --3.TAO VIEW DE TONG HOP THONG TIN VE NHUNG TAI SAN CHUA TUNG DUOC PHAN PHOI CHO CAC PHONG DE SU DUNG--CREATE VIEW VD3ASSELECT * FROM DMTAISANWHERE MATS NOT IN (SELECT MATS FROM PHANPHOI)--4.TAO THU TUC CO THAM SO LA @TENP DE DUA RA DANH SACH CAC TAI SAN DUOC PHAN PHOI VAO PHONG TREN--CREATE PROC VD4@TENP CHAR(30)ASSELECT * FROM DMTAISANWHERE MATS IN (SELECT MATS FROM PHANPHOI WHERE MAP IN (SELECT MAP FROM DMPHONG WHERE TENP=@TENP))EXEC VD4 `LAN`--5.TAO THU TUC CO THAM SO LA @TENTS...