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: Jacopo Fior

Announcements

• The relation algebra exercises for the Lecture on April 1, 2020 are available (here)
• The text of Homework no.1 is available. The deadline to submit it is April 17th, 2020
• The SQL exercises for the Lecture on March 31, 2020, are available (set1, set2)
• The SQL exercises for the Lecture on March 25, 2020, are available (here)
• The relation algebra exercises for the Lecture on March 17, 2020 are available (here)
• The relation algebra exercises for the Lecture on March 17, 2020 are available (here)

Exams

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]
  

  Written tests

  Practices

  The laboratory practices will begin on Tuesday, April 7.

  Group of Students	Day of the week	Time	Classroom
  TEAM A: Student ID <= 258133	Tuesday	14:30-16:00	Virtual Classroom
  TEAM B: Student ID >= 258157	Tuesday	16:00-17:30	Virtual Classroom

  • Installation guides, to work on the lab practices you can use oracle directly on your PC or online through Oracle APEX. Follow one of the two guides below:
    • Installing Oracle Database and Oracle sql Developer on PC
    • Using Oracle APEX online
  • Practice #1 (SQL queries on an Oracle database) 
    • Text
    • Screenshots of the expected result sets
    • Solutions
    • DB creation script

   

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 texts

• [Homework #1] — to be delivered by April 17th, 2020 (UTC/GMT+1)