CREATE DATABASE CRASHCOURSE;
USE CRASHCOURSE;
CREATE TABLE EMPLOYEE_TBL
EMP_ID VARCHAR(9) NOTNULL,LAST_NAMEVARCHAR(15) NOT NULL,
FIRST_NAME VARCHAR(15) NOTNULL,MIDDLE_NAME VARCHAR(15),
[ADDRESS] VARCHAR(30) NOT NULL,
CITY VARCHAR(15) NOTNULL,
[STATE] CHAR(2) NOT NULL,ZIP INTEGER NOTNULL,PHONE CHAR(10),
PAGER CHAR(10)
CONSTRAINT EMP_PK PRIMARY KEY(EMP_ID)
);
CREATE TABLE EMPLOYEE_PAY_TBL
(
EMP_ID VARCHAR(9) NOTNULLPRIMARY KEY,
POSITION VARCHAR(15) NOTNULL,DATE_HIRE DATE,
PAY_RATE DECIMAL(4,2),
DATE_LAST_RAISE DATE,
SALARY DECIMAL(8,2),
BONUS DECIMAL(6,2),
CONSTRAINT EMP_FK FOREIGN KEY(EMP_ID)REFERENCESEMP LOYEE_TB L(EMP_ID)
);
CREATE TABLE CUSTOMER_TBL
(
CUST_ID VARCHAR(10) NOTNULLPRIMARY KEY,
CUST_NAME VARCHAR(30) NOTNULL,CUST_ADDRESS VARCHAR(20) NOT NULL,CUST_CITY VARCHAR(15) NOTNULL,CUST_STATE CHAR(2) NOTNULL,CUST_ZIP INTEGER NOTNULL,CUST_PHONE CHAR(10),
CUST_FAX VARCHAR(10)
);
CREATE TABLE ORDERS_TBL
(
ORD_NUM VARCHAR(10) NOTNULLPRIMARY KEY,
CUST_ID VARCHAR(10) NOTNULL,PROD_ID VARCHAR(10) NOTNULL,QTY INTEGER NOTNULL,ORD_DATE DATE
);
CREATE TABLE PRODUCTS_TBL
(
PROD_ID VARCHAR(10) NOTNULLPRIMARY KEY,
PROD_DESC VARCHAR(40) NOTNULL,COST DECIMAL(6,2) NOTNULL
);
INSERT INTO EMPLOYEE_TBL VALUES
(
'311549902','STEPHENS','TINA' ,'DAWN','RR 3 BOX 17A',
'GREENWOOD','IN','47890','3178784465',NULL
)
INSERT INTO EMPLOYEE_TBL VALUES
(
'442346889','PLEW','LINDA' ,'CAROL','3301 BEACON','INDIANAPOLIS','IN','46224','3172978990',NULL
)
INSERT INTO EMPLOYEE_TBL VALUES
(
'213764555','GLASS','BRANDON','SCOTT', '1710 MAIN ST', 'WHITELAND','IN','47885','3178984321','31757676'
)
INSERT INTO EMPLOYEE_TBL VALUES
(
'313782439','GLASS','JACOB',NULL, '3789 WHITE RIVER BLVD',
'INDIANAPOLIS', 'IN','45734','3175457676','8887345678'
)
INSERT INTO EMPLOYEE_TBL VALUES
(
'220984332','WALLAC E','MARIAH',NULL,'7889 KEYS TONE AVE','INDIANAPOLIS','IN','46741','3173325986',NULL
)
INSERT INTO EMPLOYEE_TBL VALUES
(
'443679012','SPURGEON','TIFFANY',NULL,'5 GEORGE COURT' ,
'INDIANAPOLIS','IN','46234','3175679007',NULL
)
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'311549902','MARKETING','1999-05-23',NULL,'2009-05-01','4000',NULL)
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'442346889','TEAM LEADER', '2000-06-17','14.75','2009-06-01',NULL,NULL)
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'213764555','SALES MANAGER','2004-08-14',NULL,'2009-08-01','30000','2000')
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'313782439','SALESMAN','2007-06-28',NULL,NULL,'20000','1000'
)
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'220984332','SHIPPER','2006-07-22','11.00','1999-07-01',NULL,NULL
)
INSERT INTO EMPLOYEE_PAY_TBL VALUES
(
'443679012','SHIPPER' ,'2001-01-14','15.00','1999-01-01',NULL,NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'232','LESLE GLEASON','798 HARDAWAY DR','INDIANAPOLIS',
'IN','47856','3175457690',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'109','NANCY BUNKER','APT A 4556 WATERWAY','BROAD RIPPLE','IN','47950','3174262323',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'345','ANGELA DOBKO','RR3 BOX 76','LEBANON','IN','49967','7658970090',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'090','WENDY WOLF','3345 GATEWAY DR','INDIANAPOLIS','IN','46224','3172913421',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'12','MARYS GIFT SHOP','435 MAIN ST','DANVILLE', 'IL', '47978','3178567221','3178523434'
)
INSERT INTO CUSTOMER_TBL VALUES
(
'432','SCOTTYS MARKET', 'RR2 BOX 173','BROWN SBURG','IN','45687','3178529835','3178529836'
)
INSERT INTO CUSTOMER_TBL VALUES
(
'333','JASONS AND DALLAS GOODIES','LAFAYETTE SQ MALL','INDIANAPOLIS','IN','46222','3172978886','317298887'
)
INSERT INTO CUSTOMER_TBL VALUES
(
'21','MORGANS CANDIES AND TREATS','5657 W TENTH ST' ,'INDIANAPOLIS','IN','46234','3172714398',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'43','SCHYLERS NOVELTIES','17 MAPLE ST','LEBANON','IN','48990','3174346758',N ULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'287','GAVINS PLACE', '9880 ROCKVILLE RD','INDIANAPOLIS',
'IN','46224','3172719991','3172719992'
)
INSERT INTO CUSTOMER_TBL VALUES
(
'288','HOLLYS GAMEARAMA','567 US 31 SOUTH', 'WHITELAND','IN','49980','3178879023',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'509','HEATHERS FEATHERS AND THINGS','4090 N SHADELAND AVE' ,'INDIANAPOLIS','IN','43278','3175456768',NULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'610','REGANS HOBBIES INC','451 GREEN ST','PLAINFIELD', 'IN','46818','3178393441','3178399090'
)
INSERT INTO CUSTOMER_TBL VALUES
(
'560','ANDYS CANDIES','RR 1 BOX 34','NASHVILLE', 'IN',
'48756','8123239871',N ULL
)
INSERT INTO CUSTOMER_TBL VALUES
(
'221','RYANS STUFF','2337 S SHELBY ST','INDIANAPOLIS','IN',
'47834','3175634402',NULL
)
INSERT INTO ORDERS_TBL VALUES
(
'56 A901','232','11235','1','2009-10-22'
)
INSERT INTO ORDERS_TBL VALUES
(
'56 A917','12','907','100','2009-09-30'
)
INSERT INTO ORDERS_TBL VALUES
(
'32A132','43','222','25','2009-10-10'
)
INSERT INTO ORDERS_TBL VALUES
(
'16C17','090','222','2','2009-10-17'
)
INSERT INTO ORDERS_TBL VALUES
(
'18D778','287','90','10','2009-10-17'
)
INSERT INTO ORDERS_TBL VALUES
(
'23 E934' ,'432','13','20','2009-10-15'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'11235','WITC H CO STUME' ,'29.99'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'222','PLASTIC PUMPKIN 18 INCH','7.75')
INSERT INTO PRODUCTS_TBL VALUES
(
'13','FALSE PARAFFIN TEETH', '1.10')
INSERT INTO PRODUCTS_TBL VALUES
(
'90','LIGHTED LANTERNS','14.50'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'15','ASSORTED COSTUMES','10.00')
INSERT INTO PRODUCTS_TBL VALUES
(
'9','CANDY CORN','1.35'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'6','PUMPKIN CANDY','1.45'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'87','PLASTIC SPIDERS' ,'1.05'
)
INSERT INTO PRODUCTS_TBL VALUES
(
'119','ASSORTED MASKS','4.95'
)
racknerd怎么样?racknerd美国便宜vps又开启促销模式了,机房优秀,有洛杉矶DC-02、纽约、芝加哥机房可选,最低配置4TB月流量套餐16.55美元/年,此外商家之前推出的最便宜的9.49美元/年套餐也补货上架,同时RackNerd美国AMD VPS套餐最低才14.18美元/年,是全网最便宜的AMD VPS套餐!RackNerd主要经营美国圣何塞、洛杉矶、达拉斯、芝加哥、亚特兰大、新...
美国高防服务器提速啦专业提供美国高防服务器,美国高防服务器租用,美国抗攻击服务器,高防御美国服务器租用等。我们的海外高防服务器带给您坚不可摧的DDoS防护,保障您的业务不受攻击影响。HostEase美国高防服务器位于加州和洛杉矶数据中心,均为国内访问速度最快最稳定的美国抗攻击机房,带给您快速的访问体验。我们的高防服务器配有最高层级的DDoS防护系统,每款抗攻击服务器均拥有免费DDoS防护额度,让您...
小白云是一家国人自营的企业IDC,主营国内外VPS,致力于让每一个用户都能轻松、快速、经济地享受高端的服务,成立于2019年,拥有国内大带宽高防御的特点,专注于DDoS/CC等攻击的防护;海外线路精选纯CN2线路,以确保用户体验的首选线路,商家线上多名客服一对一解决处理用户的问题,提供7*24无人全自动化服务。商家承诺绝不超开,以用户体验为中心为用提供服务,一直坚持主打以产品质量用户体验性以及高效...