Lab course in Database Technology (1DL116), Fall 2004

Contents

• News
• Assistants
• Supervision
• Registration 
• Assignments
• Links
• Submitting
• F.A.Q.

News

• 050107 - Extra consultation times for assignment 4 during week 2, 2005.


• 041210 - Assignment 4 is now ready. You can choose between 2 versions about stock market and molecular geometry application. The deadline for assignment 4 is extended to 5th of January, 2005.

041118 - All students registered for the course have now Mimer directories on the department SUN/Solaris servers. In order to use Mimer there follow the instructions Running Mimer on SUN/Solaris.
The instructions for using Mimer on PC have been updated according to the new Mimer version 9.2.2.
041116 - Johan Petrini has removed his time for consultation Friday 03.12 due to traveling.
041108 - Assignment deadlines extended with 1 week for the assignments 1, 2, and 3 in order to fit better the lectures.
041108 - OBS! New version of Assignment 1 is put, the old one corresponded to the previous book edition.

Assistants

• Milena Ivanova - room 1319 , phone +46 18 471 2846, Mailbox 82 milena.ivanova@it.uu.se
  Time for consultations:
  

  w.2	Monday	10.01	13.30-15.00
  	Wednesday	12.01	15.30-17.00

• Johan Petrini - room 1316 , phone +46 18 471 6345, Mailbox 124, johan.petrini@it.uu.se
  Time for consultations:
  

  w.50	Tuesday	07.12	13.30-15.00
  	Thursday	09.12	09.00-10.00
  	Friday	10.12	10.00-12.00
  w.51	Thursday	16.12	09.00-10.00
  w.52	Tuesday	21.12	10.00-12.00

  
  

Registration

The assignments should be solved in groups of 2 persons. Only in special cases we will accept groups of 3 or 1 students. Please note that it is your responsibility to form the groups. Please do not register groups until you are sure of all the members of the group. The registration works as follows:
• Follow the Online registration link to the registration page.
• Register Student:
1. Choose "Register as a new student".
2. Fill the form and click the "Register-button".
3. Now you should see a page that says that you were successfully registered.
• Register Group:
1. Choose "Register a group of students"
2. Fill the form with each student username and password. This step can only be done once, i e you must enter ALL group members data at this point. Click "Register group-button"
3. Now you should see a page that says that your group was successfully registered.
   It also tells you your group number and who your assistent is.
Online registration

Note: the registration site is internal for the department. You can access it:
1. From inside the department network.
2. From anywhere by connecting via SSH to the either of the servers: zeppo.it.uu.se or hamberg.it.uu.se, where you have to have an account, and use the command-line browser 'lynx' to connect to internal web-pages, including the online course system:
   lynx http://udblserv.it.uu.se:8080/dbt_ht04

Supervision

Every group will be assigned automatically (at registration time) a responsible assistant. This assistant will grade the group's assignments and provide consultations to her/his groups during times scheduled for the purpose.
There are no bookings on the computer labs for this course, so make sure to plan your work since it can get crowded during peak times.

Links

Links to various sources of information below.
• Mimer documentation, Version 8.2:
  • User's Manual, Programmer's Manual, Reference Manual
• Mimer documentation on Mimer web site
• Mimer download
• Running Mimer on SUN/Solaris
• Running Mimer on PC
• SQL scripts for Jonson Brothers database schema and data
• AMOS download and documentation

Submitting

All reports must be handed in paper form in the pigeonhole of the responsible assistant.

For each assignment there is a 'soft' deadline. We guarantee that assignments submitted before this soft deadline will be checked in a week from the submission deadline. All other assignments will be checked whenever we have time (possibly after the exam). There is a 'hard' deadline after which we will not accept new assignments.

If you fail on an assignment, you have to complete the report and submit it again according to the assistants' comments. Failed assignments can be picked only from the correspondent assistant.

Assignments

Hard deadline: Friday, the 14th of January 2005, 17:00

1. Assignment 1, deadline: 2004-11-17, 17:00
   
2. Assignment 2, deadline: 2004-11-29, 17:00
   
   Mimer Instructions for Solaris and PC

   Useful MIMER SQL Documentation for this assignment: Data Definition Language, DDL(chapter 7), Data Manipilation (chapter 5),
   BSQL commands (chapter 9), Error handling (chapter 11) from Mimer User's Manual

3. Assignment 3, deadline: 2004-12-10, 17:00
   
   Mimer Instructions for Solaris and PC

   Useful MIMER SQL Documentation for this assignment: Data Retrieval(chapter 4) and Appendix A "Example database" from Mimer User's Manual,
   Stored Procedures (chapter 8) and Triggers (chapter 9) from Mimer Programmer's Manual
   Examples of stored procedures and triggers

4. Assignment 4 - deadline: 2005-01-05, 17:00.
   Stock market application You can download a file with test data here.
   Molecular geometry application

F.A.Q.

Q: Is the attribute Address from the table Customer (Assignment 1) atomic?
A: It is up to you to decide whether the attribute is atomic or not.


Q: How to set up Mimer SQL 9.2?
A: The procedure is the same as for setting up Mimer SQL 9.1.3.
For more details how to create the datasource 'DBTEK' you can read section "Creating a Database" from Mimer SQL Engine for Windows Getting Started where new database you should call 'DBTEK'.
Do not forget to create a new databank called 'Company'.
To load schema and data for Jonson Brothers database start  WSQL 2.3.6 and execute files company_schema_v9.sql and company_data_v9.sql by menu command SQL/Do sqlstatements in file.