Untitled
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