Solve !!!! Ask a question about candidate codes, function dependence, and what normal form

8646454

Let the relationship R (student number, student name, class, department, book number, book name, borrowing date) represent the student's borrowing book information; analyze the functional dependence of R, and point out the candidate code of R. The highest number of R has reached Normal form (up to BCNF)? Explain the reason. Decompose R into a set of 3NF relationship modes that maintain functional dependencies and have no damage to connectivity. Underline the main code of this group of relationships.

朗基奴斯

Seems to be a homework problem of database principles in universities ...

wtyrambo

I used to do this kind of questions when I was in college. I have forgotten it now ~~~~

ypcheng886

(Student ID, student name, class, department) student ID
(Book number, book name) Book number
(Student student number, book number, borrowing date) Student student number, book number

cuij560

Reaching the second normal form

cuij560

Wrong, reach third normal form