('004', 'TAO VAT LIEU SINH HOC BANG MANG OI NGUOI', 'NHA NUOC', '100','1/1/2007', '12/31/2009', 'NCPT', '004'),
CREATE TABLE GIAOVIEN(
MAGV NCHAR(10),
HOTEN NVARCHAR(30),
LUONG INT,
PHAI NCHAR(3),
NGSINH DATETIME,
DIACHI NVARCHAR(50),
GVQLCM NCHAR(10),
MABM NCHAR(10),
PRIMARY KEY(MAGV)
);
CREATE TABLE KHOA(
MAKHOA NCHAR(10),
TENKHOA NVARCHAR(30),
NAMTL INT,
PHONG NCHAR(10),
DIENTHOAI INT,
TRUONGKHOA NCHAR(10),
NGAYNHAMCHUC DATETIME,
PRIMARY KEY (MAKHOA)
CREATE TABLE BOMON(
TENBM NVARCHAR(30),
TRUONGBM NCHAR(10),
PRIMARY KEY (MABM)
CREATE TABLE GV_DT(