Hide menu

TDDD12 Database Technology

Assignments


The assignments are a mixture of computer lab work and classical homework. Doing the assignments is one of the two examination items of the course.

To do the assignments, you need to register in Webreg with your lab partner.

The computer labs are done via a MySQL database server that you have access to as a participant of the course. Before you can begin with the labs, follow the instructions to set up the environment.

The answers to the lab assignments should be handed in via a repository in LiU's GitLab. For detailed instructions see the repository olaha93/db. To log into GitLab you can use your LiU ID.

If you have any questions feel free to contact your lab assistant via e-mail.

Assignment 1 (SQL queries and views)

Assignment 2 (Database design and EER modeling)

Assignment 3 (FDs and normalization)

Assignment 4 (BrianAir project)

Dates

  • Registration: register in Webreg with your lab partner no later than Apr. 3, 2020
  • Assignment 1: Apr. 9, 2020
  • Assignment 2: Apr. 21, 2020
  • Assignment 3: May 5, 2020
  • Assignment 4a (Design of BrianAir project database; i.e., EER diagram and translation to relations): Apr. 24, 2020
    Note that this hand-in is required (with decent quality) for you to attend the mandatory teaching session about the BrianAir project.
  • Assignment 4b (Improved design of BrianAir project database): Apr. 30, 2020
    Note that an approval of this hand-in is required for you to start implementing the project in the fourth lab session.
  • Assignment 4c (Implementation): Examination date (check it here)
  • Assignment 4d (Urkund): Examination date
    To check for plagiarism the final project code (queries and stored procedures) should be emailed to the address olaf.hartig.liu@analys.urkund.se
    The code should be attached as a file coursecode_year_student1_student2.txt (e.g., TDDD12_2020_olaha37_jospe51.txt).

Groups that did not finish some assignment by the corresponding deadline can hand it in later. Then, the assignment will be corrected in connection with the next examination retake. However, this applies only to the two retakes immediately after the course ended. After that, the whole lab series must be redone.

Page responsible: Olaf Hartig
Last updated: 2020-10-25