The question is "Students cannot take the course 'Calculus 2' without having received a passing grade in 'Calculus 1'.",

but there is no Calculus 2 in the section table. Should we insert some sample data?

cysun wrote:

Why is it necessary to have Calculus 2 in the sections table?

was trying to write a test query to enroll in 'Calculus 2' that's restricted by the trigger , the table needs (id, student_id, section_id, grade_id), while no section_id exists for 'Calculus 2'

I guess the trigger works anyway

megtian wrote:

By the way, is 'Calculus 1' graded or NC/CR? Or should we consider both situations?

Consider both.

talisunep wrote:

cysun wrote:

megtian wrote:

By the way, is 'Calculus 1' graded or NC/CR? Or should we consider both situations?

Consider both.

i was wondering should the failing grade be C- and F here for this question? or F and NC/CR?

If it's not a passing grade (C or above or CR), it's a failing grade.

talisunep wrote:

megtian wrote:

cysun wrote:

Why is it necessary to have Calculus 2 in the sections table?

was trying to write a test query to enroll in 'Calculus 2' that's restricted by the trigger , the table needs (id, student_id, section_id, grade_id), while no section_id exists for 'Calculus 2'

I guess the trigger works anyway

professor Sun how do we test the constraint in the above question Exercise 5.6 (c)
without adding a new section_id which is linked to the course_id  to calculus 2 with course id =72?

What I meant was that a Calculus 2 section didn't have to be already there because you could insert it yourself.