Exercise
DB SQL
[exercise8a] [exercise8b] [exercise9] Last update 2002.04.08 (2002.04.01 ) [1998.03.08 ]





Exercise: SQL, Structured Query Language

Fetch the semester 6 project database ('Database 1') from previous exercise.

First study the examples given in the lecture.

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

  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.


Exercise: Web implementation

Make a html page(s) for your project web calling your database through pages with addresses (see also the source code at the slide db_sem6_2002_groups ("c2xx" is translated to e.g. "c203").

Database 1 call addresses from web page

  • http://130.225.55.42/stud_asp_example/sem6_2002/c2xx/all_students.asp
  • http://130.225.55.42/stud_asp_example/sem6_2002/c2xx/s7_g2.asp
  • http://130.225.55.42/stud_asp_example/sem6_2002/c2xx/sem6_groups.asp

Database 2 call addresses from web page

  • http://130.225.55.42/stud_asp_example/sem6_2002/c2xx/c2xx.asp

Dowload (FTP) your database (.mbd) to
(the same database will contain both 'Database 1' and 'Database 2')

  • 130.225.55.42
    user: sem6_2002
    password: sem62002


Per Christiansson