Exercise
DB SQL
Last update 1998.03.17 (1998.03.08 ) [1998.03.08 ]





Exercise 5. SQL, Structured Query Language

Use Access and the fetch the semester 6 project database from previous exercise.

First study the examples given in the lecture.

Make your own SQL queries using the 'Foresporgsel' scheme.

  1. List all available project types i alphabetic order
  2. Count the number of project groups
  3. List for each student (in alphabetic order) group belonging and corresponding project.


Per Christiansson