IM101 MIDTERM LESSON3

Data Association

process of linking or relating data points from different sources, establish meaningful relationships

Entity Relationships

Foreign Keys

Joins

Associative Entities

Key Concepts of Data Association

Entity Relationships

Entities, in a database are associated through relationships such as one-to-one, one-to-many,

Foreign Keys

are used to associate data in different tables

Joins

combine data from different tables based on a related column, typically a foreign key.

Associative Entities

Sometimes, an association itself becomes an entity with attributes.

Data Relationships

A relationship in a database is a connection between two or more entities.

One-to-One (1:1)

One-to-Many (1:M)

Many-to-Many (M:M)

Many-to-One (M:1)

Types of Relationships

One-to-One (1:1)

Each entity instance is related to one instance of another entity.

One-to-Many (1:M)

One entity instance is related to many instances of another entity.

Many-to-Many (M:M)

Multiple instances of one entity are related to multiple instances of another entity.

Many-to-One (M:1)

This is essentially the reverse of a one-to-many relationship. Many records in one table correspond to a single record in another table. ▪ Example: A tab

Associations

Relationships between tables in a database are established through

Primary Key

A column or a combination of columns that uniquely identifies a record in a table.

Foreign Key

A column or a set of columns in one table that refers to the primary key in another table, establishing a relationship between the two tables.

Referential Integrity

A property of a database that ensures that relationships between tables remain consistent.

Prevents orphan records and ensures data consistency.

Importance of Referential Integrity 

Enforcement

Most DBMS enforce referential integrity through constraints that restrict certain actions, like deleting a record that is referenced by another table.

E-Commerce System

University Database

Banking System

Examples of Data Associations in Real-World Scenarios

Customers and Orders

E-Commerce System

Students and Courses

University Database

Customers and Accounts

Banking System

Data Semantics

meaning and interpretation of data within a specific context.

Metadata

describes the structure, attributes, and constraints of the data, providing a higher-level understanding of what the data represents.

Data Constraints

These are rules that enforce the correct interpretation of data.

Ontologies

define a set of concepts and categories in a subject area or domain that show their properties and relationships.

Data Models

represent the semantic structure of the data.

Consistency

Accuracy

Relevance

Importance of Data Semantics in Database Systems

Consistency

Ensures that data is consistent

Accuracy

Data semantics helps in preventing errors

Relevance

Ensures that data is relevant

Data Integrity

The accuracy and consistency of data over its lifecycle.

Entity Integrity

Referential Integrity

Domain Integrity

Types of Data Integrity

Entity Integrity

Ensures that each entity has a unique identifier (primary key), and no duplicates exist.

Referential Integrity

Ensures relationships between tables are consistent

Domain Integrity

Ensures that data entered into a field falls within a specific range or set of values.

Constraints

Rules applied to data fields to enforce data integrity.

NOT NULL

UNIQUE

CHECK

DEFAULT

Constraints Types

NOT NULL

Ensures a field cannot be left empty.

UNIQUE

Ensures all values in a field are unique.

CHECK

Enforces specific rules for a field

DEFAULT

Sets a default value for a field if no value is provided.

Data Validation

Implementing checks and rules to ensure that data entered into the database is accurate and relevant.

Data Normalization

Structuring data in a way that reduces redundancy and ensures consistency. This involves organizing tables and relationships to streamline data storage and retrieval.

Data Governance

Establishing policies and procedures that define how data should be managed, stored, and used.

Efficiency

Accuracy

Data Integrity

Meaningful Insights

Importance of Data Association and Data Semantics in Databases

Efficiency

Data association optimizes how data is stored, retrieved, and linked, improving the performance of queries.

Accuracy

Data semantics ensure that the data is correctly interpreted, reducing errors in processing and analysis.

Data Integrity

Together, association and semantics maintain the consistency, relevance, and integrity of the data within a system.

Meaningful Insights

They enable more powerful data analysis by allowing the system to understand relationships and meanings within the data.

Business Analytics

Healthcare

Artificial Intelligence:

Applications:

Business Analytics

Companies use data association and semantics to correlate sales data with customer demographics and purchasing behavior, providing actionable insights.

Healthcare

In medical databases, patient records are associated with tests, diagnoses, and treatments, while semantics ensure that each data point is interpreted in the right medical context.

Artificial Intelligence

Data semantics are essential in training machine learning models to understand and process data meaningfully, while associations help build relationships between features for predictive analysis.