Lab course in Database Technology (1056F), Summer 2005

Contents



News

Assistants

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: 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_summer05

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.

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 12th of August 2005, 08:00
  1. Assignment 1, deadline: 2005-07-13, 08:00

  2. Assignment 2, deadline: 2005-07-22, 08: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: 2005-08-05, 08: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-08-12, 08:00.
    Stock market application You can download a file with test data here.
    Molecular geometry application. This assignment requires basic knowledge of chemistry.
    Scientific database application.

F.A.Q.

Q: Where can I find the mailboxes to hand in assignments?
A: They are located in the building 1 on the fourth floor.

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: See instructions.
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.