Using the solution to Activity 1.5, found in the previous section, develop a command file to create the student table and insert records into that table. Use SQL to display the entered rows.
Produce the following reports:
Report 1: details of students who have passed unit number 'U00313' or 'U00333' sorted by student number and unit number
Report 2: the student numbers and unit numbers of those students who failed to attend on 3 May 2004 sorted by student number within unit number
Next: Activity 2.2E
(c) SQA 2009