1NF:
I am working on 2NF:
student (student_id, name, start, program)
course (coure_code, course_name, faculty, credits, time)
student_course(student_id, course_code, grade)
I am trying to achieve 3NF and BCNF.
I have identified what I believe are transitive dependencies: { credit } → { time }
, and maybe { program } → { start }
.
Does this make any sense?