数据库系统概论学习3：第三章

朴灿烈づ我的快乐病毒、 2023-10-01 11:51 134阅读 0赞

## SQL ##

### SQL特点 ###

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_8_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][8d06767c114e4099bdbc4d04e20e3687.png]  
基本表：就是看到的二维表。

存储文件：就是存储在数据库里面的文件。

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][559ce8ea2d5e40d085560a0ad09e611a.png]

### 数据定义 ###

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][0232fbeaca3b4b41a8aade74c075abef.png]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_10_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 2]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_14_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][c09ae47635414b59971361e012a8649b.png]  
数据字典缩写：dd

### 数据查询 ###

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 3]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 4]  
![在这里插入图片描述][383007e691854f92bd931512d267290f.png]  
![在这里插入图片描述][8e4e4187f351492aae8b6ba6102cbe94.png]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 5]  
![在这里插入图片描述][0878b98683cc4ba0b4c780391ae3160d.png]  
![在这里插入图片描述][fd578c3291d5408ab0e297ed51287df6.png]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16 2]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][0a66f5622b4743049b46611152e251c9.png]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 6]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_17_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][64f1ab67c8204585b66e7d7228ec21d0.png]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 7]

### 查找选修了所有课程的学生姓名 ###

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 8]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16 2]

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_17_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 9]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 2]  
![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 3]  
![在这里插入图片描述][239bd0ea705e4988aff3dfba3396d221.png]

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_8_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/7deeb9df08fc46b3883003d6fd27257f.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_8,color_FFFFFF,t_70,g_se,x_16
[8d06767c114e4099bdbc4d04e20e3687.png]: https://img-blog.csdnimg.cn/8d06767c114e4099bdbc4d04e20e3687.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/9056ee37294f4aacbb2228a9a33cba86.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[559ce8ea2d5e40d085560a0ad09e611a.png]: https://img-blog.csdnimg.cn/559ce8ea2d5e40d085560a0ad09e611a.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/c56e0d967b874a64b57e5bd6d08f8da0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[0232fbeaca3b4b41a8aade74c075abef.png]: https://img-blog.csdnimg.cn/0232fbeaca3b4b41a8aade74c075abef.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_10_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/218b035461f842e1a00291f6e0cf7880.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_10,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/f4dc2dab30fc4d0ca140967429cba316.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_18,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/2c40a86488594ba9ac23fe5fcec68b2a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_18,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/de12c46541df4c86a4e21d420249b3e6.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_14_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/6296cac7dee14a4db3655f09796124a0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_14,color_FFFFFF,t_70,g_se,x_16
[c09ae47635414b59971361e012a8649b.png]: https://img-blog.csdnimg.cn/c09ae47635414b59971361e012a8649b.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/76b6bf98210d4279a106d2092c3de3b0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/2e777424fb27487bb00d17f4bbb7c23d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_16,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/907831fa7c394c1a8c054ebe1df7b39d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_16,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/75068ed61bde4bf1b515e1175f03b56a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[383007e691854f92bd931512d267290f.png]: https://img-blog.csdnimg.cn/383007e691854f92bd931512d267290f.png
[8e4e4187f351492aae8b6ba6102cbe94.png]: https://img-blog.csdnimg.cn/8e4e4187f351492aae8b6ba6102cbe94.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 5]: https://img-blog.csdnimg.cn/fce9b798a581478692c88e87c21441f9.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[0878b98683cc4ba0b4c780391ae3160d.png]: https://img-blog.csdnimg.cn/0878b98683cc4ba0b4c780391ae3160d.png
[fd578c3291d5408ab0e297ed51287df6.png]: https://img-blog.csdnimg.cn/fd578c3291d5408ab0e297ed51287df6.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_18_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/aa7b7b9c2fda4b4d85c197fb85cb4d4c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_18,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/f70ee38b640041e09fb0a66635bde645.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_19,color_FFFFFF,t_70,g_se,x_16
[0a66f5622b4743049b46611152e251c9.png]: https://img-blog.csdnimg.cn/0a66f5622b4743049b46611152e251c9.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 6]: https://img-blog.csdnimg.cn/4db333966b13494182ac1a4ec3710051.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_17_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/b67680cf58bb41b2af6cbfc72ade348f.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_17,color_FFFFFF,t_70,g_se,x_16
[64f1ab67c8204585b66e7d7228ec21d0.png]: https://img-blog.csdnimg.cn/64f1ab67c8204585b66e7d7228ec21d0.png
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 7]: https://img-blog.csdnimg.cn/90a3203ded4d403b88d8a8cdb45db8f3.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 8]: https://img-blog.csdnimg.cn/50a3efd7f582449b9dd56795292596ca.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_16_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/4ee2c4a5114b4f4081b814848be1c366.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_16,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_17_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/fb5d1945718e44839389cf153b314481.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_17,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/ffab7aec02954b10ae24bba374119dff.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_19,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_20_color_FFFFFF_t_70_g_se_x_16 9]: https://img-blog.csdnimg.cn/6b3426872bf249d3a6d8b3b0537d8658.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/b1e3d349538a43e290b255d10a9b225d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_19,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w_size_19_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/19418b2bda7147b2bcf39478a89aa122.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5rSy55qE5a2m5Lmg56yU6K6w,size_19,color_FFFFFF,t_70,g_se,x_16
[239bd0ea705e4988aff3dfba3396d221.png]: https://img-blog.csdnimg.cn/239bd0ea705e4988aff3dfba3396d221.png