This preview shows page 1. Sign up to view the full content.
Unformatted text preview: . e) Find names and student numbers of students, who obtained and F for at least one course in Semester 1 , 2007 and the names of the lecturers who teach that course. f) Find student numbers of all students who did not enroll in the course WXGE6306 Web Commerce in Semester 1, 2007 . g) List all the students who obtained a GPA of < 3 . You are to hand in a softcopy of your database and a print out of your queries. Marks will be given for originality and appropriate naming of tables, forms and queries. You fail the assignment if : a) You submit disks which cannot be opened b) Your disks cannot be identified c) You submit a database in which the design view cannot be evaluated d) You only submit the splash screen of your database...
View Full Document
- Winter '09