Databases Overview
Core Concepts of Databases Explained Clearly
Introduction
This presentation covers the essential concepts behind
databases, including their fundamental purpose and structure.
Understanding these basics is crucial for designing, using, and
managing effective database systems in any corporate setting.
Key topics include definitions, components, and the role of
databases in modern data management.
01
Database Fundamentals
Definition and Purpose
A database is an organized collection of data that allows efficient
storage, retrieval, and management of information. Its primary
purpose is to support operations, decision-making, and data
analysis in businesses through structured data storage and
controlled access, ensuring data integrity and security.
Components of a Database System
Key components include the Database Management System (DBMS), which
handles data operations; the database schema defining structure; data
stored in tables or other formats; and users who interact with the system
through interfaces and queries, facilitating seamless data management
and utilization.
Types of Databases
Databases can be categorized based on their structure and purpose. Common types include Relational
Databases which use tables and SQL, NoSQL Databases designed for unstructured data, and Distributed
Databases that spread data across multiple locations. Each type serves different business needs,
optimizing performance, scalability, and flexibility.
02
Database
Relationship Types
One-to-One Relationships and Symbolism
A one-to-one relationship (1:1) in a database has one record on each side of the relationship. Every primary key relates to at
most one entry from another table, making the foreign key unique.
One-to-one relationships appear from enforced business rules and are not typical. Combining two tables with a one-to-one
relationship does not break normalization rules.
Example:
A simple example to demonstrate a one-to-one relationship is with capital cities. One country (or state) has only one capital city,
and one capital city belongs to only one country (or state).
Two tables with information about countries and capital cities connect in a database using a primary key. For example, when
added to the country table, the unique ID of a capital city (its primary key) becomes a foreign key, creating a relationship.
One-to-Many Relationships and Symbolism
A One-to-Many relationship links one record from a primary table to multiple records in a related table. Symbolized by a line
ending in 1 on one side and a crow’s foot on the other, it is the most common type, representing hierarchical or parent-child data
relationships.
An example of a one-to-many relationship is the connection between a mother and children. A mother can have many kids, but
every child belongs to one mother only.
A database containing two tables with information about mothers and children connects using a primary key. When added to the
child table, the unique ID from a mother becomes a foreign key. Different children can have the same mother.
Many-to-Many Relationships and Symbolism
Many-to-Many relationships connect multiple records from one table to multiple records in another. It is symbolized by
crow’s feet at both ends of the connecting line. This requires an intermediary joining table to efficiently establish these
links in the database.
Example
A many-to-many relationship exists between books and authors. For example, a single book can have multiple authors. Likewise,
a single author can have numerous books.
If there is a table containing books and another with authors, the best way to establish the relationship between the two is
through a new table. The new table has foreign keys from both parent tables, creating a many-to-many relationship.
Conclusions
Understanding different database types and relationship models
is vital for effective data architecture. Properly identifying and
implementing relationship types ensures data integrity and
optimizes database performance. These foundations empower
businesses to leverage data as a strategic resource for decision-
making and growth.
The symbols combine to form complex relationship types.