|
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. |
|