|
Lab course in Database Technology, Spring 2006
Contents
News
- 26.06.2006 New assignment status here -- also, see CourseManager. Some assignments are still not graded. More news will follow soon.
- 19.06.2006 Due to reliability problems in CourseManager, no new results are reported there now. Assignments that are to be completed can be collected outside room 1346. If your assignment is not there, it's either because you are passed or because I have not had graded your assignment yet. A complete status list will appear here on June 26. We are sorry for the inconvenience.
- 27.05.2006 It is strongly recommended to do the AmosII tutorial before starting Assignment 4.
The tutorial is included in the downloladable AmosII archive.
- 19.05.2006 Erik Zeitler takes over the course assistance to the end of the course.
See below for consultation hours.
- 15.05.2006 Current status of assignments 1 and 2 is provided
- 12.04.2006 Lab time is scheduled on the
26th and the 27th of April to help you start working with
Mimer for assignments 2 and 3. Three groups are scheduled as follows:
Group 1 - 26.04.2006 15:15-17:00 Group 2 - 27.04.2006
13:15-15:00 Group 3 - 27.04.2006 15:15-17:00 If you want to
come, please book your place by writing your name on the list on
Milena's door 1319. To utilize the lab time usefully, read about SQL
and prepare the assignment questions in advance.
- 24.03.2006 Welcome
Assistants
- Milena Ivanova
- room 1319, phone +46 18 471 2846, Mailbox 82;
milena.ivanova@it.uu.se
Consultation hours:
w.16
|
Wednesday
|
19.04
|
15:15-17:00
|
w.16
|
Thursday
|
20.04
|
15:15-17:00
|
w.17
|
Wednesday
|
26.04
|
15:15-17:00 - Lab, Rooms 1412 and 1413
|
w.17
|
Thursday
|
27.04
|
13:15-17:00 - Lab, Rooms 1412 and 1413
|
w.18
|
Tuesday
|
02.05
|
08:30-10:15
|
w.18
|
Thursday
|
04.05
|
15:15-17:00
|
w.19
|
Thursday
|
09.05
|
15:15-17:00
|
w.19
|
Thursday
|
11.05
|
08:30-10:15
|
w.20
|
Tuesday
|
16.05
|
08:30-10:15
|
w.20
|
Wednesday
|
17.05
|
08:30-10:00 |
w.20
|
Friday
|
19.05
|
13:15-15:00 |
- Erik Zeitler
- room 1320, phone +46 18 471 3390, Mailbox 30;
erik.zeitler@it.uu.se
Consultation hours:
w.21
|
Tuesday
|
23.05
|
13:15-15:00
|
|
Friday
|
26.05
|
13:15-15:00
|
w.22
|
Tuesday
|
30.05
|
13:15-15:00
|
|
Wednesday
|
31.05
|
13:15-15:00
|
|
Thursday
|
01.06
|
13:15-15:00
|
w.23
|
Wednesday
|
07.06
|
13:15-15:00
|
|
Thursday
|
08.06
|
13:15-15: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.
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:
- Choose "Register as a new student".
- Fill the form and click the "Register-button".
- A confirmation page will show.
- Register Group:
- Choose "Register a group of students"
- 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"
- A confirmation page will display your group number and your assistant.
Online registration
The registration site is internal for the department. You can access it from the following computers:
- From inside the department network.
- 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 non-graphics browser 'lynx' to connect
to the online course system:
lynx http://udblserv.it.uu.se:8080/dbt_vt06
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 deadline. We guarantee that
assignments submitted before their respective deadline will be graded in a
week from the deadline. Assignments that are turned in after deadline will be
graded 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 collected only from the correspondent assistant.
Assignments
Hard deadline: Friday, the 9th of June 2006, 17:00
- Assignment 1
[pdf | doc], deadline:
21 April 2006, 17:00
- Background reading:
[Padron-McCarthy/Risch: Chapter 11 | E/N: Chapter 3, 10, 7.1, 11.1, 11.2]
- Assignment 2
[pdf | doc], deadline:
5 May 2006, 17:00
- Background reading:
[Padron-McCarthy/Risch: Chapter 2, 3, 7, 9 | E/N: Chapter 3, 4, 8]
Mimer is installed on the Solaris computers. If you prefer, you may use your PC to do this assignment.
NB: We cannot provide any PC support or installation assistance.
Mimer Instructions for
Solaris and PC
Useful MIMER SQL Documentation for this assignment:
- Data Definition Language, DDL (chapter 7),
- Data Manipulation (chapter 5),
- BSQL commands (chapter 9),
- Error handling (chapter 11)
in Mimer User's Manual
- Assignment 3
[pdf | doc], deadline:
19 May 2006, 17:00
- Background reading:
[Padron-McCarthy/Risch: Chapter 7, 8, 9, 12, 14, 15 | E/N: Chapter 8, 9.2]
Mimer is installed on the Solaris computers. If you prefer, you may use your PC to do this assignment.
NB: We cannot provide any PC support or installation assistance.
Mimer Instructions for
Solaris and PC
See also:
Examples of
stored procedures and triggers.
Mimer User's Manual
- Data Retrieval(chapter 4)
- Appendix A "Example database"
Mimer Programmer's Manual
- Stored Procedures (chapter 8)
- Triggers (chapter 9)
- Assignment 4,
deadline: 2 June 2006, 17:00.
- Background reading:
[Padron-McCarthy/Risch: Chapter 16 | E/N: Chapter 20, 21, 22]
Choose one of the following tasks:
- Stock market application
[pdf | doc]
Here is a file with test data.
- Molecular geometry application
[pdf |
doc]
- Database for scientific mesh-discretized data
[pdf | doc]
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 on a PC?
A: The procedure is described in
setting up Mimer SQL 9.2.
For more details how to create the data source 'DBTEK', read
the section "Creating a Database" in
Mimer SQL Engine for Windows Getting Started
where new database should be called '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.
Q:
My Mimer database on Solaris is locked. How to start it?
A: You have probably closed the window without closing the connection
to Mimer by exit;. Check the process ID of the bsql process you started
and kill it:
-
ps -f
--> see the PID of bsql, make sure the UID is yours
-
kill PID or
kill -9 PID , where PID is replaced by the value above
|
|