Database Design - 1DL116
Assignments - Spring 2007
Contents
News
- 2007-03-17 - this page made accesible /EZ
Assistants
Time for consultations (be aware that time and date can be updated):
w 19 |
Thu 10 May |
17.00 - 18.00 |
|
w 20 |
Mon 14 May |
17.00 - 18.00 |
|
Tue 15 May |
17.00 - 18.00 |
|
w 21 |
Mon 21 May |
17.00 - 18.00 |
|
Fri 25 May |
17.00 - 18.00 |
|
w 22 |
Thu 31 May |
15.15 - 17.00 |
|
Time for consultations (be aware that time and date can be updated):
w 17 |
Tue 24.4 |
16.15 - 18.00 |
|
Thu 26.4 |
16.15 - 18.00 |
w 18 |
Fri 4.5 |
17.15 - 18.00 |
w 19 |
Tue 8.5 |
17.15 - 18.00 |
|
Fri 11.5 |
17.15 - 18.00 |
w 20 |
|
Tue 15 May |
17.00 - 18.00 |
|
w 21 |
Mon 21 May |
17.00 - 18.00 |
|
Fri 25 May |
17.00 - 18.00 |
|
w 22 |
Thu 31 May |
15.15 - 16.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.
- Choose "Register as a new student".
- Fill the form and click the "Register-button".
- A confirmation page will show.
- 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.
Supervision
Every group will be assigned automatically (at registration time) an 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 to various sources of information below:
SQL scripts for Jonson Brothers database schema and data
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 it and submit it again according to the assistants' comments. Failed assignments can be collected only from the correspondent assistant during his/her consultation time.
Assignments
Hard deadline: 2007-06-07
Assignment 1: [pdf | doc], deadline: 2007-05-04
- Background reading: [Padron-McCarthy/Risch: Chapter 11 | E/N: Chapter 3, 10, 7.1, 11.1, 11.2]
Assignment 2: [pdf | doc], deadline: 2007-05-14
- 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.
- Data Definition Language, DDL (chapter 7),
- Data Manipulation (chapter 5),
- BSQL commands (chapter 9),
- Error handling (chapter 11)
Assignment 3: [pdf | doc], deadline: 2007-05-21
- 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.
Examples of stored procedures and triggers.
- Data Retrieval (chapter 4)
- Appendix A "Example database"
- Stored Procedures (chapter 8)
- Triggers (chapter 9)
Assignment 4: deadline: 2007-06-04
- Background reading: [Padron-McCarthy/Risch: Chapter 16 | E/N: Chapter 20, 21, 22]
Choose one of the following tasks:
- Stock market application [pdf | doc]
- Molecular geometry application [pdf | doc]
- Database for scientific mesh-discretized data [pdf | doc]
Hard deadline for all assignments: TBA
Current status
F.A.Q.
Q: Can I submit my solution of an assignment by email?
A: Yes, you can submit your solution by email. You have to prepare pdf file of the report and specify in the subject field of the message the course name (DBT-ST06) and assignment number.
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?
Do not forget to create a new databank called 'Company'.
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