Luận Văn Quản lý bán hàng

exists (select * from sysobjects where id = object_id(N'USERS') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table USERS
GO
if exists (select * from sysobjects where id = object_id(N'CTBAOHANH') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table CTBAOHANH
GO
if exists (select * from sysobjects where id = object_id(N'BAOHANH') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table BAOHANH
GO
if exists (select * from sysobjects where id = object_id(N'CTHOADON') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table CTHOADON
GO
if exists (select * from sysobjects where id = object_id(N'HOADON') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table HOADON
GO
if exists (select * from sysobjects where id = object_id(N'KHACHHANG') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table KHACHHANG
GO
if exists (select * from sysobjects where id = object_id(N'HANGHOA') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table HANGHOA
GO

/* ============================================================ */
/* Table: USERS */
/* ============================================================ */
create table USERS
(
USERNAMES CHAR(30) NOT NULL,
PASSWORDS CHAR(30) NOT NULL,
constraint PK_USERS primary key (USERNAMES)
)
go

/* ============================================================ */
/* Table: KHACHHANG */
/* ============================================================ */
create table KHACHHANG
(
MAKH char(5) not null,
TENKH varchar(20) null ,
DIACHI varchar(50) null ,
DIENTHOAI varchar(9) null ,
FAX varchar(9) null ,
EMAIL varchar(50) null ,
constraint PK_KHACHHANG primary key (MAKH)
)
go

/* ============================================================ */
/* Table: HANGHOA */
/* ============================================================ */
create table HANGHOA
(
MAH char(4) not null,
TENH varchar(20) null ,
GIA int null ,
SOLUONG int null ,
BAOHANH varchar(10) null ,
HANGSX varchar(30) null ,
KHUYENMAI varchar(50) null ,
constraint PK_HANGHOA primary key (MAH)
)
go

/* ============================================================ */
/* Table: PHIEUXUAT */