Data Science and Database Technology

Table of content

General information

 

Announcements


Exams


Material

Part I

 

Oracle
  1. Extended SQL (2 slides per page, 6 slides per page)

Part II


Exercises

Data warehouse

 

Exercise  Text Draft solution
Extended SQL (Customer ) text Draft solution
Extended SQL (Rental ) text Draft solution
Data warehouse design (Italian household) exercise Draft solution Remark: Write all queries from (a) to (f)
Data warehouse design (SearchingYourHouse) exercise DraftSolutioSearchingYourHouse
Data warehouse design (Hotel chain) exercise Draft solution
Data warehouse design (Parcels service) exercise

 

Triggers

Exercise Text Draft solution
Exercise 1 (Athlete) exercise Draft solution
Exercise 2 (Greenhouse) exercise Draft solution
Exercise 3 (Student grant) exercise Draft solution
Exercise 4 (Boat rental) exercise

 

Optimizer

 

Exercise  Text Draft solution
Exercise 1 (Fine) 2 slides per page 6 slides per page
Exercise 2 (Students, Projects) 2 slides per page 6 slides per page
Exercise 3 (Discs) exercise
Exercise 4 (Athletes, Members) 2 slides per page 6 slides per page
Exercise 5 (Actors) exercise

 


Tutoring and homework verification

 

 

 

 


Practices

 

Topic Team A Team B Lab Assistance
Practice #1: Extended SQL in Oracle  24/10/2018  25/10/2018 assistant lecturer + scholarship holder
Additional optional lab for students who have not completed Practice #1 31/10/2018  25/10/2018 scholarship holder
Practice #2: Data warehousing  7/11/2018  8/11/2018 assistant lecturer + scholarship holder
Practice #3: Data mining with Rapidminer 14/11/2018 15/11/2018 assistant lecturer + scholarship holder
Lab for Homework #2 on data mining with Rapidminer 21/11/2018 22/11/2018 scholarship holder
Practice #4: Oracle triggers 28/11/2018 29/11/2018 assistant lecturer + scholarship holder
Lab for Homework #3 on triggers in Oracle 5/12/2018 6/12/2018 scholarship holder
Practice #5: Oracle optimizer  19/12/2018  20/12/2018 assistant lecturer + scholarship holder

 

 

LAB SCHEDULE. To fit LabInf capacity students must attend all the course labs according to the following schedule (students are sorted in alphabetic order by surname):

The compliance to the schedule above is necessary to guarantee the feasibility of the lab.

LAB ACCOUNT. Please make sure to have an account on the LABINF PCs before the beginning of the lab practice (the accounts used to log in to the PCs of the other LAIBs are *not* valid). To register an account at LABINF, please visit the Labinf  website for further information.

 

Lab 1: Extended SQL

 

Lab 2: Data-warehouse analytics and reporting with Google Data Studio

 

Lab 3: Data mining – Rapid Miner  

Lab 4: Triggers

 


Homework to be delivered

 

To obtain the points associated with the homeworks, students have to observe the following terms:

Homework discussion: Students attending the written exam must bring the following items:

 

 

Homework Material Deadline Homework deliveries
Homework #1: Data warehouse HW text (pdf) to be delivered by Monday, November 12th, 2018 at 11.59 PM (UTC/GMT+1)
Homework #2: Data Mining HW text (pdf) – Dataset (breast.xls) to be delivered by Monday, November 26th, 2018 at 11.59 PM (UTC/GMT+1)
Homework #3: Triggers HW text (pdf) –  scripts. to be delivered by Monday, December 10th, 2018 at 11.59 PM (UTC/GMT+1)

 

 


 Parent page 

 Menu 

 © 2018 - DataBase and Data Mining Group