景区门票销售管理系统

Р( NAME = JQMPGL_data,Р FILENAME = 'D:\JQMPGL\JQMPGL_data.mdf',Р SIZE = 10,Р MAXSIZE = 40,Р FILEGROWTH = 5 )РLOG ONР( NAME = JQMPGL_log,Р FILENAME = 'D:\JQMPGL\JQMPGL_log.ldf',Р SIZE = 10MB,Р MAXSIZE = 30MB,Р FILEGROWTH = 5MB ) РGOР4.3.2 数据表创建语句Р营业员数据表创建语句:РCREATE TABLE YYY Р( YYY_NO CHAR(15) PRIMARY KEY NOT NULL , Р XM CHAR(10)NULL, Р XB CHAR(4)NULL, Р XL CHAR(10) NULL,Р NL INT NULL,Р ZW CHAR(15) NULL,Р LXFS CHAR(15) NULL,Р)Р门票数据表创建语句:РCREATE TABLE MP Р( PH CHAR(15) PRIMARY KEY NOT NULL , Р PZ CHAR(10)NULL, Р PS INT NULL,Р JQ DECIMAL(6,2) NULLР)Р游客数据表创建语句:РCREATE TABLE YK Р( DI CHAR(18) PRIMARY KEY NOT NULL , Р XM CHAR(10)NULL, Р XB INT NULL,Р LXFS CHAR(20) NULL,Р GZFS CHAR(10) NULLР)Р销售数据表创建语句:РCREATE TABLE XS Р( YYY_NO CHAR(15)NULL , Р PH CHAR(15)NULL, Р XSSL INT NULL,Р XSSJ DATE NULL,