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: student number and full name details of all students
Report 2: student numbers, full names and date of births of female students
SELECT student_number, title, forename, surname
WHERE gender = 'F';
Next: Activity 2.2B
(c) SQA 2009