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