I'm trying to map my ERD to a relational schema; one trouble I ran into is regarding the ENROLLS
relationship which is M:N
. For M:N
in relational diagram, i know a separate table is made with the PKS
from both sides. However, my other side is a weak entity.
The table for ENROLLS
would then be [Ssn (PK), ? (PK)]
. I don't know what to do; do I just put all the partial keys?