Confused about duplicate courses

[Teng Long]

Hi there,

According to the specification of q3 "note that a student may fail a course and take it again, thus we need to count duplicate courses" we should count the duplicate courses. 

However, the PK of course_enrolments is student_id and course_id which means the duplicates will never happen. And it sounds logical that if a student failed in a course they may enroll in another course in the same subject. 

So, does this means we don't need to worry about duplicates when checking if a student takes at least num_courses courses and records with same subject code may be returned?

Regards,

Teng

[Boge Liu]

Some students treat courses with the same name as the same course in project 1. We write this because we want to let you know that two courses with the same name in your result is logically correct.

Boge

--
You received this message because you are subscribed to the Google Groups "COMP9311 Project Q&A" group.
To unsubscribe from this group and stop receiving emails from it, send an email to comp9311-project-qa+unsub...@googlegroups.com.
Visit this group at https://groups.google.com/group/comp9311-project-qa.
To view this discussion on the web visit https://groups.google.com/d/msgid/comp9311-project-qa/06bd1fd0-5466-4e2d-956d-8e5d705058dd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.