Aperçu des sections
-
For your first lab session, you will learn about the SQL language by writing some queries on two exercises.
-
This lab requires that you have access to the database. These logins will be distributed at the beginning of the lab. If you are working from home send an email to Louis Jachiet to get a login and password.
-
-
When creating the basic schema (Step 4), if you do not have access to the SQLite prompt, you can instead run this code.
It will remove the file univ.db if it already exists, create a new one and create tables according to the SQL commands you wrote in schema.sql. This should create the schema you designed into the DB.
-
The exam for the SD202 class, which constitutes 100% of your final grade, will take place on Friday, October 28, from 13:30 to 15:30. It will cover all material that we covered together in classes and lab sessions. The exam will be in English. You can choose to answer the questions in English or in French, as you prefer.
You are allowed three A4 paper sheets (i.e., 6 pages, one on each side) with personal notes of your choice (handwritten or otherwise). Any other material or document is forbidden.
The exam is strictly personal: any communication or influence between students, or use of outside help, is prohibited. No electronic devices such as calculators, computers, or mobile phones, are permitted. Any violation of the rules may result in a grade of 0 and/or disciplinary action.
Here are some example exams from the previous years; some of them are in French. Please note that the format of the class has changed from 2021-2022 onwards. Some notions (e.g., relational algebra, 3NF) were only covered in 2020-2021 and before, so will no longer be required. Further, the exam modalities are the ones indicated above and not the ones indicated on these old exams.