1111

2-4-2
CREATE TABLE Penalty0868skx (
PID INT(4) NOT NULL COMMENT '读者编号',
BKID INT(4) NOT NULL COMMENT '图书编号',
PDate DATE NOT NULL COMMENT '罚款日期',
PType INT NOT NULL COMMENT '罚款类型',
Amounts DECIMAL(4,2) NOT NULL COMMENT '罚款金额',
PRIMARY KEY (PID, BKID, PDate),
FOREIGN KEY (PID) REFERENCES People0868skx(PID),
FOREIGN KEY (BKID) REFERENCES book0868skx(BKID)
) COMMENT = '图书罚款信息表';
3
INSERT INTO PeopleType0868skx (PTID, PType, BNum)
VALUES
(101, '小学生', 3),
(102, '初中生', 5);
INSERT INTO People0868skx (PID, PName, PSex, PTypeId, PAddress, PEmail)
VALUES
(1001, '张飞', '男性', 102, '常州武进区', 'zhangfei@m网页链接 '),
(1002, '赵云', '女性', 101, '杭州余杭区', 'zhaoyun@网页链接 ');
INSERT INTO publishers0868skx (PID, PName)
VALUES
(12, '人民邮电出版社'),
(13, '电子工业出版社');
INSERT INTO Book0868skx (BKId, Titles, writers, PublicId, PubDate, ISBN, Prices, CategoryId)
VALUES
(3039, '民族的智慧', '佚名', 12, '2016-08-01', '978455964005', 45.64, 7),
(3939, '张骞的穿透力', '吉安', 13, '2018-11-22', '978465964084', 28.74, 8);
INSERT INTO BookType0868skx (CategoryId, bName)
VALUES
(4, '文学'),
(5, '艺术');
INSERT INTO Borrow0868skx(PID, BKID, BorrowDate, ReturnDate)
VALUES
(1002, 3039, '2020-08-04', '2020-10-14'),
(1002, 3939, '2019-04-04', '2019-05-14');
INSERT INTO Penalty0868skx (PID, BKID, PDate, PType, Amounts)
VALUES
(1002, 3039, '2020-10-14', 1, 4.44),
(1002, 3939, '2019-05-14', 2, 14.44);
4
DELETE FROM Penalty0868skx;
DELETE FROM Borrow0868skx;
DELETE FROM book0868skx;
DELETE FROM People0868skx;
DELETE FROM BookType0868skx;
DELETE FROM Publishers0868skx;
DELETE FROM PeopleType0868skx;
4-2
INSERT INTO PeopleType0868skx (PTId, PType, BNum)
VALUES
(101, '小学生', 3),
(102, '初中生', 5),
(103, '高中生', 7);

1

