CREATE TABLE [maihung].[dbo].[KHACHHANG]

(

MaKhachHang INT

CONSTRAINT PK_KHACHHANG_MaKhachHang PRIMARY KEY,

TenCongTy NVARCHAR(50) NOT NULL,

TenGiaoDich NVARCHAR(20) NOT NULL,

DiaChi NVARCHAR(50) NOT NULL,

Email VARCHAR(30) NOT NULL,

DienThoai VARCHAR(15) NOT NULL,

Fax VARCHAR(15) NOT NULL,

)

SELECT*

FROM [maihung].[dbo].[KHACHHANG]  

insert into [maihung].[dbo].[KHACHHANG]

values(1,N'Cong ty sua Viet Nam','Vinamilk',N'HaiPhong','[email protected]','031-641420','');

insert into [maihung].[dbo].[KHACHHANG]

values(2,N'Cong ty may mac Viet Tien','VietTien',N'HaiPhong','[email protected]','031-651649','');

insert into [maihung].[dbo].[KHACHHANG]

values(3,N'Tong cong ty thuc pham dinh duong Nutifood','Nutifood',N'HaiPhong','[email protected]','031-788990','');

CREATE TABLE [maihung].[dbo].[DONDATHANG]

(

SoHoaDon INT

CONSTRAINT PK_DONDATHANG_SoHoaDon PRIMARY KEY,

MaKhachHang INT NOT NULL,

MaNhanVien CHAR(10) NOT NULL,

NgayDatHang DATETIME NOT NULL,

NgayGiaoHang DATETIME NOT NULL,

NgayChuyenHang DATETIME NOT NULL,

NoiGiaoHang NVARCHAR(80) NOT NULL,

)

SELECT *

FROM [maihung].[dbo].[DONDATHANG]

INSERT INTO [maihung].[dbo].[DONDATHANG]

VALUES(1, 1, 'A001', '09/20/2007', '10/01/2007', '10/01/2007', N'Ha Noi');

INSERT INTO [maihung].[dbo].[DONDATHANG]

VALUES(2, 1, 'H001', '09/20/2007', '10/01/2007', '10/01/2007', N'Ha Noi');

INSERT INTO [maihung].[dbo].[DONDATHANG]

VALUES(3, 2, 'H002', '09/20/2007', '10/01/2007', '10/01/2007', N'Sai Gon');

Cach2(DonDatHang):

Insert Into [maihung].[dbo].[DonDatHang]

Values(1, 1, 'A001', '09/09/2007', '10/10/2009', '24/05/2009', N'Ha Noi');

Insert Into [maihung].[dbo].[DonDatHang]

Values(2, 1, 'H001', '09/09/2007', '10/10/2009', '24/05/2009', N'SaiGon');

Insert Into [maihung].[dbo].[DonDatHang]

Values(3, 1, 'H002', '09/09/2007', '10/10/2009', '24/05/2009', N'Hai Phong');

CREATE TABLE [maihung].[dbo].[NHANVIEN]

(

MaNhanVien CHAR(10)

CONSTRAINT PK_NHANVIEN_MaKhachHang PRIMARY KEY,

Ho NVARCHAR(40) NOT NULL,

Ten NVARCHAR(10) NOT NULL,

NgaySinh DATETIME NOT NULL,

NgayLamViec DATETIME NOT NULL,

DiaChi NVARCHAR(60) NOT NULL,

DienThoai VARCHAR(15) NOT NULL,

LuongCoBan NUMERIC(10,2) NOT NULL,

PhuCap NUMERIC(10,2) NOT NULL,

)

SELECT*

FROM [maihung].[dbo].[NHANVIEN] 

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('A001', N'Pham Mai', N'Hung', '03/07/1986','03/01/2009', N'Hai Phong', '056-647995', 10000000, 1000000);

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('H001', N'Nguyen Thu', N'Trang', '05/20/1986','03/01/2009', N'Hai Phong', '', 9000000, 1000000);

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('H002', N'Tran Tuan', N'Anh', '08/11/1987','03/01/2009', N'Hai Phong', '0905-611725', 12000000, 0);

