Introduction to Databases


This page has hierarchy - Parent page: Teaching

Table of content

General information

Announcements

  • 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

Weekly timetable

Type Day of the week Time Classroom
Lecture Tuesday 11:30-14:30 2D
Lecture Wednesday 11:30-14:30 2T
Lab Tuesday 14:30-16:00 LabInf
Lab Tuesday 16:00-17:30 LabInf

Materials

Exercises

Practices

Group of Students Day of the week Time Classroom
TEAM A: ABED — JOUGLET Tuesday 14:30-16:00 LabInf
TEAM B: KALEEM ULLAH — ZONG Tuesday 16:00-17:30 LabInf

 

  • Practice #1 (SQL queries on an Oracle database) 
    • Text
    • Screenshots of the expected result sets
    • 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.

Homework