Untitled

 avatar
unknown
plain_text
3 months ago
1.3 kB
4
Indexable
use master
go 
create database QLSACH
go
use QLSACH
go
create table NhaXuatBan(
	MaNXB nchar(10) not null primary key,
	TenNXB nvarchar(20) not null,
	SoLuongXB int
)

create table TacGia(
	MaTG nchar(10) not null primary key,
	TenTG nvarchar(20) not null
)

create table Sach(
	MaSach nchar(10) not null primary key,
	TenSach nvarchar(20) not null,
	NamXB date,
	SoLuong int,
	DonGia money,
	MaTG nchar(10) not null,
	MaNXB nchar(10) not null
)

insert into NhaXuatBan values(N'NXB01', N'Le Van Vu', '100')
insert into NhaXuatBan values(N'NXB02', N'Ngo Khanh Hoa', '80')

insert into TacGia values(N'TG01', N'Le Hoai An')
insert into TacGia values(N'TG02', N'Nguyen An Lac')

insert into Sach values(N'S01', N'Dac Nhan Tam', '1999', '20', '300.000', N'TG01',N'NXB01')
insert into Sach values(N'S02', N'Dac Nhan Tam 2', '1999', '20', '300.000', N'TG02',N'NXB02')
insert into Sach values(N'S03', N'Dac Nhan Tam 3', '1999', '20', '300.000', N'TG01',N'NXB01')
insert into Sach values(N'S04', N'Dac Nhan Tam 4', '1999', '20', '300.000', N'TG02',N'NXB02')
insert into Sach values(N'S05', N'Dac Nhan Tam 5', '1999', '20', '300.000', N'TG02',N'NXB02')
insert into Sach values(N'S06', N'Dac Nhan Tam 6', '1999', '20', '300.000', N'TG01',N'NXB01')

select * from NhaXuatBan
select * from TacGia
select * from Sach
Editor is loading...
Leave a Comment