Messages
You can now access the assessment guide (the solution guide and the grading scheme) here.
The original question is: What is meant by P in task 5c - 2?
Answer: As stated in part 1 of the same question, P is the precedence graph.
You can use all resources, but make sure that you refer to the source correctly, that it is not only a copy-paste but that it reflects your understanding. Note also that we have no way of knowing who you are in the exam and whether you are taking the answer from your own work or from elsewhere. You will need to make sure that your answer demonstrates your understanding.
Request:
"let an operator * be canceling". What do you mean by canceling?
Answer:
As written in the question, an operator * is canceling if for every x we have x * x = x.
Thus, the notion of `canceling' is defined in this sentence for the purpose of this exam, it is not standard by any means.
Request:
One of the subqueries has
SELECT T1.A
FROM T1, T2
WHERE T1.A = T2.B AND T2.C > T.X
how can we compare T2.C > T.X when we have only T1 and T2 in the FROM clause?
Answer:
We have (briefly) considered this case in the course.
In this case, the value of X is taken from the main query (i.e., from the outside of the subquery).
We need
"the manager such that the number of managers who processed a greater number of orders in 2020 than this manager is the same as the number of managers who processed a smaller number of orders."
Each manager processed some number of orders in 2020.
So, for each manager M there are some managers M1 that processed more orders than M, and some managers M2 that processed less orders than M.
Manager M should be returned if the number of M1's is the same as the number of M2's.
Egor
If you have questions during the exam, send your questions either through Inspera to the administration (which will collect and forward them to us) or, if you wish, send them directly to us:
nacia@ifi.uio.no AND egork@ifi.uio.no
We will publish the answers on the course web page!
You can find last year's exam (exam from spring 2020) with suggested solutions & guidelines here in the same folder as other previous exams.
Written home exam in IN3020 – Database Systems
2021, SPRING SEMESTER
Duration: 4 hours, Wednesday 16th June 2021, from 09:00 AM to 13:00 PM
It is important that you read this cover page carefully before you start.
General information:
- Important messages during the exam are given directly from the course teacher on the course's semester page or in Canvas (if used in your course). It is therefore important that you check the course's semester page / Canvas room regularly.
- Your answer should reflect your own independent work and should be a result of your own learning and work effort.
- All sources of information are allowed for written home exams. If you reproduce a text from books, online articles, etc., a reference to these sources must be provided to avoid suspici...
MANDATORY ASSIGNMENT DUE DATE CHANGED to Sunday 9th May. It was published last weekend, which means that you have 2 weeks for the assignment.
--
A reminder: Remember that we have two mandatory assignments as announced in the introduction lecture. The first one is due Friday 12 March at 23:59 (extended, was due 5 March) and the other one due 30th April (now 7th May). Submissions should be made in Devilry. You will get the assignments about a week in advance. Please stay updated by checking these messages regularly.
Talkwall shows itself not very useful by various reasons, so we migrate to GitHub for discussions:
https://github.uio.no/IN3020-4020/Discussions
All students (registered for the course) should be able to login with the university account (if you have a problem, drop me an email to egork@ifi.uio.no). To ask a question, go to Issues tab and rise an issue. You may close it if you are happy with an answer.
UPD: we migrated to GitHub for discussions, so TalkWall is not monitored any more
---
I will still be looking into alternatives, but UiO has approved only Padlet, Mattermost and Talkwall. No discourse or Campuswire or Piazza. I know that Padlet and Mattermost are not the most popular, and I have never tried Talkwall. So let us try it :-)The link is
You join using the Talkwall PIN: 5837
The first task is “ASK US (140 chars max”). A bit tweet-like. You can use several 140-character posts, though.
We were planning to start becoming physical :-) or at least hybrid, but we will have to be digital for a while more. Watch this space for info.
Many have already asked whether the lectures will be recorded. Yes, we always record lectures and publish them in the correct row of the "Schedule" together with the slides.
PLEASE NOTE that all info here is also for IN4020 unless stated otherwise explicitly.