General Information
- Professor: Silvia Chiusano
- Teaching Assistant: Alessandro Fiori
Teaching Material
- Course introduction (slides)
- Database introduction (slides)
- Relational model (slides)
- SQL
- Relational database design
- Google Data Studio: Video tutorials available on youtube channel
- Business Intelligence
Exercises
SQL
- Exercises: JOIN (text)
- Exercises: GROUP BY (text and draft solution)
- Exercises: IN, NOT IN (text , draft solution)
Design of a relational database
- AirQ company, Research organization, Forniture store (exercise text)
- Beauty farm (exercise text)
- STEP Programme (exercise text, draft solution ER diagram)
Laboratory Material
Practice #1, Practice #2 (SQL queries on an Oracle database)
- DB script (sql)
- Installation guides, to work on the lab practices. We suggest to use Oracle APEX cloud service. We provide also the guide to install the oracle software on your PC. Follow one of the two guides below
- Practice #1: Text (pdf), draft solution (pdf)
- Practice #2: Text (pdf), draft solution (pdf)
Practice #3, Practice#4 (Google Data studio)
- Google Data Studio: Video tutorials available on youtube channel
- Practice #3: Text (pdf)
- Practice #4: Text (pdf)
Homework
- Homework presentation and time schedule (slides)
- Homework #1 (deadline June 5, 2022): exercise on database design (text) – exercise on SQL queries (text)
- Homework #2 (deadline June 7, 2022):
- Group list: available on Didactic Portal
- Proposed projects on database design:
- Each group will be assigned one of the proposed projects
- each group must send the ordered list of preferences for the proposed projects by 22-05-2022 to silvia.chiusano@polito.it
- One project will be assigned to each group by considering the arrival order of requests and preferences expressed
- From Monday 23-05-2022, lesson on room 5T at 10:00, groups can start working on the assigned project (step #1: database design)