1 - Introduction to Databases, Types, and Applications — Topics & Learning Outcomes

Module Topics

What is a Database?

• Defining a Database — A database is an organized collection of structured information or data, stored electronically so it can be easily accessed, managed, and updated.
• Purpose of a Database — The primary purpose of a database is to provide a systematic way to store, retrieve, and manage large amounts of data efficiently.
• Data vs. Information — Understanding the difference between raw data and meaningful information is a foundational concept in database study.
• Key Vocabulary: Records, Fields, and Tables — Databases use specific terminology to describe how data is organized, and mastering this vocabulary is essential for understanding all database concepts.
• Databases vs. Spreadsheets — While spreadsheets and databases both store data, they serve different purposes and have distinct capabilities that make databases better suited for complex, large-scale data management.
• The Role of a Database Management System (DBMS) — A Database Management System, or DBMS, is the software layer that allows users and applications to interact with a database in a controlled and efficient way.

Relational Databases

• What Is a Relational Database? — A relational database is a type of database that organizes data into structured tables made up of rows and columns.
• Tables and Schema — The structure of a relational database is defined by its schema, which specifies how tables are organized and what data types each column holds.
• Primary Keys — A primary key is a column or set of columns that uniquely identifies each row within a table.
• Foreign Keys and Relationships — Foreign keys are columns in one table that reference the primary key of another table, creating a link between the two.
• Normalization — Normalization is the process of organizing a relational database to reduce data redundancy and improve data integrity.
• Querying with SQL — Relational databases are typically queried and managed using Structured Query Language (SQL), a standardized language for interacting with relational data.
• Common Relational Database Systems — Several widely used relational database management systems (RDBMS) implement these principles and are used across industries.

NoSQL Databases

• What Is a NoSQL Database? — NoSQL databases are non-relational data stores designed to handle a wide variety of data models beyond the traditional table-based structure of relational systems.
• Core NoSQL Data Models — NoSQL databases are not a single technology but a family of systems, each organized around a distinct data model suited to different use cases.
• Flexible Schema Design — One of the defining characteristics of NoSQL databases is their schema flexibility, allowing data structures to evolve without requiring costly migrations.
• Scalability and Performance Advantages — NoSQL databases are engineered to scale horizontally, distributing data across many servers to handle high volumes of reads and writes.
• When NoSQL Outperforms Relational Systems — NoSQL databases offer meaningful advantages in specific scenarios where relational databases struggle with flexibility, speed, or scale.
• Trade-offs and Limitations of NoSQL — While NoSQL databases offer significant benefits, they also come with trade-offs that must be carefully considered when selecting a database system.

Hierarchical Databases

• Tree-Based Structure — Hierarchical databases organize data in a tree-like structure, where each record is called a node and relationships branch downward from a single root.
• Parent-Child Relationships — The core mechanism of hierarchical databases is the parent-child link, which defines how records relate to one another within the tree.
• Historical Significance — Hierarchical databases were among the earliest formal database models, developed in the 1960s to manage large volumes of structured data on mainframe systems.
• Data Access and Navigation — Accessing data in a hierarchical database requires traversing the tree along predefined paths, starting from the root and moving toward the target node.
• Strengths of Hierarchical Databases — Hierarchical databases offer notable performance and simplicity advantages for certain types of structured, well-defined data relationships.
• Limitations of Hierarchical Databases — Despite their strengths, hierarchical databases have significant limitations that reduce their suitability for complex or flexible data relationships.

Comparing Database Types

• Structural Differences at a Glance — Relational, NoSQL, and hierarchical databases each organize data in fundamentally different ways, which drives nearly every trade-off between them.
• Schema Flexibility vs. Rigidity — One of the most practical trade-offs when choosing a database type is how strictly data must conform to a predefined structure.
• Query Power and Language — The ability to ask complex questions of stored data varies considerably across database types and is a key selection criterion.
• Scalability and Performance Trade-offs — How each database type scales under growing data volumes and user loads is a critical factor for modern application design.
• Data Integrity and Consistency — Guaranteeing that data remains accurate and consistent over time is handled very differently depending on the database type chosen.
• Ideal Use Cases for Each Type — Understanding which real-world scenarios each database type handles best is the most direct way to apply selection criteria in practice.
• Key Selection Criteria Summary — When comparing database types, decision-makers should evaluate a consistent set of criteria to make an informed and defensible choice.

Real-World Applications of Databases

• Databases in E-Commerce and Retail — E-commerce platforms rely heavily on databases to manage product catalogs, customer accounts, and transaction records in real time.
• Healthcare and Medical Records Management — Hospitals and healthcare providers use databases to store, retrieve, and manage patient records, treatment histories, and medical research data.
• Banking and Financial Services — The financial industry depends on databases to handle account management, transaction processing, and fraud detection at massive scale.
• Social Media and Content Platforms — Social media platforms use large-scale databases to store user-generated content, social connections, and engagement activity for billions of users.
• Education and Learning Management Systems — Educational institutions and online learning platforms use databases to manage student information, course content, and academic performance tracking.
• Government and Public Services — Government agencies use databases to manage citizen records, public services, and large-scale administrative functions efficiently and securely.
• Transportation and Logistics — Transportation companies and logistics providers use databases to coordinate vehicle fleets, shipment tracking, and supply chain operations globally.

Student Learning Outcomes

By the end of this module, students will be able to:

Course Outcomes (reference)