create database quanlysinhien
use quanlysinhvien
create table lop
(malop char (10) primary key,
tenop nvarchar (10))


create table tinh
(matinh char (10) primary key,
tentinh nvarchar (10))



create table sinhvien
(masv char (10) primary key,
hoten nvarchar (20),
ngaysinh datetime,
gioitinh nvarchar (20),
malop char (10) foreign key references malop(lop),
matinh char (10) foreign key references matinh(tinh),
dtb float)