# DidaWiki

### Strumenti Sito

bdd-infuma:start

Questa è una vecchia versione del documento!

# Teacher

Anna Monreale

• KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa

# EXAM

• Project to be delivered by email within 15 May 2020: First Part of the project.
• Note that in the last page of the project description the student can find the instructions to be followed for the delivery.

# Learning Material

• Slides
• Databases essentials - Antonio Albano PDF File
• A First Course in Database Systems, JefferyD. Ullman and Jennifer Widom
• Decision Support Databases Essentials - Antonio Albano PDF File

# Class Calendar 2020

Day Topic Learning material Book
1. 17.02.2020 14:00-18:00 Introduction – Relational Model Conceptual modeling a.introduction.pdf b.modellorelazionale.pdf c.conceptualmodel.pdf Model of University DBExercises Conceptual Modelling DB Essentials
2. 24.02.2020 14:00-18:00 Logical Modeling - Exercises on Conceptual & Logical Modeling c.logicalmodel.pdf conceptual_logicalmodel-companies.jpeg logicalmodel-university.jpegDB Essentials
3. 10.03.2020 14:00-18:00 Exercises on Conceptual & Logical Modeling. SQL exmodelling-10march.pdfe.sql-concettibase.pdf DB Essentials
4. 23.03.2020 14:00-18:00 Exercises on SQL + Advances SQL & Exercises text-ex-sql.pdf assignment-23-03.pdf sol-exsql.zipDB Essentials
5. 27.03.2020 09:00-13:00 Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling 3-sol-market-queries.sql.zip f.dwconcept.pdf Do Exercises in Appendix A of this book BOOK: Decision Support Databases Essentials
6. 30.03.2020 14:00-18:00 Data Warehouses Logical Modeling - Exercises on DW models dwlogical.pdf https://meet.google.com/dcy-dqvb-eub The lecture will start at 14:10
7. 02.04.2020 14:00-18:00 Exercises on DW models + olap - sql reporting
8. 06.04.2020 14:00-18:00 Querying DW
9. 07.04.2020 14:00-18:00 Exercises on Querying DW
bdd-infuma/start.1585663495.txt.gz · Ultima modifica: 31/03/2020 alle 14:04 (4 anni fa) da Anna Monreale