Hide menu

TDDD37 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 (yes, we want you to work in pairs on these assignments).

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 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.

For the time being, it is not permitted to use AI-based assistants such as ChatGPT for solving any of the assignments.

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

Dates

Groups that did not finish some assignment by the corresponding deadline can hand it in later (except for the two mandatory ones, 4a and 4b). 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.

Assignment 1 (Database design and EER modeling)

Assignment 2 (SQL queries and views)

Assignment 3 (FDs and normalization)

  • Description
  • Deadline: Dec. 12, 2023 (note that this is after the first two deadlines for assignment 4!) (soft deadline)

Assignment 4 (BrianAir project)

  • Description
  • MySQL scripts to test your implementation
  • Deadlines: see above under dates
  • Assignment 4a (Design of BrianAir project database; i.e., EER diagram and translation to relations): Nov. 27, 2023 (note that this is before the deadline for assignment 3!)
    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): Dec. 1, 2023 (note that this is before the deadline for assignment 3!)
    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
  • Assignment 4d (Urkund): Examination date
    The final project report (SQL code and text answers to additional questions, but not the diagrams) have to be emailed to the address olaf.hartig.liu@analys.urkund.se to have it checked for plagiarism. In that email, the report code should be attached as a file with a filename of the form: coursecode_year_student1_student2.txt (e.g., TDDD37_2023_olaha37_jospe51.txt).

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