IT-højskolen /Courses Spring 2001 /Database-based Web Publishing

Home page for the course Database-based Web-publishing, spring 2001 (DKM)

Schedule Literature Students Course Grader Q&A Web-Server Hug.it.edu Using Ssh

Teaching Assistants
Kenneth Riis
kenneth@it.edu
Office 1.49
Office hours: none
Frank Bjergø
bjergoe@it.edu
Office 1.49
Office hours: Thursday 12.00 - 13.00
Lise Bennedsen
lise@it.edu
Office 1.49
Office hours: Monday 11.00 - 12.00
Mikkel Fennestad
fenne@it.edu
Office 1.49
Office hours: Monday 14.00 - 15.00
Course Responsible
Niels Hallenberg
nh@it-c.dk
Office 2.38
Office hours: Friday 10.00 - 11.00

NEWS

  • 2001-07-04: The final grades are now online. You can also find the grades outside the student office located at Glentevej. 50 students attended the exam and the average grade is 9.04.

Course Objectives

Learn to use advanced web-techniques to develop realistic, usable web-sites involving interchange of information with a database.

Prerequisites

The course Grundlæggende Web-design or similar prerequisites. If you have no programming experience, then you must be motivated and prepared to put some extra effort into some of the problem sets.

Course Description

Based on knowledge about the creation of static web-sites, the course provides the student with techniques for creating web-sites that are programs and web-sites that are databases. The students are introduced to the programming language TCL (Tool Command Language), for generating HTML code dynamically, and database-programming with Oracle SQL (Structured Query Language), for enriching web-pages with dynamic content. See the schedule below for details.

There is a homepage for this course taught last term.

When and Where

12 Tuesdays in the spring semester. Lectures are Tuesdays 9.01-12.00 in Aud. 0.10 (the first lecture, January 30, 2001, is in Aud. 0.10).

Grading Policy

Each student is evaluated with a grade in the 13-point scale. The grade is computed from completion of problem sets (50 percent) and a 4-hour written exam (50 percent). The final exam is June 12, 2001

Students turn-in 11 problem sets, individually. Each turned-in problem set is graded with points in the range 0 to 100. A non-turned-in problem set is graded with 0 points. For each student, only the problem sets with the 8 highest scores counts. To get credit for problem set solutions, the student must turn-in the solutions using CourseGrader before 9.00 on the Tuesday following the assignment. Here is a how-to for turning-in a problem set:

To turn-in your solutions to ``Problem set 1'', first make CourseGrader email you your password by providing CourseGrader with your IT-C email address (i.e., login@it-c.dk). You can then login to CourseGrader and turn-in your problem set by pressing the ``status'' link for the course and then the ``turn-in'' link for ``Problem set 1''. You should not enter entire solutions in the text-box. Rather, enter a link to your index-page and briefly describe what you have done and what you haven't done.
For the written exam all kinds of helping material (books, notes, old problem sets, calculators) is allowed, exept programmable computers (or programmable calculators).

Got Questions?

If you have a question about the course or the problem sets, you can post your question on the Q&A forum for the course. In this way, other people benefit from the answers. Notice, that the Q&A forum is the same that were used last semester, and therefore already contains answers to many questions.

You are also welcome to visit the course responsible or a teaching assistant during office hours.

Schedule

The schedule below is tentative, and changes will happen during the semester.

DayWeekTopicReadingProblem set
30/0105Introduction. Static sites. HTML. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapters 1, 4 og 5PS1
PS1-extra
06/0206Introduction to the programming language Tcl. My first dynamic web-page. Slides and Links. *A Smooth Introduction to Tcl for Web NerdsPS2
PS2-extra
13/0207Tcl continued. Tcl on the web server. Forms; obtaining data from users. Slides and Links. *A Smooth Introduction to Tcl for Web Nerds
*Philip and Alex's Guide to Web Publishing, chapter 10 (read example 4; skip the other examples)
PS3
PS3-extra
20/0208Tcl continued. Lists and Random numbers. States in web-programs with the use of form variables. Slides and Links. *Tcl for Web Nerds, sections instroduction, strings and lists.
*Philip and Alex's Guide to Web Publishing, chapter 10, example 3
PS4
27/0209Tcl continued. Lists and Pattern-matching. Obtaining data from foreign web-sites. Securing your data by checking form variables. Slides and Links. *Tcl for Web Nerds, section about lists and pattern-matching;
*Philip and Alex's Guide to Web Publishing, chapter 10, example 5
PS5
PS5-extra
06/0310Sites that are databases. Example: RemindMe. SQL (Structured Query Language). Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 11 and 12
*Tcl for Web Nerds, section about pattern-matching;
PS6
PS6-extra
13/0311Filebased databases. SQL continued. Slides and Links. *SQL for Web Nerds, chapter 2 and 3.
*Philip and Alex's Guide to Web Publishing, chapter 15, case 1 and 2.
PS7
20/0312Sites that are databases and SQL. Database-transactions via web-forms. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 13PS8
27/0313 Interfacing a database to the Web. Online communities. ACS (ArsDigita Community System). Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 2 and 3PS9
03/0414Securing your data by checking form variables. Procedures for checking form-variables and creating a changable site-design. Slides and Links. No reading for this TuesdayPS10
10/0415No TeachingNo TeachingNo Teaching
17/0416Canceled *Philip and Alex's Guide to Web Publishing, chapter 6, 7, and 9  
24/0417Publicizing a site. User tracking. Adding images to a site. The final. The future. Slides and Links. *Philip and Alex's Guide to Web Publishing, chapter 6, 7, 9 and 17 PS11
PS11-extra
01/0518Cookies. User authentification. An PhP3 example. Slides and Links. No reading for this Tuesday 

Literature

Related Literature

Development Server

In the course, we use the development server hug.it.edu, on which all students has a web server running. The development server hug.it.edu is a PC running RedHat Linux. Each student has obtainted a user name and a password to hug.it.edu by email.

You are personally responsible for backing up your files on hug.it.edu!

Software

  • ssh - software for logging in to remote machines securely and for transferring files to and from remote machines securely
  • tclsh - the tcl shell for experimenting with non-web-based tcl-programs
  • AOLserver - the great webserver available for UNIX and Windows. To install this webserver on your own machine, follow the installation instructions on the AOLserver website (Open Source)
  • Postgressql - an Open Source RDBMS

Students

The following class tables maps students to their home pages on hug.it.edu.

If you have been assigned a class, and you can not make it that day, then please send Niels a mail.

