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 (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
- Registration: register in Webreg with your lab partner no later than Apr. 8, 2025
- Apr. 11, 2025: Assignment 1, soft deadline
- Apr. 29, 2025: Assignment 2, soft deadline
- May 2, 2025: Assignment 4a (design of BrianAir project DB), hard deadline
- May 6, 2025: Assignment 4b (improved design of BrianAir DB), hard deadline
- May 16, 2025: Assignment 3, soft deadline
- Examination date: Assignment 4c (implementation and report about BrianAir DB), hard deadline
- After approval of 4c: Assignment 4d (Urkund)
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)
- Description
- Deadline: Apr. 11, 2025 (soft deadline)
Assignment 2 (SQL queries and views)
- Description
- This lab assignment is based on an existing database and, thus, it is important that you study the database first.
- Instructions for loading the database
- Deadline: Apr. 29, 2025 (soft deadline)
Assignment 3 (FDs and normalization)
- Description
- Deadline: May 16, 2025 (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):
May 2, 2025 (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):
May 6, 2025 (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): after approval of 4c
Once your project report for Assignment 4c has been approved by your lab assistant, email your final project report (SQL code and text answers to additional questions, but not the diagrams) 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., TDDD12_2025_olaha37_jospe51.txt).
Page responsible: Olaf Hartig
Last updated: 2020-10-25