Databases and Web

• c. 21019
• Relational Algebra, Tuple Relational Calculus, Datalog
• SQL
• Conceptual and Logical Database modeling

Please use your student email account to send emails to dario.facchinetti@unibg.it.

Relational Algebra, Tuple Relational Calculus, and Datalog

• Slides
• Notes
• Solutions

Datalog execises, Introduction to SQL, SQL exercises

• Slides
• Notes
• Solutions
• SQLiteDB example

More SQL with sqlite3

• Slides
• App example

Conceptual and logical database modeling - pt1

• Slides
• Notes
• Conceptual and logical modeling (1st example)

Conceptual and logical database modeling - pt2

• Slides
• Conceptual and logical modeling (1st example)
• Conceptual and logical modeling (2nd example)

Exe 6

• 20160419-CL
• 20170608-C

Exe 7

• Ex1-C
• Ex1-L
• Ex2-C
• Ex2-L

Exe 8

• 20100621-C
• 20100621-L
• 20100630-C
• 20100630-L

Exe 9

• Ex3-C
• Ex3-L
• Ex4-C
• Ex4-L
• Ex5-C
• Ex5-L

Archive: past exams

• 20160419-C, 20160419-L, 20170420-L, 20170608-C, 20180419-L

• 2004, 2012, 2013, 2014, 2015, 2018, 2019

Schedule

• Exe 1: 29/03/2022
• Exe 2: 06/04/2022
• Exe 3: 07/04/2022
• Exe 4: 03/05/2022 - Tutor Matthew Rossi
• Exe 5: 05/05/2022 - Tutor Matthew Rossi
• Exe 6: 10/05/2022 - Tutor Matthew Rossi
• Exe 7: 12/05/2022 - Tutor Gianluca Oldani
• Exe 8: 17/05/2022 - Tutor Gianluca Oldani
• Exe 9: 24/05/2022 - Tutor Gianluca Oldani

The documents gathered in this web page have been provided by the contributing authors as a means to ensure timely dissemination of scholarly and technical work on a noncommercial basis. Copyright and all rights therein are maintained by the authors or by other copyright holders, notwithstanding that they have offered their works here electronically. It is understood that all persons copying this information will adhere to the terms and constraints invoked by each author's copyright. These works may not be reposted without the explicit permission of the copyright holder.