Data Management

Last updated on FiTS Steve Jobs, 2017-18

Table of Contents

Summary

The course of Data Management [Unit 1] is part of the Course 6 ITS of the Fondazione Istituto Tecnico Superiore (FiTS) Steve Jobs, held in Caltagirone, Italy.

I taught this course in the A.Y. 2017\18.

Syllabus

  • Introduction to Data Management
    • Introduction to Information Theory
    • Databases and Database Management Systems (DBMSs)
    • Data Models
    • Languages and users
    • Advantages and disadvantages of DBMSs
  • The Relational Model
    • Definitions of Relation
    • Distinction between n-uple and tuple
    • Value-based Data Models
    • Definitions of Schemes and Instances
    • NULL values
    • Integrity constraints
  • Relational Algebra
    • Union, intersection, difference
    • Renaming, Selection, Projection, Join
    • Queries in relational algebra
    • Equivalence of algebraic expressions
    • Algebra with NULL values
    • Views
  • Design techniques and models
    • The database design process
    • The life cycle of information systems
    • Methodologies for database design
  • The Entity-Relationship model
    • The basic constructs of the model
    • Other constructs of the model
    • Final overview of the E-R model
  • Conceptual design
    • Quality of a conceptual schema
  • Logical design
    • Main phases of logical design
    • Restructuring of E-R schemas
    • Translation into the relational model
  • SQL
    • Data Definition Language (DDL)
    • Data Manipulation Language (DML)
    • Data Query Language (DQL)

Teaching Material

The available Teaching Material may contain errors. It does not substitute any educational book. It should be used only as a support material during the learning process. Please, report any error by e-mail.

Last updated on 7 February, 2018. Teaching material is available in English, under request.

MySQL Online Documentation

  • MySQL 5.7 official documentation is available online through this LINK
  • A SQL unofficial documentation is available online on w3schools
  • A SQL unofficial documentation is available online on tutorialspoint

Suggested Readings

  • Ceri, S., Atzeni, P., Paraboschi, S., & Torlone, R. (2009). Basi di dati: Modelli e linguaggi di interrogazione (III ed.) McGraw Hill.

    Chapter indexing in this suggested book is valid only for the referred edition (the III). Other editions may have different chapter indexing. Chapter titles may be more reliable through different editions.

    • Chapter 1 - Introduction
    • Chapter 2 - The Relational Model
    • Chapter 3 - Relational Algebra
      • 3.1 Relational algebra
        • 3.1.1 Union, intersection, difference
        • 3.1.2 Renaming
        • 3.1.3 Selection
        • 3.1.4 Projection
        • 3.1.5 Join
        • 3.1.6 Queries in relational algebra
        • 3.1.7 Equivalence of algebraic expressions
          • 1, 2, 3, 6, 7, 8
        • 3.1.8 Algebra with null values
        • 3.1.9 Views
    • Chapter 4 - SQL
      • 4.1 SQL language and standard
      • 4.2 Data definition in SQL
        • 4.2.1 Elementary domains
        • 4.2.3 Table definition
        • 4.2.6 Intra-relational constraints
        • 4.2.7 Inter-relational constraints
    • Chapter 7 - Design techniques and models
      • 7.1 The database design process
      • 7.2 The Entity-Relationship model
    • Chapter 8 - Conceptual design
      • 8.4 Quality of a conceptual schema
    • Chapter 9 - Logical design
      • 9.1 Main phases of logical design
      • 9.3 Restructuring of E-R schemas
      • 9.4 Translation into the relational model
        • 9.4.1 Entities and many-to-many relationships
        • 9.4.2 One-to-many relationships
        • 9.4.3 Entities with external identifiers
        • 9.4.4 One-to-one relationships
        • 9.4.5 Translation of a complex schema
    • Exercises + Solutions are available online through this LINK

Related