SD202 - Créneau D

Slides:

• • Introduction, Databases, Relational Model

    • 1. • MOOC Videos: Introduction to Databases, The Relational Model, Querying Relational Databases, Relational Algebra I and Relational Algebra II.

• • SQL, Slides 

    • 1. • MOOC Videos: Introduction to SQL, Basic Select Statement, Table Variables, and Set Operators, Subqueries in Where Clause, Subqueries in From and Select Clauses, The Join Family of Operators, Aggregation, Null Values, Data Modification Statements.

• Functional Dependencies and Normal Forms

  • • MOOC Videos: Motivation and overview, Functional Dependencies, Boyce-Codd Normal Form.

• Views

  • • MOOC Videos:  Defining and Using Views, View Modifications Introduction, View Modifications using Triggers, Automatic View Modifications, Materialized Views.

• Entity-Relationship Model

  • •  MOOC Videos:  Entity-Relationship Diagrams.

Labs:

• Install Jupyter: Instructions

• Virtual environment – virtualenv-script.sh

• Or use Colab extension to open notebooks

• TP1 

  • SQL-Zoo 

    • From a TP room computer or your laptop connected to « Campus-Telecom » Wifi (not Eduroam)

    • Open http://137.194.211.221:8080/

    • Create your own account (user/password) by registering with ‘sd202tp’ (without quotes) registration key. This will enable you to save your work and retrieve it later

    • Do Exercise 1 and Exercise 2

  • Notebook, Submission (deadline 23/05/2023 at 11:59pm)

  • Only the notebook of FDs needs to be sent.

• TP2 

  • Notebook

  • Database: wine.db 

  • Submission (deadline: 06/06/2023 at 11:59pm)

• TP3

  • Notebook

  • Submission (deadline: 20/06/2023 at 11:59pm)

Announcements:

• URL link (a shareable link to Dropbox, drive, or other). Be sure that the link is open for reading.

• Exam: Documents on paper only are authorized without restrictions on the number of pages. Computers, calculators, phones, and any non-paper document are not allowed.

• Example exam