函数依赖，闭包，覆盖，最小化基本集，部分函数依赖与完全函数依赖，传递函数依赖，候选键，外来建，逻辑蕴含

﹏ヽ暗。殇╰゛Y 2024-03-31 08:51 44阅读 0赞

**简介**：本文讲解函数依赖，闭包，覆盖，最小化基本集，部分函数依赖与完全函数依赖，传递函数依赖，候选键，外来建，逻辑蕴含。

## 函数依赖 ##

### 定义 ###

![在这里插入图片描述][3aee3053f5a6404fa19d453064e0f575.png]

### 示例 ###

![在这里插入图片描述][5ef200904308496faa3b0f8c0f351d65.png]

### 特性 ###

![在这里插入图片描述][9fae444de0c54d7abfd0a0605bb83126.png]

### 练习 ###

![在这里插入图片描述][62ef2e2d9a4d4995b1fe73bf3f67c1e9.png]  
![在这里插入图片描述][51e696a89c6b4fd792bf6d2325ea106d.png]

## 部分函数依赖与完全函数依赖 ##

### 定义 ###

![在这里插入图片描述][f16e061a172343929faeaf9a24e1a97e.png]

### 练习 ###

![在这里插入图片描述][f9818dc2cc764fb98ae054cb3c3caaed.png]

## 传递函数依赖 ##

### 定义 ###

![在这里插入图片描述][0e0b04f5b2534b9ca9c0a61859624f74.png]

### 练习 ###

![在这里插入图片描述][4a4aebf4ac6144f68691648076c1d0de.png]  
![在这里插入图片描述][d64a5711f9ea437b9cac5ff82161554c.png]

## 候选键 ##

### 定义 ###

![在这里插入图片描述][565e6c9caf29462c86550e748adff10e.png]

### 练习 ###

![在这里插入图片描述][1648450e187c408a9c8d49f6c18f505c.png]  
![在这里插入图片描述][219a165aceb645b487a1041931d2e015.png]  
![在这里插入图片描述][9aa9e2bb041e4da9bcb117839ca03d50.png]

## 外来键 ##

### 定义 ###

![在这里插入图片描述][15ae0f02ffbc456a903ff1adf2b74ae4.png]

## 逻辑蕴涵 ##

### 定义 ###

![在这里插入图片描述][68e3a4c9a13e469689962e61c607674f.png]

## 闭包 ##

### 定义 ###

![在这里插入图片描述][766a7a887c624d1f9fb0a48cc2601f08.png]

### 属性闭包计算方法 ###

![在这里插入图片描述][1034cda3d2be48aab3b8a6d6ad2855d0.png]

### 例题 ###

![在这里插入图片描述][ce4885db79af43228fa2022f06bbbe11.png]  
![在这里插入图片描述][a12d6a8a765a450b834ff3a32adc1ce5.png]

## 覆盖 ##

### 定义 ###

![在这里插入图片描述][3ea298626a1c4dc1bbe520e7735878db.png]

## 最小化基本集 ##

![在这里插入图片描述][4c230e736d644d689b9a23cc6caab825.png]  
![在这里插入图片描述][e070ed70b34448a1b64694ceed26f03f.png]

[3aee3053f5a6404fa19d453064e0f575.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/1aaedfc7175842379873aec07636294c.png
[5ef200904308496faa3b0f8c0f351d65.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c56d449286f34747b25e820570f76cac.png
[9fae444de0c54d7abfd0a0605bb83126.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/2484da3160874a7aae2a7652cf8646bd.png
[62ef2e2d9a4d4995b1fe73bf3f67c1e9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/3c1bcd0306c744939954f986c9211601.png
[51e696a89c6b4fd792bf6d2325ea106d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/8a6fec0bc32f45ebaaee461409a3c76d.png
[f16e061a172343929faeaf9a24e1a97e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/45404d7225f7416083c440db8fbebe8a.png
[f9818dc2cc764fb98ae054cb3c3caaed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/4b9cca51c812490bb688c0f2116f22df.png
[0e0b04f5b2534b9ca9c0a61859624f74.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/bf2fec60bcf0408dad72f0ec07a28870.png
[4a4aebf4ac6144f68691648076c1d0de.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/d85d94e0bb964467a3211b66b7780ea9.png
[d64a5711f9ea437b9cac5ff82161554c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/7e58c19c888046ea89a5fe17e2fdb326.png
[565e6c9caf29462c86550e748adff10e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/1d2ded0f326140caa0e09226d0ace14d.png
[1648450e187c408a9c8d49f6c18f505c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/eaffa95318f2467aa19e714a5aa7e34d.png
[219a165aceb645b487a1041931d2e015.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/4433f16ea20041cbaa5dab4bd6158f9c.png
[9aa9e2bb041e4da9bcb117839ca03d50.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/0e3b410102fd43c399ece20b1e3bb41c.png
[15ae0f02ffbc456a903ff1adf2b74ae4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/216ab4c1b83f465c871d501b91007b33.png
[68e3a4c9a13e469689962e61c607674f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/3d4f701c074f4adfb2c2670751a3624f.png
[766a7a887c624d1f9fb0a48cc2601f08.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/376e390284b94788809db1079fc79dbd.png
[1034cda3d2be48aab3b8a6d6ad2855d0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a7955a4a829341a4b05606942693a41d.png
[ce4885db79af43228fa2022f06bbbe11.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/1e2b3a885acf49aaa5ac8e2a8d3838bb.png
[a12d6a8a765a450b834ff3a32adc1ce5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/759e6c6046a947529f49aa5604e7e215.png
[3ea298626a1c4dc1bbe520e7735878db.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/7c562d1dd4f644919d171428329970d0.png
[4c230e736d644d689b9a23cc6caab825.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/ec34f049fc644911984ed21779c1b78d.png
[e070ed70b34448a1b64694ceed26f03f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/69acac89d49449cf947a10a6e659ba49.png