nigel.stanger/sqlmarker

nigel.stanger / sqlmarker

2014-03-11	ea373b7 Browse files » • Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!). Nigel Stanger committed on 11 Mar 2014
2014-03-11	d377d7d Browse files » • Updated solution code to reflect changes to specification. ... • Deleted triggers. • Added minimum wage constraints. Nigel Stanger committed on 11 Mar 2014
2014-03-10	a44e0c6 Browse files » • 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”. Nigel Stanger committed on 10 Mar 2014
2014-03-10	307b189 Browse files » • 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. Nigel Stanger committed on 10 Mar 2014
2014-03-06	aeb77ed Browse files » • Removed references to “design-level” ERDs and modeified statement about analysis phase. Nigel Stanger committed on 6 Mar 2014
	1df0918 Browse files » • Switched to Information Engineering notation to be consistent with INFO 211. Nigel Stanger committed on 6 Mar 2014
	1a2cf6e Browse files » • Initial switch of scenario for 2014. Nigel Stanger committed on 6 Mar 2014
2013-12-12	3836287 Browse files » • Clarified salaries for senior staff (closes #14). Nigel Stanger committed on 12 Dec 2013
2013-09-19	c455594 Browse files » Updated solution and comments for 2013 results. Nigel Stanger committed on 19 Sep 2013
2013-09-19	f3a60a2 Browse files » Added some optional constraints. Nigel Stanger committed on 19 Sep 2013
2013-09-12	c1194bf Browse files » Changed the test values for rank and salary to avoid problems with clevel folks who restrict senior salaries to >$100000. Nigel Stanger committed on 12 Sep 2013
2013-09-05	13afc92 Browse files » Workaround for testing FKs when there is more than one FK in the referenced table. Nigel Stanger committed on 5 Sep 2013
2013-09-04	2675b1a Browse files » Added legal boundary values for Salary. Nigel Stanger committed on 4 Sep 2013
2013-09-03	2ecb0c7 Browse files » Added automated true/false value setting to the marking configuration. Nigel Stanger committed on 3 Sep 2013
	7b943c9 Browse files » Added the ability to specify that a number column should include no length or decimal places. Nigel Stanger committed on 3 Sep 2013
	8e1facc Browse files » Added support for alternative true/false values in PHP, placeholders for them in XML, and a quick and dirty shell script to set them. Nigel Stanger committed on 3 Sep 2013
	0bfd951 Browse files » Changed sample username to be the same as one in the fixture in order to show up any UNIQUE constraint. Nigel Stanger committed on 3 Sep 2013
	ef5311d Browse files » Added legal boundary values. Nigel Stanger committed on 3 Sep 2013
	bc70102 Browse files » Corrected reporting of overflow and underflow tests. Nigel Stanger committed on 3 Sep 2013
	d92304a Browse files » Added legal boundary values. Nigel Stanger committed on 3 Sep 2013
2013-09-02	8b590fa Browse files » Fixed handling of literal text and date default values. Nigel Stanger committed on 2 Sep 2013
	dbbab1c Browse files » Added default value testing. Nigel Stanger committed on 2 Sep 2013
	b018f45 Browse files » Rearranged PK testing code slightly. Nigel Stanger committed on 2 Sep 2013
2013-08-30	7873d87 Browse files » Added legal values test. Nigel Stanger committed on 30 Aug 2013
	3651356 Browse files » Inserted missing </table>. Nigel Stanger committed on 30 Aug 2013
	c429a97 Browse files » Added legal min/max values for relevant columns. Nigel Stanger committed on 30 Aug 2013
	3bd672e Browse files » Fixed sense of underflow constraint violation test. Nigel Stanger committed on 30 Aug 2013
	b4de964 Browse files » Added underflow and overflow testing. Nigel Stanger committed on 30 Aug 2013
	9e2b27c Browse files » Replaced overflow tests with underflow test. Nigel Stanger committed on 30 Aug 2013
	153e706 Browse files » assertColumnLegalValue() now correctly fails if the legal value generates a constraint violation. Nigel Stanger committed on 30 Aug 2013