Assignments in Database Design I - 1DL300
Spring 2012
Contents
News
- 2011-11-04 - Page created. /EZ
- 2012-01-18 - Links updated. /LM
- 2012-01-23 - Deadlines added. /LM
- 2012-02-09 - Office hour updated. /CX
Assistants
- Mikael Lax, course assistant, email: mikael.lax@it.uu.se, phone: 471 7345, room 1306
- Lars Melander, course assistant, email: lars.melander@it.uu.se, phone: 471 1051, room 1316.
- Cheng Xu, course assistant, email: cheng.xu@it.uu.se, phone: 471 7345, room 1306.
Supervision
Office hours for additional consultations (be aware that times and dates can be updated):
- Mikael Lax: Thursdays 13:00 - 15:00
- Lars Melander: Wednesdays 13:00 - 15:00
- Cheng Xu: Fridays 13:00 - 15:00
Registration
- The assignments should be solved in groups of 2 persons. It is your
responsibility to form the groups. Groups can be registered in the
student portal.
Submission
- All reports must be handed in, in paper form, in a pigeonhole
(postbox numbers- Cheng: 136, Lars : 10, Mikael: 66) at 4th floor in
House 1.
Assignments will be divided among assistants after the soft deadline for
each assignment.
- The status of corrected assignments are posted under "Progress"
("Framsteg"). "Work pending" means that the hand-in is
erroneous/incomplete.
- 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.
- For each assignment there is a deadline about one week after each
assignment starts (se below for each individual assignment).
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 will also be a hard deadline about three weeks
after the last assignment deadline. The hard deadline is the final
date for all assignments and after that you will have to resubmit your
assignments at the next course instance.
- The date for the Hard Deadline is: Thursday 15th, March
Assignments
-
There are three assignments in all where the first one is more
theoretical to carry out on paper and the two remaining are
computer-based assignments.
The computer-based assignments will be carried out by running Mimer on
the Solaris computers at the department. You may also use your own PC
under
Windows or Linux but we do not provide any PC support or installation
assistance.
- Important: All assignments are compulsory. Lab attendance is not mandatory, but recommended.
- Important 2: Write in English!
-
Assignment 1 - Normalization: [ pdf ]
- Soft deadline: Wednesday 8th, February
-
Assignment 2 - Database Design and ER Modeling: [ pdf ]
- Soft deadline: Tuesday 14th, February
- You can study the schema and data for the Johnson Brothers database here: company schema and company data.
-
Assignment 3 - SQL Queries and Views and SQL JDBC API:
[pdf (Solaris)] [pdf (MsWindows)]
- Soft deadline: Tuesday 21st, February
- Read the instructions, compile and run the demo program. demoJDBCclient.java
- Here is the correct demo program for PC users: demoJDBCclient_pc.java
- Follow the instructions to make the assignment.
- jdbc tutorial
More info about JDBC together with other useful links to tutorials you can find below.
Resources
- Links to various resources of information and software:
-
Mimer documentation, Version 9.2 (html) (include User's Manual,
Reference Manual and Programmer's Manual)
- You can also find a pdf-version of this documentation: Mimer
documentation Version 9.2 (pdf)
F.A.Q.
-
Q: Can I submit my solution of an assignment by email?
-
A: If you are not able to hand in a printed copy, you can send it by e-mail.
Save the assignment as a PDF, with the name "<course>-<assignment>-<name of participant one>-<name of participant two>.pdf".
Handing in 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: In assignment 2, I'm instructed to add customers. What customers?
-
A: You need to make up some customers and add them to the Customer table. You can't have accounts without customers who own the accounts.
-
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_vt2012.sql and company_data_vt2012.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