|
|
Lab course in Database Technology, Fall 2005
Contents
News
- 07.12.2005: I got an anonymous assignment 3. Contact me if you think it is yours. /MI
- 29.11.2005: Assignments 1 & 2 can be collected for completion at my office during todays office hours 15.15-17.00. /MI
- 23.11.2005: Please register with Course Manager if you haven't already.
- 22.11.2005: Assignment 1 solutions can be collected at my office. /EZ
- 11.11.2005
Online
registration for the lab course available.
Assistants
- Erik Zeitler
- room 1320, phone +46 18 471 3390, Mailbox 30;
erik.zeitler@it.uu.se
Consultation hours:
| w.45 |
Thursday
|
11.11
|
15:15-17:00
|
| w.46 |
Tuesday
|
15.11
|
15:15-17:00
|
|
Thursday
|
17.11
|
15:15-17:00
|
w.47
|
Tuesday
|
22.11
|
15:15-17:00
|
|
Thursday
|
24.11
|
15:15-17:00
|
w.48
|
Tuesday
|
29.11
|
15:15-17:00
|
|
Friday
|
2.12
|
10:15-12:00
|
w.49
|
Thursday
|
8.12
|
13:15-15:00
|
|
Friday
|
9.12
|
14:15-15:00
|
w.50
|
Tuesday
|
13.12
|
13:15-15:00
|
|
Thursday
|
15.12
|
10:15-12:00
|
- Johan Petrini
- room 1316, phone +46 18 471 6345, Mailbox 124;
johan.petrini@it.uu.se
Consultation hours:
| w.46 |
Tuesday
|
15.11
|
15:15-17:00
|
| w.46 |
Thursday
|
17.11
|
15:15-17:00
|
w.47
|
Wednesday
|
23.11
|
13:15-15:00
|
w.48
|
Tuesday
|
29.11
|
15:15-17:00
|
|
Wednesday
|
30.11
|
15:15-17:00
|
|
Friday
|
2.12
|
10:15-12:00
|
w.49
|
Wednesday
|
7.12
|
15:15-17:00
|
w.50
|
Monday
|
12.12
|
15:15-17:00
|
|
Wednesday
|
14.12
|
15:15-17: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_ht05
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 20th of January 2006, 17:00
- Assignment 1
[pdf | doc], deadline:
18 November 2005, 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:
25 November 2005, 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:
5 December 2005, 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
Useful MIMER SQL Documentation for this assignment:
- Data Retrieval(chapter 4)
- Appendix A "Example database"
in Mimer User's Manual
- Stored Procedures (chapter 8) and Triggers (chapter 9)
in Mimer Programmer's Manual
- Examples of
stored procedures and triggers
- Assignment 4,
deadline: 16 December 2005, 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.
|
|
