Database Design - 1DL300
Assignments - Spring 2010
Contents
News
- 2010-02-19 - Lab3 instruction. /LM
- 2010-02-10 - Changed lab instructions back to old versions. /LM
- 2010-02-09 - lab2 instructions. /LM
- 2010-02-05 - Added lab1 deadline, consultation times. /LM
- 2010-02-02 - Updated Lab1 time. /LM
- 2010-01-25 - Page created. /LM
Assistants
- Lars Melander - room 1310, phone +46 18 471 3155, Lars.Melander@it.uu.se
- Cheng Xu - room 1306, phone +46 18 471 7345, Cheng.Xu@it.uu.se
Time for additional consultations (be aware that time and date can be updated):
- Lars Melander
Tuesday, 2010-02-09, 15:00 - 17:00
Tuesday, 2010-02-16, 15:00 - 17:00
Tuesday, 2010-02-23, 15:00 - 17:00
Tuesday, 2010-03-02, 15:00 - 17:00
2010-03-08 - 2010-03-19, vacation!
Tuesday, 2010-03-23, 15:00 - 17:00 - Cheng Xu
Friday, 2010-02-12, 15:00 - 17:00
Friday, 2010-02-19, 15:00 - 17:00
Friday, 2010-02-26, 15:00 - 17:00
Friday, 2010-03-05, 15:00 - 17:00
Friday, 2010-03-13, 15:00 - 17:00
Friday, 2010-03-20, 15:00 - 17:00
Friday, 2010-03-27, 15:00 - 17:00
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:
Registration
- The assignments should be solved in groups of 2 persons. 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.
Submission
-
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 (final date for all assignments): 2010-03-28
-
Lab1:
date : 5 Feb, 8:15-10:00
- Background reading: [Padron-McCarthy/Risch: Chapter 11 | E/N: Chapter 3, 10, 7.1, 11.1, 11.2]
-
Lab2
date: 2009-02-11 locations: Pol_1515D, Pol_1549D Time: 10.15 - 12.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, in Mimer User's Manual, for this assignment:
- Mimer Company schema
- Mimer Company data
- Data Definition Language, DDL (chapter 7),
- Data Manipulation (chapter 5),
- BSQL commands (chapter 9),
- Error handling (chapter 11)
-
Lab 3
- date: 2010-02-24; location: 1515D,1549D ; Time: 15.15 - 17.00
-
Assignment 3: [pdf] ;
Deadline: 2010-03-07
- Read the instructions, compile and run the demo program.
- Follow the instructions to make the assignment.
- More info about JDBC together with other useful links to tutorials you can find below.
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 (1DL300 -summer) and assignment number. Leaving a printed copy is preferred though.
-
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