• Added some possible column aliases.

• Updated table list.

• Initial basic working version of Sale specification.

• Corrected length of purchase ID values.

• Corrected name of sales table.

• Initial basic working version of Purchase specification.

• Initial basic working version of Customer specification.

• Initial basic working version of Other specification. ...

• Removed generated fixture file.

• Initial basic working version of Other specification.

• Initial basic working version of Service specification.

• Initial basic working version of Staff specification.

• Fixed quotes on test values.

• Initial basic working version of Warranty specification.

• Initial basic working version of Car_Feature specification.

• Added maximum length for Feature_Code.

• Restored inadvertently deleted extra cars.

• Initial basic working version of Feature specification.

• Initial basic working version of Car specification.

• Reformatted code. ...

• Ensured that code matches original text specification.

• Added initial specification files for Used Cars schema.

• Added initial working version of Used Cars schema DDL.

• 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.

Moved scenario-specific code into scenario subtree and factored out globally defined values into various configuration files. Also replaced a bunch of things with global constants.