Name (please print)____________________________ last 4 digits of SSN_________________________
Signature______________________________________disc-nt userid _________________
1. (50 points) A major software company offers free versions of its software to students. The instructor is required to submit the last name of students and their student id numbers so that downloads can be authorized (institution code, institution name, course id and course name are also established by the company). The relevant portion of the table called student_authorize is shown below:
institution_code integer;
institution_name varchar(30);
course_id integer;
course_name varchar(30);
instructor_last_name varchar(30);
student_id integer;
student_last_name varchar(30);
date_of_download varchar(8);
(format is yyyymmdd when the student performs the download, initially the field is empty)
Once a course has been approved, a table row is created for each student. When the student goes to the download site and downloads the software, the date_of_download field is filled in. Initially this date field contains an empty string.
Write a report sorted by course_name (ascending) that counts:
2. (50 points) Using the table above, write a query program for the table above that allows a user to examine the contents of a table row by specifying the student_id. The query should:
Write the two-pass asp program to perform this query operation.