Lecture Log

Detailed list of the topics covered in each lecture (the log will be updated periodically during the course).

  • 18-09-2019
    Information resources in an organization. Information systems. Database and Database Management Systems. Data models and a brief introduction to the relational data models. Schemas vs instances. Standard three-level DBMS architecture. A brief introduction to SQL. Data manipulation language vs data definition language. DBMSs: advantages and disadvantages.
  • 19-09-2019
    The relational model. Relations in the relational model. Tables and relations. Incomplete information in the relational model. Integrity constraints. Domain constraints. Tuple constraints. Key constraints.
  • 25-09-2019
    Integrity constraints. Domain constraints. Tuple constraints. Key constraints. Keys and null values. Primary keys. Foreign keys. Exercises.
  • 26-09-2019
    The relational Algebra. Query languages for relational databases. Set operators (union, intersection,difference). Renaming. Cartesian product. Selection.
  • 02-10-2019
    Selection and Projection operators. Conditional join. Equi join. Natural Join. Left, Right, Full outer join. IN NULL and IS NOT NULL conditions. Examples of queries in relational algebra.
  • 03-10-2019
    ----
  • 09-10-2019
    Exercise on relational algebra
  • 10-10-2019
    Exercise on relational algebra
  • 16-10-2019
    Introduction to SQL. Structure of an SQL query. Algebraic interpretation of SQL queries. Use of the DISTINCT keyword. Attribute renaming.
  • 17-10-2019
    Table Alias in SQL. Predicate conjunction, disjunction, and negation. Complex logical expression. The LIKE operator. IS NULL and IS NOT NULL predicates. Exercises.
  • 23-10-2019
    Simple Join Query. Explicit Joins in SQL Exercises. Inner Join. Outer Join. ORDER BY. Aggregate operators. Group by. HAVING. Exercises.
  • 24-10-2019
    ----
  • 30-10-2019
    Set Operators in SQL. Nested queries. IN and NOT IN. Table definition in SQL. Table definition. User defined domains. Integrity constraints in SQL. Attribute constraints and table constraints.
  • 31-10-2019
    NOT NULL and DEFAULT. Keys and Primary Keys in SQL. Foreing Keys constraints in SQL. Data modification in SQL. How to create a database in the PostreSQL DBMS. Exercises.
  • 06-11-2019
    Insert, delete, and Update operations in SQL. Exercise on SQL queries
  • 07-11-2019
    Exercise on SQL queries
  • 13-11-2019
    Conceptual Design. The Entity Relationshipmodel. Entities, Entity Attributes, Relationships, Relationship Attributes.
  • 14-11-2019
    ISA Relationship. Generalizations. Cardinality constraints in ER. Exercises.
  • 20-11-2019
    ----
  • 21-11-2019
    Internal and external entity identifiers. Types of binary relationships. Documentation of ER schemas. Exercises.
  • 27-11-2019
    Exercise on conceptual design.
  • 28-11-2019
    Exercise on conceptual design.
  • 04-12-2019
    Logical design. Restructuring of the Entity-Relationship schema. Redundancy analysis. Elimination of multi-valued attributes. Elimination of ISA between entities. Elimination of generalizations. Selection of a primary identifier. Exercises.
  • 05-12-2019
    Introduction to the EU General Data Protection Regulation (GDPR). History of the GDPR. GDPR main actors, Data security in GDPR. Data protection by design and by default. Introduction to the GDPR Principles.
  • 11-12-2019
    GDPR Principles. Lawfulness, fairness, and transparency. Purpose limitation. Data minimization. Accuracy. Storage limitation. Integrity and confidentiality (security). Accountability.
  • 12-12-2019
    GDPR Privacy rights. GDPR impact over the information life cycle. GDPR Information Life Cycle. The fifth step in GDPR Information Life Cycle. Exam Simulation.
  • 18-12-2019
    Exam Simulation.