Hide menu

TDDE49 Databases and Information Security for Bioinformatics

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 (register no later than Sep. 1, 2023).

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 email to your lab assistant for assignments 1-3, to Ulf for assignment 4, and to Patrick for assignment 5.

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 assignment 5a). 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 (Basic SQL)

  • The objective of this assignment is to practice using basic features of the database language SQL, including the use of filtering conditions and joins.
  • Description
  • This lab assignment is based on an existing database and, thus, it is important that you import and study the database first.
  • Instructions for loading the database.
  • Deadline: Sep. 7, 2023 (soft deadline)

Assignment 2 (Database Design and EER Modeling)

  • The objective of this assignment is to practice designing a relational database for a given example domain by first creating a conceptual schema using the EER model and then translating this schema into a corresponding logical schema captured in the relational data model.
  • Description
  • Deadline: Sep. 14, 2023 (soft deadline)

Assignment 3 (Advanced SQL)

  • In this lab assignment you continue working with the database used for assignment 1. The objective of this assignment is to practice using more advanced features of the database language SQL, including the use of aggregations, grouping, and views.
  • Description
  • Deadline: Sep. 27, 2023 (soft deadline)

Assignment 4 (Information Security Modeling)

  • Description, hand in via email to Ulf
  • Deadline: Oct. 5, 2023 (soft deadline)

Assignment 5 (Project)

  • During the project part, you will solve a bioinformatics problem (subproject) by creating a relational database. Other students will solve other related problems. Towards the end, you will connect the databases in the various subprojects to a large database that can provide answers to complex questions.
  • The specific tasks can be found in the project description (in Swedish).
  • Teaching session about the project
  • Databases for the different subprojects and grouping of lab pairs
  • Information on how to connect the subproject databases (in Swedish)
  • The lab sessions that are scheduled for you to work on the project are without lab assistant. If you have questions, you can always send an email and/or book an appointment (this does not mean that Patrick / your teaching assistant is available immediately). For database modeling questions, contact Patrick; for questions related to the implementation or SQL queries contact your lab assistant.
  • The following deadlines are hard (meaning, it is mandatory to hand in by these deadlines):
    • Submission of the EER diagram: Sep. 26, 2023, hand in via email to Patrick
      (note that your EER diagrams will be reviewed in the mandatory teaching session on Sep. 28, 2023)
    • Demonstration of the project: Oct. 17, 2023

Page responsible: Olaf Hartig
Last updated: 2023-09-22