foreign keys - 3NF Normalization justification -

foreign keys - 3NF Normalization justification -

3nf. trying justify normalization process. have unique identifiers/ dummy keys (as pk) tables, foreign keys on many side of 1 many relationships. these fks, have dependent on pk qualify 3nf note: other non-key attributes dependent on pk

student {@student_id, student_name, teacher*} teacher {@staff_no, teacher_name, subject} lecture {@lecture_no, start_date, motivation, staff_no*, student_id*}

taking lecture entity example, other attributes dependent on "@lecture_no".

do foreign keys (staff_no , student_id) need dependent on pk qualify 3nf?

thanks

foreign-keys database-normalization 3nf