Lecture Log

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

  • 07-10-2021 (Thursday)
    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.
    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.
  • 14-10-2021 (Thursday)
    Integrity constraints. Domain constraints. Tuple constraints. Key constraints. Keys and null values. Primary keys. Foreign keys. Exercises. The relational Algebra. Query languages for relational databases. Set operators (union, intersection,difference). Renaming. Cartesian product. Selection and Projection operators. Conditional join. Equi join. Natural Join.
  • 21-10-2021 (Thursday)
    ---
  • 28-10-2020 (Thursday)
    Set operators (union, intersection,difference). Renaming. Cartesian product. Selection and Projection operators. Conditional join. Equi join. Natural Join. Left, Right, Full outer join. IS NULL and IS NOT NULL conditions. Examples of queries in relational algebra. Exercises
  • 04-11-2021 (Thursday)
    Exercise on relational algebra.
  • 11-11-2021 (Thursday)
    Introduction to SQL. Structure of an SQL query. Algebraic interpretation of SQL queries. Use of the DISTINCT keyword. Attribute renaming. Table Alias in SQL. Predicate conjunction, disjunction, and negation. Complex logical expression. The LIKE operator. IS NULL and IS NOT NULL predicates.
  • 18-11-2021 (Thursday)
    Recap on Simple Join Query in SQL. Explicit Join in SQL (Inner Join and Outer Join). ORDER BY. Aggregate operators. Group by. HAVING. Set Operators in SQL. Nested queries (Any, All, (Not)In, (Not)Exists).
  • 19-11-2021 (Friday)
    Table definition in SQL. User defined domains. Integrity constraints in SQL. Attribute constraints and table constraints. NOT NULL and DEFAULT. Keys and Primary Keys in SQL. Foreing Keys constraints in SQL. Data modification in SQL. Insert, delete, and Update operations in SQL. How to install the DBMS PostgreSQL. How to create a database in the PostreSQL DBMS. Exercises on SQL.
  • 24-11-2021 (Thursday)
    Exercise on SQL queries. Conceptual Design. The Entity-Relationship model. Entities, Entity Attributes, Relationships, Relationship Attributes.
  • 02-12-2021 (Thursday)
    Recap on Entity-Relationship model. ISA Relationship between entities. Generalizations (Complete and Not complete). Integrity constraints in ER. Cardinality constraints on relationships. Cardinality constraints on attributes.
  • 09-12-2021 (Thursday)
    Entity identifiers (Internal and External). Types of binary relationships. Documentation of ER schemas - Business rules. Exercise on conceptual design. Logical design. Restructuring of the Entity-Relationship schema. Redundancy analysis. Elimination of multi-valued attributes. Elimination of ISA between entities. Elimination of generalizations.
  • 16-12-2021 (Thursday)
    Recap on restructuring phase of the Entity-Relationship schema. Selection of a primary identifier. Translation of the restructured ER schema into a relational model. Translation of an entity. Translation of a many-to-many relationship. Translation of n-ary relationships. Translation of a one-to-many relationships. Translation of a one-to-one relationship. Exercises.