Tài liệu đang xem: Bài 1 Lab 4

use Bai2;

create table Van_Phong (
MaSoVP int ,
DiaDiem varchar(100) not null
);

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

create table Chi_Tiet_Nhan_Than (
CCCDNhanThan int ,
TenNhanThan varchar(20) null,
NgaySinh date null,
MoiLienHe varchar(5)
);

create table San_Pham_BĐS (
MaBĐS int ,
DiaChi varchar(100) not null,
);

create table Chu_So_Huu (
CCCDChuSoHuu int ,
TenChuSoHuu varchar(20) not null,
SoDienThoai int,
DiaChi varchar(100) not null,
);