CREATE TABLE [maihung].[dbo].[NHACUNGCAP]

(

MaCongTy CHAR(3)

CONSTRAINT PK_NHACUNGCAP_MaCongTy PRIMARY KEY(MaCongTy),

TenCongTy NVARCHAR(50) NOT NULL,

TenGiaoDich NVARCHAR(20) NOT NULL,

DiaChi NVARCHAR(50) NOT NULL,

DienThoai VARCHAR(15) NOT NULL,

Fax VARCHAR(15) NOT NULL,

Email VARCHAR(30) NOT NULL,

)

SELECT*

FROM [maihung].[dbo].[NHACUNGCAP]

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('VNM', N'Cong ty sua Viet Nam', 'VINAMILK', N'Ha Noi', '04-891135', '', '[email protected]');

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('MVT', N'Cong ty may mac Viet Tien', 'VIETTIEN', N'Sai Gon', '08-808803', '', '[email protected]');

INSERT INTO [maihung].[dbo].[NHANVIEN]

VALUES('SCM', N'Sieu thi Coop-mart', 'COOPMART', N'Quy Nhon', '056-888666', '', '[email protected]');

CREATE TABLE [maihung].[dbo].[CHITIETDATHANG]

(

SoHoaDon INT NOT NULL,

MaHang CHAR(4) NOT NULL,

GiaBan NUMERIC(10,2) NOT NULL,

SoLuong INT NOT NULL,

MucGiamGia NUMERIC(10,2) NOT NULL,

CONSTRAINT PK_CHITIETDATHANG_SoHoaDon_MaHang PRIMARY KEY(SoHoaDon, MaHang),

)

SELECT*

FROM [maihung].[dbo].[CHITIETDATHANG]

INSERT INTO [maihung].[dbo].[CHITIETDATHANG]

VALUES(9, 'DC01', 48000, 1000, 0);

INSERT INTO [maihung].[dbo].[CHITIETDATHANG]

VALUES(9, 'DC02', 2000, 1000, 0);

INSERT INTO [maihung].[dbo].[CHITIETDATHANG]

VALUES(9, 'DC03', 7500, 1000, 0);

CREATE TABLE [maihung].[dbo].[MATHANG]

(

MaHang CHAR(4)

CONSTRAINT PK_MATHANG_MaHang PRIMARY KEY(MaHang),

TenHang NVARCHAR(30) NOT NULL,

MaCongTy CHAR(3) NOT NULL,

MaLoaiHang CHAR(2) NOT NULL,

SoLuong INT NOT NULL,

DonViTinh NVARCHAR(10) NOT NULL,

GiaHang NUMERIC(10,2) NOT NULL,

)

SELECT*

FROM [maihung].[dbo].[MATHANG]

INSERT INTO [maihung].[dbo].[MATHANG]

VALUES('TP04', N'Tao', 'SCM', 'TP', 12, N'Ky', 12000);

INSERT INTO [maihung].[dbo].[MATHANG]

VALUES('TP05', N'Ca chua', 'SCM', 'TP', 15, N'Ky', 5000);

INSERT INTO [maihung].[dbo].[MATHANG]

VALUES('TP06', N'Banh AFC', 'SCM', 'TP', 100, N'Hop', 3000);

CREATE TABLE [maihung].[dbo].[LOAIHANG]

(

MaLoaiHang CHAR(2)

CONSTRAINT PK_LOAIHANG_MaLoaiHang PRIMARY KEY(MaLoaiHang),

TenLoaiHang NVARCHAR(30) NOT NULL,

)

SELECT*

FROM [maihung].[dbo].[LOAIHANG]

INSERT INTO [maihung].[dbo].[LOAIHANG]

VALUES('TP', N'Thuc pham');

INSERT INTO [maihung].[dbo].[LOAIHANG]

VALUES('DT', N'Dien tu');

INSERT INTO [maihung].[dbo].[LOAIHANG]

VALUES('MM', N'May mac');