Exercise
DB SQL
[exercise8a] [exercise8b] [exercise9] Last update 2003.03.25 (2002.04.08 ) [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

You may choose to create a simple database that will contain links to your documents produced. (See also the lecture slide 'the group database')

This database will store the adresses to your documents produced in the project. You can search the documents on name or part of name and get a ordered list back. (In this case we only have one table. The database can be extended with for exampel a person table and a table that connects documents and persons who created the document).

If you are going to use the ready made file to call the database from the web the table name and attribute name should be; "Filer" respectively "Filnavn". 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