TDDD37 Database Technology
Examination
The course has the following examination items:
LAB1 3 ECTS
TEN1 3 ECTS
Structure and organization of the written exam
The exam is a closed-book sit-in exam written on campus, by each student individually, where "closed-book" means that no aids are allowed.
The exam consists of a total of eight questions that are grouped into two groups as follows:
- Group of practical topics
Question 1: Data modeling with an EER Diagram
Question 2: EER diagram and Relational Schema
Question 3: SQL - Group of theoretical topics
Question 4: Functional Dependencies and Normalization
Question 5: Data Structures
Question 6: Transactions and Concurrency Control
Question 7: Database Recovery
Question 8: Query Processing
For each of the two groups of questions, you can get a maximum of 15 points (i.e., 30 points max for the complete exam). To pass the exam you need at least 7.5 points for the first group (Questions 1-3) and, additionally, at least 7.5 points for the second group (Questions 4-8).
Relevant links and material
- Find the dates for the written exams (TEN1)
- Download a complete old exam
- This is the format of how the usual on-campus exams look like.
- No need to ask, I don't have example solutions for the questions in this exam
- Similarly, if you find any other old exams (other than the ones in the points below), I don't have a written-down version of example solutions because, for grading the exams, I don't need the correct solutions in a written form. -
A complete old exam:
part 1,
part 2,
example solutions and grading remarks
(these documents are accessible only to people at LiU)
Do you wonder why the exam consists of two parts? That's how the distance-mode exams during the Covid-19 pandemic were split up.
Attention: While I am provide solutions here, I strongly suggest you look at these solutions only after you have solved the exam questions yourself. - Additionally, here is a collection of exercises (including solutions) from old exams, and we have a frequently-asked-questions (FAQ) document for these old exam exercises.
Rules for examination of computer lab assignments at IDA
You are expected to do lab assignments in group or individually, as instructed for a course. However, examination is always based on individual performance.
It is not allowed to hand in solutions copied from other students, or from elsewhere, even if you make changes to the solutions. If there is suspicion of such, or any other form of cheating, teachers are obliged to report it to the University Disciplinary Board.
Be prepared to answer questions about details in specific code and its connection to theory. You may also be asked to explain why you have chosen a specific solution. This applies to all group members.
If you foresee problems meeting a deadline, contact your teacher. You can then get some help and maybe the deadline can be set to a later date. It is always better to discuss problems, instead of, e.g., to cheat.
Any kind of academic dishonesty, such as cheating (e.g., plagiarism, use of unauthorized assistance, and use of prohibited AI-based assistants) and failure to comply with university examination rules, may result in the filing of a complaint to the University Disciplinary Board. The potential penalties include suspension, warning.
Policy for handing in computer lab assignments at IDA
For all IDA courses having computer lab assignments there will be one deadline during or at the end of the course. If you fail to make the deadline, you must retake the, possibly new, lab course the next time the course is given.
If a course deviates from this policy, information will be given on the course web pages.
Page responsible: Olaf Hartig
Last updated: 2017-01-11