BOX《SQL入门经典(第五版)》数据库创建脚本

sql数据库入门  时间:2021-02-27  阅读:()

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'

)

欧路云(22元) 新增美国Cera线路VPS主机且可全场8折

欧路云(oulucloud) 商家在前面的文章中也有陆续介绍过几次,这不今天有看到商家新增加美国Cera线路的VPS主机,而且有提供全场八折优惠。按照最低套餐最低配置的折扣,月付VPS主机低至22元,还是比较便宜的。不过我们需要注意的是,欧路云是一家2021年新成立的国人主机商,据说是由深圳和香港的几名大佬创建。如果我们有介意新商家的话,选择的时候谨慎且月付即可,注意数据备份。商家目前主营高防VP...

Hosteons:新上1Gbps带宽KVM主机$21/年起,AMD Ryzen CPU+NVMe高性能主机$24/年起_韩国便宜服务器

我们在去年12月分享过Hosteons新上AMD Ryzen9 3900X CPU及DDR4内存、NVMe硬盘的高性能VPS产品的消息,目前商家再次发布了产品更新信息,暂停新开100M带宽KVM套餐,新订单转而升级为新的Budget KVM VPS(SSD)系列,带宽为1Gbps端口,且配置大幅升级,目前100M带宽仅保留OpenVZ架构产品可新订购,所有原有主机不变,用户一直续费一直可用。Bud...

腾讯云爆款秒杀:1C2G5M服务器38元/年,CDN流量包6元起

农历春节将至,腾讯云开启了热门爆款云产品首单特惠秒杀活动,上海/北京/广州1核2G云服务器首年仅38元起,上架了新的首单优惠活动,每天三场秒杀,长期有效,其中轻量应用服务器2G内存5M带宽仅需年费38元起,其他产品比如CDN流量包、短信包、MySQL、直播流量包、标准存储等等产品也参与活动,腾讯云官网已注册且完成实名认证的国内站用户均可参与。活动页面:https://cloud.tencent.c...

sql数据库入门为你推荐
视频截图软件怎么把视频截成动图?还有一般剪辑视频什么的用什么软件比较好?湖南商标注册在湖南商标注册到底有什么用,不就是一个图标吗?免费开通黄钻怎样能免费开通黄钻会员吴晓波频道买粉吴晓波频道学习卡资费?依赖注入Spring 的依赖注入是什么意思?微信如何建群微信怎么建群?不兼容vivo手机和软件不兼容怎么办?不兼容手机软件与系统不兼容应该怎么办中小企业信息化什么是中小企业信息化途径硬盘人硬盘是指什么人
阿里云邮箱登陆首页 赵容 enzu godaddy支付宝 parseerror 嘉洲服务器 dd444 免空 admit的用法 免费phpmysql空间 河南移动梦网 丽萨 中国电信网络测速 论坛主机 广州虚拟主机 windowsserver2012 web服务器有哪些 ftp是什么东西 linux命令vi byebyelove 更多