INSERT INTO People0868skx (PID, PName, PSex, PTypeId, PAddress, PEmail)
VALUES
(1001, '沈珂璇', '男性', 103, '常州武进区', '[email protected]'),
(1002, '张三', '男性', 101, '北京朝阳区', '[email protected]'),
(1003, '李四', '女性', 102, '上海静安区', '[email protected]'),
(1004, '王五', '男性', 103, '广州天河区', '[email protected]'),
(1005, '赵六', '女性', 103, '深圳南山区', '[email protected]'),
(1006, '孙七', '男性', 101, '杭州西湖区', '[email protected]'),
(1007, '周八', '女性', 102, '成都锦江区', '[email protected]'),
(1008, '吴九', '男性', 103, '重庆渝中区', '[email protected]'),
(1009, '郑十', '女性', 103, '西安雁塔区', '[email protected]'),
(1010, '冯一', '男性', 101, '武汉武昌区', '[email protected]'),
(1011, '陈二', '女性', 102, '南京玄武区', '[email protected]'),
(1012, '褚三', '男性', 103, '天津和平区', '[email protected]');
4-3
INSERT INTO BookType0868skx (CategoryId, bName)
VALUES
(1, '文学'),
(2, '科技'),
(3, '历史'),
(4, '外语'),
(5, '艺术'),
(6, '教育');
4-4
INSERT INTO Publishers0868skx (PID, PName)
VALUES
(1, '高等教育出版社'),
(2, '人民文学出版社'),
(3, '机械工业出版社'),
(4, '外语教学与研究出版社'),
(5, '电子工业出版社'),
(6, '中信出版社'),
(7, '清华大学出版社'),
(8, '北京大学出版社'),
(9, '上海译文出版社'),
(10, '商务印书馆');
4-5
INSERT INTO book0868skx (BKId, Titles, writers, PublicId, PubDate, ISBN, Prices, CategoryId)
VALUES
(1001, '我的外语学习笔记', '沈珂璇', 1, '2024-04-05', '9787040123456', 39.80, 4),
(1002, '编程入门指南', '沈珂璇', 2, '2023-08-10', '9787111567890', 59.00, 2),
(1003, '历史人物解析', '沈珂璇', 3, '2023-11-20', '9787500098765', 45.50, 3),
(1004, '艺术鉴赏基础', '沈珂璇', 4, '2024-01-15', '9787513523456', 68.20, 5),
(1005, '教育心理学导论', '沈珂璇', 5, '2024-03-02', '9787560287654', 52.90, 6),
(1006, '大学英语四级考试指南', '王迈迈', 1, '2024-04-08', '9787040599887', 42.80, 4),
(1007, '高等数学（第七版·上册）', '同济大学数学系', 1, '2024-04-12', '9787040573442', 56.90, 2),
(1008, '中国近现代史纲要（2023版）', '本书编写组', 1, '2024-04-16', '9787040599030', 39.00, 3),
(1009, '艺术概论（第五版）', '王宏建', 1, '2024-04-20', '9787040598231', 49.80, 5),
(1010, '教育学原理（第三版）', '项贤明', 1, '2024-04-25', '9787040597999', 52.00, 6),
(1011, '新概念英语（第一册）', '亚历山大', 4, '2023-09-25', '9787521342195', 45.90, 4),
(1012, '新标准日本语（初级上册）', '标日编写组', 4, '2023-1

(1012, '新标准日本语（初级上册）', '标日编写组', 4, '2023-10-30', '9787521339249', 48.80, 4),
(1013, '简明法语教程（修订版）', '孙辉', 4, '2023-11-05', '9787521345875', 39.90, 4),
(1014, '平凡的世界（全三册）', '路遥', 2, '2023-05-05', '9787020165799', 108.00, 1),
(1015, '活着', '余华', 2, '2023-06-10', '9787020156730', 25.00, 1),
(1016, '红楼梦（四大名著珍藏版）', '曹雪芹', 2, '2023-07-15', '9787020171685', 69.80, 1),
(1017, '百年孤独', '加西亚·马尔克斯', 2, '2023-08-20', '9787020168950', 45.00, 1),
(1018, 'Python编程：从入门到实践（第3版）', '埃里克·马瑟斯', 3, '2023-07-15', '9787111721806', 89.00, 2),
(1019, '数据结构与算法分析（C语言版）', '马克·艾伦·维斯', 3, '2023-08-20', '9787111647010', 69.00, 2),
(1020, '机械设计手册（第六版）', '闻邦椿', 3, '2023-09-10', '9787111640188', 298.00, 2),
(1021, 'Java核心技术（卷1）', '凯·S·霍斯特曼', 5, '2023-10-05', '9787121451753', 129.00, 2),
(1022, '深度学习入门：基于Python的理论与实现', '斋藤康毅', 5, '2023-11-10', '9787121309425', 69.00, 2),
(1023, '人类简史（新版）', '尤瓦尔·赫拉利', 6, '2023-08-15', '9787521710282', 68.00, 3),
(1024, '原则（修订版）', '瑞·达利欧', 6, '2023-09-20', '9787521753611', 138.00, 3),
(1025, '计算机组成原理（第五版）', '唐朔飞', 7, '2023-11-25', '9787302645173', 59.80, 2),
(1026, '人工智能导论', '王万良', 7, '2023-12-05', '9787302630202', 49.80, 2),
(1027, '中国古代史（上册）', '张帆', 8, '2023-07-30', '9787301336382', 58.00, 3),
(1028, '西方哲学史（修订版）', '赵敦华', 8, '2023-08-30', '9787301330967', 68.00, 3),
(1029, '追风筝的人', '卡勒德·胡赛尼', 9, '2023-04-30', '9787532784096', 36.00, 1),
(1030, '小王子（精装版）', '圣埃克苏佩里', 9, '2023-07-20', '9787532788124', 42.00, 1),
(1031, '现代汉语词典（第七版）', '中国社会科学院语言研究所', 10, '2023-05-20', '9787100124508', 109.90, 6),
(1032, '牛津高阶英汉双解词典（第10版）', '霍恩比', 10, '2023-06-25', '9787100209571', 169.00, 4),
(1033, '线性代数（第七版）', '同济大学数学系', 1, '2024-04-28', '9787040598958', 45.00, 2),
(1034, '大学物理（第六版）', '马文蔚', 1, '2024-03-10', '9787040599122', 65.80, 2),
(1035, '思想道德与法治（2023版）', '本书编写组', 1, '2024-02-15', '9787040598217', 38.00, 6),
(1036, '计算机应用基础（第5版）', '赵守香', 1, '2024-01-20', '9787040597883', 49.90, 2),
(1037, '基础会计（第7版）', '陈国辉', 1, '2024-05-05', '9787040599795', 48.00, 6),
(1038, '三体（全三册）', '刘慈欣', 2, '2023

(1038, '三体（全三册）', '刘慈欣', 2, '2023-09-05', '9787020180603', 98.00, 1),
(1039, '围城', '钱钟书', 2, '2023-10-10', '9787020167632', 29.50, 1),
(1040, '骆驼祥子', '老舍', 2, '2023-11-15', '9787020171487', 18.00, 1),
(1041, '呐喊', '鲁迅', 2, '2023-12-20', '9787020171494', 22.00, 1),
(1042, '边城', '沈从文', 2, '2024-01-05', '9787020171500', 19.80, 1),
(1043, 'C++ Primer（第5版）', '李普曼', 3, '2023-10-25', '9787111521348', 128.00, 2),
(1044, '算法导论（第4版）', '托马斯·科尔曼', 3, '2023-11-30', '9787111723407', 139.00, 2),
(1045, '操作系统概念（第9版）', '西尔伯沙茨', 3, '2023-12-15', '9787111731239', 119.00, 2),
(1046, '数据库系统概论（第5版）', '王珊', 3, '2024-01-10', '9787111688247', 59.00, 2),
(1047, '网络工程师教程（第5版）', '雷震甲', 3, '2024-02-15', '9787111720861', 89.00, 2),
(1048, '牛津英语词典（缩印版）', '牛津大学出版社', 4, '2023-12-05', '9787521346780', 298.00, 4),
(1049, '走遍美国（全二册）', '贝克', 4, '2024-01-20', '9787521347893', 78.00, 4),
(1050, '剑桥商务英语（BEC初级）', '休斯', 4, '2024-02-25', '9787521348906', 58.00, 4),
(1051, '雅思词汇真经', '刘洪波', 4, '2024-03-10', '9787521349019', 45.00, 4),
(1052, '托福写作高分范文', '李笑来', 4, '2024-04-15', '9787521350121', 68.00, 4),
(1053, 'Python数据分析与挖掘实战', '张良均', 5, '2023-12-20', '9787121465789', 79.00, 2),
(1054, 'MySQL必知必会', '福塔', 5, '2024-01-25', '9787121459213', 45.00, 2),
(1055, 'Web前端开发实战', '黑马程序员', 5, '2024-02-10', '9787121478901', 89.00, 2),
(1056, '大数据时代', '舍恩伯格', 5, '2024-03-15', '9787121489012', 58.00, 2),
(1057, '区块链技术指南', '邹均', 5, '2024-04-20', '9787121490123', 99.00, 2),
(1058, '未来简史', '尤瓦尔·赫拉利', 6, '2023-10-05', '9787508672069', 68.00, 3),
(1059, '穷查理宝典', '彼得·考夫曼', 6, '2023-11-10', '9787521703852', 128.00, 3),
(1060, '巴菲特致股东的信', '劳伦斯·坎宁安', 6, '2023-12-15', '9787521754687', 88.00, 3),
(1061, '流量池', '杨飞', 6, '2024-01-20', '9787508683657', 58.00, 3),
(1062, '褚时健传', '先燕云', 6, '2024-02-25', '9787508668779', 68.00, 3),
(1063, 'Java编程思想（第4版）', '埃克尔', 7, '2023-11-05', '9787302223689', 108.00, 2),

(1064, '机器学习', '周志华', 7, '2023-12-10', '9787302423287', 88.00, 2),
(1065, '数据挖掘概念与技术（第3版）', '韩家炜', 7, '2024-01-15', '9787302338407', 79.00, 2),
(1066, '编译原理（第2版）', '龙书', 7, '2024-02-20', '9787302227510', 68.00, 2),
(1067, 'Linux内核设计与实现（第3版）', '罗伯特·洛夫', 7, '2024-03-25', '9787302395650', 69.00, 2),
(1068, '经济学原理（曼昆版）', '曼昆', 8, '2023-09-10', '9787301329257', 98.00, 6),
(1069, '法学导论（第2版）', '卓泽渊', 8, '2023-10-15', '9787301334586', 48.00, 6),
(1070, '社会学概论新修（第5版）', '郑杭生', 8, '2023-11-20', '9787301336214', 59.80, 6),
(1071, '普通心理学（第6版）', '彭聃龄', 8, '2023-12-25', '9787301338007', 79.00, 6),
(1072, '市场营销学（第10版）', '菲利普·科特勒', 8, '2024-01-30', '9787301339409', 89.00, 6),
(1073, '百年孤独（精装版）', '加西亚·马尔克斯', 9, '2023-08-10', '9787532789206', 58.00, 1),
(1074, '霍乱时期的爱情', '加西亚·马尔克斯', 9, '2023-09-15', '9787532789213', 48.00, 1),
(1075, '解忧杂货店', '东野圭吾', 9, '2023-10-20', '9787532779278', 39.50, 1),
(1076, '白夜行', '东野圭吾', 9, '2023-11-25', '9787532786045', 59.80, 1),
(1077, '嫌疑人X的献身', '东野圭吾', 9, '2023-12-30', '9787532786052', 45.00, 1),
(1078, '牛津高阶英汉双解词典（第9版）', '霍恩比', 10, '2023-07-10', '9787100158609', 149.00, 4),
(1079, '古代汉语（第一册）', '王力', 10, '2023-08-15', '9787100000827', 42.00, 6),
(1080, '辞海（第七版）', '辞海编纂委员会', 10, '2023-09-20', '9787532654449', 280.00, 6),
(1081, '新华字典（第12版）', '中国社会科学院语言研究所', 10, '2023-10-25', '9787100205879', 26.90, 4),
(1082, '朗文当代高级英语辞典（第6版）', '朗文出版社', 10, '2023-11-30', '9787100199727', 168.00, 4),
(1083, '概率论与数理统计（第七版）', '浙江大学数学系', 1, '2024-05-10', '9787040599804', 49.80, 2),
(1084, '大学化学（第2版）', '宋天佑', 1, '2024-05-15', '9787040599910', 58.00, 2),
(1085, '朝花夕拾', '鲁迅', 2, '2024-01-10', '9787020171517', 15.00, 1),
(1086, '狂人日记', '鲁迅', 2, '2024-01-15', '9787020171524', 12.00, 1),
(1087, '深入理解计算机系统（第3版）', '兰德尔·布莱恩特', 3, '2024-03-01', '9787111641918', 129.00, 2),
(1088, 'Head First设计模式', '埃里克·弗里曼', 3, '2024-03-05', '9787111641246', 89.00, 2),
(1089, '专四词汇闪过', '张国静', 4, '2024-04-20', '9787521351237', 42.00, 4),
(1090, '专八真题详解', '刘绍龙', 4, '2024-04-25', '9787521351343', 55.00

(1090, '专八真题详解', '刘绍龙', 4, '2024-04-25', '9787521351343', 55.00, 4),
(1091, '网页链接 实战', '尤雨溪', 5, '2024-05-01', '9787121360728', 79.00, 2),
(1092, 'React学习手册', '亚历克斯·班纳曼', 5, '2024-05-05', '9787121476543', 88.00, 2),
(1093, '影响力（新版）', '罗伯特·西奥迪尼', 6, '2024-02-01', '9787521754694', 68.00, 3),
(1094, '思考，快与慢', '丹尼尔·卡尼曼', 6, '2024-02-05', '9787508633558', 98.00, 3),
(1095, '深度学习', '伊恩·古德费洛', 7, '2024-03-10', '9787302464432', 128.00, 2),
(1096, '强化学习导论（第2版）', '理查德·萨顿', 7, '2024-03-15', '9787302529691', 89.00, 2),
(1097, '心理学与生活（第19版）', '理查德·格里格', 8, '2024-01-20', '9787301327635', 128.00, 6),
(1098, '社会心理学（第11版）', '戴维·迈尔斯', 8, '2024-01-25', '9787301338014', 98.00, 6),
(1099, '挪威的森林', '村上春树', 9, '2024-02-10', '9787532789220', 45.00, 1),
(1100, '柯林斯COBUILD高阶英汉双解学习词典', '柯林斯出版社', 10, '2024-03-20', '9787100223456', 198.00, 4);
4-6
INSERT INTO Borrow0868skx (PID, BKID, BorrowDate, ReturnDate)
VALUES
(1001, 1001, '2024-04-06', '2024-06-06'),
(1001, 1011, '2024-04-10', '2024-06-10'),
(1001, 1032, '2024-04-15', '2024-06-15'),
(1002, 1014, '2024-03-05', '2024-05-05'),
(1002, 1039, '2024-03-15', '2024-05-15'),
(1003, 1073, '2024-02-18', '2024-04-18'),
(1004, 1018, '2024-01-10', '2024-03-10'),
(1004, 1063, '2024-01-20', '2024-03-20'),
(1005, 1023, '2023-12-05', '2024-02-05'),
(1006, 1007, '2023-11-08', '2023-01-08'),
(1011, 1025, '2023-10-10', '2023-12-10'),
(1012, 1027, '2023-10-15', '2023-12-15');
4-7
INSERT INTO Penalty0868skx (PID, BKID, PDate, PType, Amounts)
VALUES
(1001, 1001, '2024-06-08', 1, 4.50),
(1001, 1011, '2024-06-12', 2, 18.00),
(1001, 1032, '2024-06-18', 1, 7.20),
(1002, 1014, '2024-05-08', 1, 3.00),
(1003, 1029, '2024-04-10', 1, 2.50),
(1004, 1018, '2024-03-12', 2, 22.00),
(1005, 1023, '2024-02-08', 1, 1.80),
(1006, 1007, '2023-01-10', 1, 5.00);