CREATE DATABASE QL_BanHang

CREATE DATABASE QL_BanHang
USE QL_BanHang

SELECT * FROM DMKhach

CREATE TABLE DMKhach (
MaKhach char(10) PRIMARY KEY,
TenKhach nvarchar(20) NOT NULL,
DiaChi nvarchar(30) NOT NULL,
DienThoai char(15)
);

CREATE TABLE DMHang (
MaHang char(10) PRIMARY KEY,
TenHang nvarchar(20) NOT NULL,
DVT char(10) NOT NULL,
SoLuong int NOT NULL
);

CREATE TABLE HoaDonBan (
SoHD char(10) PRIMARY KEY,
MaKhach char(10) NOT NULL,
NgHD datetime NOT NULL,
DienGiai nvarchar(30)
CONSTRAINT MaKhach_FK FOREIGN KEY(MaKhach) REFERENCES DMKhach(MaKhach)
);

CREATE TABLE ChiTietHoaDon (
SoHD char(10) NOT NULL,
MaHang char(10) NOT NULL,
SoLuong int NOT NULL,
DonGia int NOT NULL,
CONSTRAINT SoHD_PK PRIMARY KEY(SoHD,MaHang),
CONSTRAINT SoHD_FK FOREIGN KEY(SoHD) REFERENCES HoaDonBan(SoHD),
CONSTRAINT MaHang_FK FOREIGN KEY(MaHang) REFERENCES DMHang(MaHang)
);



INSERT INTO DMKhach VALUES('MK1',N'Nguyễn Văn A',N'Thái Nguyên','');
INSERT INTO DMKhach VALUES('MK2',N'Nguyễn Văn B',N'Vĩnh Phúc','016498307');
INSERT INTO DMKhach VALUES('MK3',N'Lê Quang Vinh',N'Vĩnh Phúc','016498307');
INSERT INTO DMKhach VALUES('MK4',N'Nguyễn Văn C',N'Hà Nội','');
INSERT INTO DMKhach VALUES('MK5',N'Nguyễn Văn D',N'Lạng Sơn','012354879');
INSERT INTO DMKhach VALUES('MK6',N'Nguyễn Văn E',N'Bắc Giang','087456147');

.

23:48