You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I wonder if the foreign key of termination lease request should be lease id or lease id and student id? I think the termination lease request can be determined by lease id only. But on the other hand, in E-R diagram, it is the student who brings the termination lease request.
student_id->lease_id(current), lease_id->student_id(current), lease_id-> other attributes.
so student_id and lease_id are candidate key. It doesn't conflict 3nf, right?
The text was updated successfully, but these errors were encountered:
I wonder if the foreign key of termination lease request should be lease id or lease id and student id? I think the termination lease request can be determined by lease id only. But on the other hand, in E-R diagram, it is the student who brings the termination lease request.
student_id->lease_id(current), lease_id->student_id(current), lease_id-> other attributes.
so student_id and lease_id are candidate key. It doesn't conflict 3nf, right?
The text was updated successfully, but these errors were encountered: