Concept

Data integrity

Related lectures (15)

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Computing: From 1 and 0 to Databases

Introduces computing basics, from logic gates to databases, emphasizing data integrity.

Relational Databases: Fundamentals

Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.

Transaction Management & Concurrency Control

Explores transaction management, concurrency control, ACID properties, anomalies, and conflict serializability in database systems.

Data-Intensive Systems: Relational Model and Algebra

Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.

Introduction to Database Systems

Covers the basics of database systems, including data modeling, DBMS, data independence, and the course overview.

Data Perturbation: Protecting Privacy in Database Systems

Explores data perturbation for privacy protection in database systems, including aggregate reconstruction and its application in data mining.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

Database Management Systems: Overview

Covers database management systems principles, design, implementation, and storage options like flat CSV files.

Data Management: Overview

Introduces fundamental concepts of data management, including data models, databases, and key tasks.

Data Wrangling: ETL Process and Wrangling Issues

Explores the ETL process, data wrangling stages, and common issues.

Understanding Data Models

Explores the significance of data models in scientific research and the challenges posed by big data.

Message Authentication Codes: Formalism

Explores message authentication codes and their formalism, with a focus on mobile telephony, covering topics like misuse attacks, security notions, and GSM architecture.

E-Voting: Research and Challenges

Explores e-voting research, digital algorithms, privacy challenges, and cryptographic methods in ensuring legitimacy and participation.