数据库系统之数据库函数依赖与最高范式判断练习

最新推荐文章于 2024-02-18 13:47:57 发布

Jifu_M

最新推荐文章于 2024-02-18 13:47:57 发布

阅读量1.3k

点赞数 2

分类专栏：数据库系统项目练习文章标签：数据库最高范式判断

本文链接：https://blog.csdn.net/Jifu_M/article/details/112392129

版权

本文通过分析多个关系模式的函数依赖，判断了它们分别达到的最高范式。例如PLAYER达到了2NF，PART和DRIVER也是2NF，WAREHOUSE和R是1NF，而R(A, B, C, D, E)同样是1NF，因为存在非主属性对部分键的依赖。" 109170834,10133237,JavaScript中函数提升与变量提升的优先级解析,"['javascript', '前端开发', '变量作用域', '代码执行']

摘要由CSDN通过智能技术生成

数据库函数依赖与最高范式判断练习

(1)
PLAYER = ( pnum, team, name, position, address )
pnum → team
pnum → name
pnum → position
pnum → address
team → address

pnum → team, pnum → name, pnum → position and pnum → address, then through union rule
pnum →team, name, position, address, is valid in PLAYER and it covers entire relational schema then its left hand side is a minimal key (pnum)

2NF because no nonprime attribute depends on a part of primary key.
Not 3NF because a nonprime attribute address is transitively dependent on primary key pnum.
pnum → team, team → address.
Highest norm is 2NF

(2)
PART = ( p#, pname, manufacturer, city )
p# → pname,
manufacturer → city

p#, manufacturer → pname, city
p#, manufacturer → pname, manufacturer, city is valid in PART and it covers entire relational schema then its left hand side is a minimal key (p#, man