Create Database

CREATE TABLE SACH
(
    MaSach VARCHAR(20) PRIMARY KEY,
    TenSach nvarchar(200),
    TheLoai VARCHAR(20),
    TacGia VARCHAR(10),
    NhaXB VARCHAR(5),
    NgayXB smalldatetime,
    Gia money
)
CREATE TABLE NHANVIEN(
    MaNV VARCHAR(10) PRIMARY KEY,
    TenNV nvarchar(50),
    NgaySinh smalldatetime,
    DiaChi nvarchar(200),
    SDT VARCHAR(11),
    GioiTinh INT,
    ChucVu INT(2),
    NgayVL smalldatetime
)
CREATE TABLE KHACHHANG(
    MaKH VARCHAR(10) PRIMARY KEY,
    TenKH nvarchar(100),
    DiaChi nvarchar(200),
    STD VARCHAR(11)
)
CREATE TABLE NHAXUATBAN(
    MaNXB VARCHAR(10) PRIMARY KEY,
    TenNXB nvarchar(200),
    DiaChi nvarchar(100),
    SDT VARCHAR(11)
)
CREATE TABLE HOADON(
    MaHD VARCHAR(10),
    MaKH VARCHAR(10),
    Ngay smalldatetime,
    MaSach text,
    SoLuong INT
)
CREATE TABLE PHIEUNHAP(
    MaPN VARCHAR(10) PRIMARY KEY,
    MaSach VARCHAR(10),
    SoLuong INT,
    MaNCC VARCHAR(10)
)
CREATE TABLE KHO(
    MaKho VARCHAR(5) PRIMARY KEY,
    NhaQL VARCHAR(10),
    DiaChi nvarchar(100)
)
CREATE TABLE THELOAI(
    MaTL VARCHAR(10) PRIMARY KEY,
    TenTL nvarchar(50)
)
CREATE TABLE TACGIA(
    MaTG VARCHAR(10) PRIMARY KEY,
    TenTG nvarchar(50),
    DiaChi nvarchar(100),
    SDT VARCHAR(11)
)
CREATE TABLE CHUCVU(
    MaCV VARCHAR(10) PRIMARY KEY,
    TenCV nvarchar(50),
    LuongCB money
)