Tài liệu đang xem: SQL Query 1

use congty_BĐS;

create table Nhan_Vien (
MaSoNV int primary key,
TenNV varchar(20) not null,
NgaySinh date not null,
ChucVu varchar(15) null
);

create table Van_Phong (
MaSoVP int primary key,
DiaDiem varchar(100) not null,
TruongPhong int references Nhan_Vien(MaSoNV)
);

create table San_Pham_BĐS (
MaBĐS int,
DiaChi varchar(100) not null,
MaSoVP int references Van_Phong(MaSoVP),
primary key(MaBĐS)
);

create table Chu_So_Huu(
CCCDChuSoHuu int,
TenChuSoHuu varchar(20) not null,
SoDienThoai int,
DiaChi varchar(100) not null,
MaBĐS int references San_Pham_BĐS(MaBĐS),
primary key(CCCDChuSoHuu)
);

create table Chi_Tiet_Nhan_Than(
MaSoVP int references Van_Phong(MaSoVP),
MaSoNV int references Nhan_Vien(MaSoNV),
TenNhanThan varchar(20) null,
NgaySinh date null,
MoiLienHe varchar(5),
CCCDNhanThan int,
primary key(CCCDNhanThan)
);