• Implemented specialised “non-informative” subclasses of various constraints so that we can test assertions without giving away the answers to the students! (closes #13) ...

• Refactored a couple of variable names.
• Fixed punctuation in assertion output.

• Added customised version of TestCase.php in order to disable output buffering (closes #31 for now).

• Refactored output_stream to outputStream. ...

• Removed spurious extra default: in switch statement.

• Made data tests dependent on the result of testColumnNullability. Closes #11 for all practical purposes (you still get errors when later dependent table load there fixtures, but there isn’t much that can be done about that).

• Fixed incorrectly nested check for whether testPKColumns had succeeded (closes #7).

• Completely re-engineered the way that fixture setup and teardown is managed so that it can be enabled and disabled on demand (closes #3). ...

• Fixed a bug in SimpleTestListener that caused a crash when a table didn’t exist in the schema being tested.
• Added proper error reporting for missing tables.

• Added initial coding for testing UNIQUE constraints. ...

• Removed unused argument to sprintf in assertFKColumns().

• Fixed inadvertently duplicated Username test value (also inconsistent with the other test values).

• Added support for zero or negative scale values. ...

• Improved reporting of precision/scale vs. length for NUMBER vs. *CHAR.
• Added NVL() to Data_Scale to eliminate spurious errors.
• Added debug output.

• Removed null min_length and decimals values from WEIGHTED_MARK as they were confusing the schema checker. It makes more sense for them to not just be specified anyway.

• Added constants for verbosity levels. ...

• Added debug verbosity level and status.

• Made verbosity comparisons more explicit. ...

• Made Reporter->report() an abstract method; subclasses must now implement output themselves.
• Switched to explicitly writing to output streams for each subclass rather than just using print or echo. This is because CLI and HTML use different output streams anyway (STDOUT and php://output, respectively).

• Corrected argument name in comment.

• Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!).

• Updated solution code to reflect changes to specification. ...

• Deleted triggers.
• Added minimum wage constraints.

• Changed minimum age of employees to 18. ...

• Deleted “starting out” minimum wage ⇒ adult minimum wage only.
• Corrected salary corresponding to adult minimum wage.
• Clarified calculation of gross earnings.
• Removed comment that Customer.Credit_Limit is optional.
• Tweaked car features.
• Change Warranty.Description to Warranty.Notes and made it optional. Also tweaked description of warranties.
• “bulk sales” → “fleet sales”.

• Added note about subtypes. ...

• Added note about Car_Feature.
• Updated minimum wage details.
• “Total” earnings → “gross” earnings.
• Clarified gross earnings calculation.
• Updated minimum year of car manufacture to 1995.
• Switched to automatic number formatting where appropriate.
• Added columns to Warranty and clarified descriptions.

• Removed references to “design-level” ERDs and modeified statement about analysis phase.

• Switched to Information Engineering notation to be consistent with INFO 211.

• Initial switch of scenario for 2014.

• Clarified salaries for senior staff (closes #14).

Updated solution and comments for 2013 results.

Added some optional constraints.

Changed the test values for rank and salary to avoid problems with clevel folks who restrict senior salaries to >$100000.

Workaround for testing FKs when there is more than one FK in the referenced table.

Added legal boundary values for Salary.

Added automated true/false value setting to the marking configuration.

Added the ability to specify that a number column should include no length or decimal places.

Added support for alternative true/false values in PHP, placeholders for them in XML, and a quick and dirty shell script to set them.

Changed sample username to be the same as one in the fixture in order to show up any UNIQUE constraint.