Hide menu

TDDD37 Database Technology

Computer Labs

To do the labs, follow the following four steps:

1. Register to the labs

Register in pairs no later than november, 20.

2. Set up the environment

Follow the instructions detailed here.

3. Do the labs

The lab exercises are based on an existing database and, thus, it is important that you study the database first. The database and the exercises can be found here:

The labs are done in MySQL.

You can visit your lab assistant these times: Dag and Zlatan. Note that under the project your lab assistant will not always be present in the lab rooms. You can always contact him/her via e-mail.

4. Handing in the labs

The answers to the lab exercises should be handed by the following dates:

  • Lab 1 (SQL queries and views): 2014-11-11
  • Lab 2 (Database design and ER modeling): 2014-11-18
  • Lab 3 (Normalization): 2014-11-27
  • Lab 4a (Design and project ER modeling, plus translation to relations): 2014-11-27. Note that this hand in is required (with decent quality) for you to attend the mandatory teaching session 2.
  • Lab 4b (Implementation): 2015-01-10
  • The final (approved) project code (queries and stored procedures) should be sent to Urkund to the address jospe.liu@analys.urkund.se. The code should be attached as a file coursecode_year_student1_student2.txt (e.g. TDDD37_2014_jospe50_jospe51.txt). This will be used to check for plagiarism.
For those that did no finish the labs by the deadlines above, there are two extra occasions where we correct and report the lab results:
  • 2015-xx-xx, for labs handed in by 2015-xx-xx.
  • 2015-xx-xx, for labs handed in by 2015-xx-xx.
  • After these dates, the whole lab series must be redone.

Page responsible: Jose M. Peña
Last updated: 2014-10-28