Class 1: Thuesday 12.30-16.30Room 3.15Frank Bjergoe
NameEmailWWW
Anne Gram Jørgensengram@it-c.dkhttp://hug.it.edu:8103
Astrid Helene Dyhr Pedersenastridity@it-c.dkhttp://hug.it.edu:8106
Bo Tvede Andersenbotvede@it-c.dkhttp://hug.it.edu:8108
Brian Grothbrian@it-c.dkhttp://hug.it.edu:8109
Brian Jacobsenbrianj@it-c.dkhttp://hug.it.edu:8110
Camilla Balslev Nielsenbalslev@it-c.dkhttp://hug.it.edu:8084
Carsten Curt Hjortchill@it-c.dkhttp://hug.it.edu:8112
Fawzia Devantierfd@it-c.dkhttp://hug.it.edu:8070
Jan Mikkelsenjam@it-c.dkhttp://hug.it.edu:8133
Joacim Jeppesenjj@it-c.dkhttp://hug.it.edu:8177
Laurance Stanford Vinsonstanford@it-c.dkhttp://hug.it.edu:8140
Michael Grusgaard Andersengrus@it-c.dkhttp://hug.it.edu:8148
Michael S. Königmsk@it-c.dkhttp://hug.it.edu:8149
Michael Christian Nielsenmcn@it-c.dkhttp://hug.it.edu:8147
Mie Ahmtmie@it-c.dkhttp://hug.it.edu:8151
Morten Per Berthel Iversenviom@it-c.dkhttp://hug.it.edu:8157
Nana Dencker Bargisenndb@it-c.dkhttp://hug.it.edu:8158
Sissel Elsmansissel@it-c.dkhttp://hug.it.edu:8170
Srdjan Pileticsrpil@it-c.dkhttp://hug.it.edu:8171
Steinar Logi Sigurdssonsteinar@it-c.dkhttp://hug.it.edu:8173
Troels Brun Folmannfolmann@it-c.dkhttp://hug.it.edu:8176
Class 2: Thuesday 12.30-16.30Room 3.16Lise Bennedsen
NameEmailWWW
Anne Holdtholdt@it-c.dkhttp://hug.it.edu:8104
Anne Lisbeth Lundlilu@it-c.dkhttp://hug.it.edu:8105
Charan Nelandercn@it-c.dkhttp://hug.it.edu:8115
Charlotte Whittwhitt@it-c.dkhttp://hug.it.edu:8116
Christian Aarfingaarfing@it-c.dkhttp://hug.it.edu:8117
Dan Bodalbodal@it-c.dkhttp://hug.it.edu:8121
Lise Louvlouv@it-c.dkhttp://hug.it.edu:8142
Marianne Susanne Lyng Anthonsenanthon@it-c.dkhttp://hug.it.edu:8146
Mikael Holm Møllermikaelm@it-c.dkhttp://hug.it.edu:8154
Mikkel Schou-Nielsenjante@it-c.dkhttp://hug.it.edu:8156
Peter Krogstruppeterk@it-c.dkhttp://hug.it.edu:8162
Rasmus Wolff Hansenwolff@it-c.dkhttp://hug.it.edu:8163
Rene Højbjerg Hansenrene@it-c.dkhttp://hug.it.edu:8166
Simon Schultzschultz@it-c.dkhttp://hug.it.edu:8169
Steen Odmand Jørgensenodmand@it-c.dkhttp://hug.it.edu:8172
Rasmus Mandrup Meyerluxor@it-c.dkhttp://hug.it.edu:8165
Class 3: Wednesday 09.00-13.00Room 3.15Kenneth Riis
NameEmailWWW
Allan Lundgaardlanky@it-c.dkhttp://hug.it.edu:8100
Carsten Schmidtcs@it-c.dkhttp://hug.it.edu:8113
Cecilie Dahl Madsencecilie@it-c.dkhttp://hug.it.edu:8114
Christian Jussi Arstorpjussi@it-c.dkhttp://hug.it.edu:8118
Christian Viktor Rasmussenviktor@it-c.dkhttp://hug.it.edu:8119
Christoffer Andreas Viggo Soyachristoffer@it-c.dkhttp://hug.it.edu:8120
Elise Nørrekjærelise@it-c.dkhttp://hug.it.edu:8122
Helle Kjærsgaardhellek@it-c.dkhttp://hug.it.edu:8129
Inge Troesttroest@it-c.dkhttp://hug.it.edu:8131
Jeppe Heilmann Risumjeppe@it-c.dkhttp://hug.it.edu:8135
Joachim Halsejoachim@it-c.dkhttp://hug.it.edu:8137
Mikael Holm Kjærbyemk@it-c.dkhttp://hug.it.edu:8153
Rasmus Jørgensenraz@it-c.dkhttp://hug.it.edu:8164
Class 4: Wednesday 09.00-13.00Room 3.16Mikkel Fennestad
NameEmailWWW
Anders Bonde Jensenbonde@it-c.dkhttp://hug.it.edu:8101
Anders Peter Telstrup Kofoedapt@it-c.dkhttp://hug.it.edu:8102
Beathe Sirevåg Andreassenbeathe@it-c.dkhttp://hug.it.edu:8107
Elsir Abdallah Mohammad Fadelallahelsir@it-c.dkhttp://hug.it.edu:8069
Louise Kirstine Olsenlouise@it-c.dkhttp://hug.it.edu:8143
Marian Marchen Notarmasomarian@it-c.dkhttp://hug.it.edu:8145
Søren Christian Lundlundinus@it-c.dkhttp://hug.it.edu:8178
Torben Dalhoftda@it-c.dkhttp://hug.it.edu:8175

Others

Name/EmailWWW
Kenneth Riis - teaching assistanthttp://hug.it.edu:8001
Frank Bjergø - teaching assistanthttp://hug.it.edu:8085
Lise Bennedsen - teaching assistanthttp://hug.it.edu:8054
Mikkel Fennestad - teaching assistanthttp://hug.it.edu:8155
Niels Hallenberg - course responsiblehttp://hug.it.edu:8077

updated 2001-02-19
Niels Hallenberg

til top