CREATE database QuanLySach
ON (Name= 'QuanLySach', filename='C:\SQL\QuanLySach.mdf', size=10mb, maxsize=UNLIMITED, FILEGROWTH=5mb)
log on
(Name='QuanLySach_log', filename='C:\SQL\QuanLySach_log.ldf', size=10mb, maxsize=20mb, FILEGROWTH=5mb)
go
create table NhanVien
(
MaNV char(5)PRIMARY KEY,
HoLot nvarchar(25) ,
TenNv nvarchar(10),
Phai nvarchar(5) ,
NgaySinh smalldatetime ,
DiaChi nvarchar(40),)
go
create table NhomSach
(
MaNhom char(5) primary key,
TenNhom nvarchar(25),
)
go
create table DanhMucSach
(
MaSach char(5) primary key,
TenSach nvarchar(40),
TacGia nvarchar(20),
MaNhom char(5),
DonGia numeric(5),
SLTon numeric(5),
)
go