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

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

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

每个pnum对应一个团队名称、名字、职位以及地址；通过联合规则，则这些信息存在于PLAYER中，并涵盖整个关系模式。左边部分是一个最小的键（pnum）。

A relation is in second normal form (2NF) if none of its nonprime attributes depend functionally on any component of the primary key. A relation fails to be in third normal form (3NF) if there exists at least one non-prime attribute that depends transitively on the primary key, specifically pnum. The functional dependencies are defined as pnum determines te