DataBase and Data Mining Group

Table of content

• Announcements
• Exams
• Weekly timetable
• Materials
• Exercises
• Written tests
• Practices
• Homework

General information

• ECTS: 8
• Professor: Tania Cerquitelli
• Assistant lecturer: Francesco Ventura

Announcements

• The written test scheduled on Sept 2nd, 2019 will take place today at 4:00 pm in room 3.
• The results of the written test taken on June 28th, 2019 are available (PDF)
• List of students who delivered the homeworks (List-Of-Students-HW1-4 PDF))
• Exam rules are available
• The lectures of May 28th and May 29th  have been cancelled
• The text of Homework no.3 is available. The deadline to submit it is June 10th, 2019
• Practice #6 corresponds to Homework #4 to be delivered by June 9th, 2019
• The text of Homework no.3 will be available soon.
• The text of Homework no.2 is available. The deadline to submit it is May 17th, 2019
• The second LAB practice has been scheduled for today (April 2nd, 2019).
• The text of Homework no.1 is available. The deadline to submit it is April 15th, 2019
• The lectures of March 26th and March 27 have been cancelled
• The first LAB practice will be on Tuesday, 19th March, at 2:30p.m. in the LabInf Laboratory (map)
  • Please make sure you have an account on the Labinf PCs before the lab practice (it is *not* the account you use to log in to the PCs in the other LAIB labs). You can register an account at Labinf every day from 2pm to 3pm (check the Labinf  website  for further details)
• A free PDF file of the book (Database Systems – Concepts, Languages and Architectures Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone McGraw-Hill) is available at http://dbbook.dia.uniroma3.it/

Exams

• Exam-Rules 
• WRITTEN TEST scheduled on 2019/06/28 h. 8:30 am. Students are assigned to the classrooms according to the following rules:
  • CLASSROOM 12 FROM ABED TO POGGIO
  • CLASSROOM 16 FROM PORCU TO ZONG
  • Results (PDF)

Weekly timetable

Materials

• Introduction to the course (2 slides per page)
• Introduction to the databases  (2 slides per page, 6 slides per page)
• Relational data model (2 slides per page, 6 slides per page)
• Relational algebra (2 slides per page, 6 slides per page)

• SQL language:

  • Basics (2 slides per page,6 slides per page)

  • The SELECT statement: basics (2 slides per page,6 slides per page)
  • Nested queries (2 slides per page,6 slides per page)
  • Set operators (2 slides per page, 6 slides per page)
  • Update commands (2 slides per page, 6 slides per page)
  • Managing tables (2 slides per page,6 slides per page)
• SQL language: other definitions
  • Management of views (2 slides per page,6 slides per page)
  • Transactions (2 slides per page,6 slides per page)
  • SQL for applications (2 slides per page, 6 slides per page)
  • Access control (2 slides per page, 6 slides per page)
  • Index management (2 slides per page,6 slides per page)
• Database design
  • Design techniques and models (1 slide per page)
  • Conceptual design (1 slide per page)
  • Logical design (1 slide per page)
  • Normalization (1 slide per page)
• Web programming
  • Client-server architectures (1 slide per page)
  • The HTML language (1 slide per page)
  • The PHP language (1 slide per page, lecture_examples)
  • SQL for PHP (1 slide per page)
  • Cascading Style Sheet (1 slide per page)
  • PHP practice (Artworks_text, Artwork_project)

Exercises

• Relational algebra and SQL I: Exercises  [Solutions: Algebra ]  [Solutions: SQL]
• Relational algebra II: Exercises 
• SQL no.2: Exercises  [Solutions]
• SQL no.3: Exercises   [Solutions]
• Relational Algebra and SQL no. 4: Exercises
• SQL no. 5: Exercises
• ER no.1: Text
• ER no.2: Text Draft solution]
• ER no.3: Text [Draft  solution]
• ER no. 4: Text
• ER no.5: Text
• ER no.6: Text [Draft Solution]
• ER no.7:  Text [Draft solution]

Written tests

• 2015 – 07 – 03
• 2015 – 07 – 17 
  •  Draft solution
• 2014 -07 -17
  • Algebra and SQL
  • ER 
• 2014 – 07 – 03  Draft solution
• 2014 01 23
  • Algebra and SQL Draft Solution
  • ER  – Draft solution
• 2013 – 05 – 24 – Draft solution
• Theory questions: Text

Practices

• Practice #1 (SQL queries on an Oracle database) 
  • Text
  • Screenshots of the expected result sets
  • Solutions for Practice #1
  • Note: For those students that decide to install Oracle or another DBMS on their personal laptop/PC, the database used during the first practice can be created by using the following SQL script (DB creation script). Please follow the installation guide to install Oracle Database and Oracle sql Developer on PC. The guide shows installation steps for both Mac and Windows operating systems, for the students who use Linux os, please read the instructions for Windows as a reference, the steps are similar.
• Practice #2 (SQL queries on an Oracle database)
  • Text
  • Screenshots of the expected result sets
  • Solutions for Practice #2
• Practice #3 (Database design and SQL queries on an Oracle/MySQL database)
  • Text
  • Solutions
• Practice #4 (PHP and SQL)
  • Text
  • ScriptsSQL
• Practice #5 (Web application in PHP to update data in a MySQL database)
  • Text
  • ScriptsSQL
• Practice #6 corresponds to Homework #4 to be delivered by June 9th, 2019
  • Text

Homework

Rules

To obtain the points associated with the home assignments, students must observe the following terms:

• Complete all the points of the exercises in the homework text.
• Prepare a file in PDF, DOC or ODT format with the solution of the homework.
• Name the file as HomeworkN_Surname_Name_StudentId.XXX, where
  • StudentId, Surname and Name should be replaced with student information
  • the N character following Homework should be replaced with the number of the submitted homework (e.g., ‘1’ for homework no. 1)
  • the filename extension XXX depends on the file type chosen for the submission (PDF, DOC or ODT).
  • the DOCX format is not supported.
  • Since uploaded files are automatically processed, naming the file with a wrong name implies the cancellation of the related homework submission.
• Load the file on the didactic portal (Portale della didattica) in the section Work Submission (Elaborati) before the deadline.
  • Multiple loadings for the same student and/or for the same homework are not allowed.
  • The upload date shown on the didactic portal is considered for the evaluation.
  • Since uploaded files are automatically processed, the upload after the deadline implies the cancellation of the related homework submission.
• During the upload procedure a description (“Descrizione”) field is required. Insert the same name given to the uploaded file (according to the rules described above).
• Only for students with no access to the course page on the didactic portal, the homework may be submitted before the deadline by sending an email to the assistant lecturer.
• Discuss the homework with a positive evaluation on the fixed date (announcement will be published).
• Homework #4 note: The delivery of the realized code must be done via upload on the portal as for the files of the previous homeworks. In this case, however, each student will have to upload a single .zip file containing the developed code. The archive must contain:
  • all .php and .html files created for the application
  • a single .sql script for creating the database with the SQL statements useful for creating and populating the database.

Homework texts

• [Homework #1] — to be delivered by April 15th, 2019 (UTC/GMT+1)
• [Homework #2] — to be delivered by May 17th, 2019 (UTC/GMT+1)
• [Homework #3] — to be delivered by June 10th, 2019 (UTC/GMT+1)
• Practice #6 corresponds to Homework #4 to be delivered by June 9th, 2019