编程知识 cdmana.com

Database problem solving # review of final examination #

There is a relationship model reflecting teachers' participation in scientific research projects :
R( Teacher number , Project name , Scientific research workload , Project category , Project amount , person in charge )
If it is stipulated that : More than one person can participate in each project , Each teacher has a scientific research workload for each project ; Each item belongs to only one category , Only one person in charge .
(1) According to the above , Write mode R Basic functional dependencies and main codes .
(2) explain R No 2NF The reason of .
(3) take R Specification to 3NF.

版权声明
本文为[CSDN Q & A]所创,转载请带上原文链接,感谢
https://cdmana.com/2022/01/202201150237272097.html

Scroll to Top