根据《教材选录系统》需求完成以下数据库创建、数据表创建和数据操作任务①创建数据库db_105分②建表如下总分25分 表一T_book属性名 数据类型 可否为空 含 义 备注Book_id int 否 教材 id 主键Book_name varchar20 否 教材名称 Book_isbn varchar20 否 教材 ISBN 编号 Book_author varchar10 否 作者 Book_

创建数据库db_10: CREATE DATABASE db_10;

创建表T_book: CREATE TABLE T_book ( Book_id INT NOT NULL PRIMARY KEY, Book_name VARCHAR(20) NOT NULL, Book_isbn VARCHAR(20) NOT NULL, Book_author VARCHAR(10) NOT NULL, Book_publisher VARCHAR(20) NOT NULL, Book_price FLOAT NOT NULL );

创建表T_Order: CREATE TABLE T_Order ( Order_id INT NOT NULL PRIMARY KEY, Book_id INT NOT NULL, OrderDet_num INT NOT NULL, Order_time DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (Book_id) REFERENCES T_book(Book_id) );

插入数据到表T_book: INSERT INTO T_book (Book_id, Book_name, Book_isbn, Book_author, Book_publisher, Book_price) VALUES (101, '《Hadoop大数据分析》', '9787113259198', '高永彬', '中国铁道出版社', 108);

INSERT INTO T_book (Book_id, Book_name, Book_isbn, Book_author, Book_publisher, Book_price) VALUES (102, '《Python程序设计》', '9787302515326', '夏敏捷', '清华大学出版社', 56);

INSERT INTO T_book (Book_id, Book_name, Book_isbn, Book_author, Book_publisher, Book_price) VALUES (103, '《Html5+CSS3从入门到精通》', '9787517054160', '未来科技', '水利水电出版社', 70);

INSERT INTO T_book (Book_id, Book_name, Book_isbn, Book_author, Book_publisher, Book_price) VALUES (104, '《Linux管理与服务》', '9787040395853', '钱峰', '水利水电出版社', 48);

插入数据到表T_Order: INSERT INTO T_Order (Order_id, Book_id, OrderDet_num, Order_time) VALUES (1, 102, 127, '2021-06-24');

INSERT INTO T_Order (Order_id, Book_id, OrderDet_num, Order_time) VALUES (2, 101, 127, '2021-06-24');

INSERT INTO T_Order (Order_id, Book_id, OrderDet_num, Order_time) VALUES (3, 104, 127, '2021-06-24');

INSERT INTO T_Order (Order_id, Book_id, OrderDet_num, Order_time) VALUES (4, 102, 55, CURRENT_TIMESTAMP);

查询T_book表中作者是‘高永彬’的教材名称、ISBN号: SELECT Book_name, Book_isbn FROM T_book WHERE Book_author = '高永彬';

查询‘水利水电出版社’所有的教材信息: SELECT * FROM T_book WHERE Book_publisher = '水利水电出版社';

查询价格在50到80之间的教材名称、价格: SELECT Book_name, Book_price FROM T_book WHERE Book_price >= 50 AND Book_price <= 80;

查询T_Order表中订单时间为‘2021-06-24’的订单信息: SELECT * FROM T_Order WHERE Order_time = '2021-06-24';

修改T_Order表第4个订单的订单数量为126: UPDATE T_Order SET OrderDet_num = 126 WHERE Order_id = 4;

查询T_Order表中id为‘102’的教材被征订的总数量: SELECT SUM(OrderDet_num) FROM T_Order WHERE Book_id = 102;

查询ISBN号为‘9787040395853’的教材信息: SELECT * FROM T_book WHERE Book_isbn = '9787040395853';

统计订单表中订单id，教材名称，订购总数: SELECT T_Order.Order_id, T_book.Book_name, SUM(T_Order.OrderDet_num) AS TotalNum FROM T_Order JOIN T_book ON T_Order.Book_id = T_book.Book_id GROUP BY T_Order.Order_id, T_book.Book_name;

将以上SQL语句保存为.sql格式的脚本文件