某校数据库第四章课后习题建表

最新推荐文章于 2021-12-04 14:02:07 发布

一身都是月儿

最新推荐文章于 2021-12-04 14:02:07 发布

阅读量189

点赞数 2

分类专栏： SQL Server 文章标签：数据库 database

本文链接：https://blog.csdn.net/Oceansssss/article/details/120962364

版权

SQL Server 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

CREATE DATABASE pcshop
use pcshop
CREATE TABLE laptops (
    model CHAR(4) NOT NULL DEFAULT '',
    speed float DEFAULT NULL,
    ram int DEFAULT NULL,
    hd int DEFAULT NULL,
    screen float DEFAULT NULL,
    price float DEFAULT NULL,
    PRIMARY KEY (model)
);
INSERT INTO laptops (model, speed, ram, hd, screen, price) VALUES
('2001', 2, 2048, 240, 20.1, 3673),
('2002', 1.73, 1024, 80, 17, 949),
('2003', 1.8, 512, 60, 15.4, 549),
('2004', 2, 512, 60, 13.3, 1150),
('2005', 2.16, 1024, 120, 17, 2500),
('2006', 2, 2048, 80, 15.4, 1700),
('2007', 1.83, 1024, 120, 13.3, 1429),
('2008', 1.6, 1024, 100, 15.4, 900),
('2009', 1.6, 512, 80, 14.1, 680),
('2010', 2, 2048, 160, 15.4, 2300);
CREATE TABLE  pcs (
    model CHAR(4) NOT NULL,
    speed float NOT NULL,
    ram INT NOT NULL,
    hd INT NOT NULL,
    price float NOT NULL,
    PRIMARY KEY (model)
);
INSERT INTO pcs(model, speed, ram, hd, price) VALUES
('1001', 2.66, 1024, 250, 2114),
('1002', 2.1, 512, 250, 995),
('1003', 1.42, 512, 80, 478),
('1004', 2.8, 1024, 250, 649),
('1005', 3.2, 512, 250, 630),
('1006', 3.2, 1024, 320, 1049),
('1007', 2.2, 1024, 200, 510),
('1008', 2.2, 2048, 250, 770),
('1009', 2, 1024, 250, 650),
('1010', 2.8, 2048, 300, 770),
('1011', 1.86, 2048, 160, 959),
('1012', 2.8, 1024, 160, 649),
('1013', 3.06, 512, 80, 529);

CREATE TABLE  printers (
    model CHAR(4) NOT NULL DEFAULT '',
    color VARCHAR(5) DEFAULT NULL,
    type VARCHAR(10) DEFAULT NULL,
    price float DEFAULT NULL,
    PRIMARY KEY (model)
);
INSERT INTO printers (model, color, type, price) VALUES
('3001', 'TRUE', 'ink-jet', 99),
('3002', 'FALSE', 'laser', 239),
('3003', 'TRUE', 'laser', 899),
('3004', 'TRUE', 'ink-jet', 120),
('3005', 'FALSE', 'laser', 120),
('3006', 'TRUE', 'ink-jet', 100),
('3007', 'TRUE', 'laser', 200);

CREATE TABLE products (
    maker CHAR(1) DEFAULT NULL,
    model CHAR(4) NOT NULL DEFAULT '',
    type VARCHAR(10) DEFAULT NULL,
    PRIMARY KEY (model)
);
INSERT INTO products (maker, model, type) VALUES
('A', '1001', 'pc'),
('A', '1002', 'pc'),
('A', '1003', 'pc'),
('B', '1004', 'pc'),
('B', '1005', 'pc'),
('B', '1006', 'pc'),
('C', '1007', 'pc'),
('D', '1008', 'pc'),
('D', '1009', 'pc'),
('D', '1010', 'pc'),
('E', '1011', 'pc'),
('E', '1012', 'pc'),
('E', '1013', 'pc'),
('E', '2001', 'laptop'),
('E', '2002', 'laptop'),
('E', '2003', 'laptop'),
('A', '2004', 'laptop'),
('A', '2005', 'laptop'),
('A', '2006', 'laptop'),
('B', '2007', 'laptop'),
('F', '2008', 'laptop'),
('F', '2009', 'laptop'),
('G', '2010', 'laptop'),
('E', '3001', 'printer'),
('E', '3002', 'printer'),
('E', '3003', 'printer'),
('D', '3004', 'printer'),
('D', '3005', 'printer'),
('H', '3006', 'printer'),
('H', '3007', 'printer');