Ex. 2 Task 5: Check Constraint Violation

[feaselkl]

There is a check constraint in Postgres, ck_checkdate, that requires the check-in date and check-out date be greater than or equal to the current date, and for check-in date to be before check-out date. At this point in time (2025-01-17), the information learners should enter on the page will fail because the check-in and check-out dates are both before the current date.

I'd recommend revising the instructions in the Description and in Step 7 to specify a check-in date 3 days from now (for example) and a check-out date 10 days from now. That will ensure that new cohorts of learners will not hit the check constraint error.