Chapter 1
IT Concepts and Terminology
Course: Comptia Tech Fc0 U71
Subject: Comptia Tech Fc0U71
Chapter: Data And Database Fundamentals
A database is a structured collection of data that is stored electronically and can be easily accessed, managed, and updated. Databases serve as the backbone of modern information systems, supporting everything from simple applications to complex enterprise systems.
1. Database Uses
Databases are foundational to information systems, enabling the storage, organization, retrieval, and analysis of data in a structured and scalable manner. They support mission-critical applications, from banking to healthcare to logistics, across the entire data lifecycle.
a. Create: Database Schema Design & Structure
Definition: The creation phase involves defining the structure (schema) of the database. This schema includes tables, columns (fields), data types, relationships, indexes, and constraints. It sets the foundation for all other database operations.
Key Concepts:
| Element | Description | | Tables | Represent entities or objects (e.g., Customers, Orders, Products) | | Fields (Columns) | Represent attributes (e.g., name, email, price) and are defined with data types | | Data Types | Define the kind of data (e.g., INTEGER, VARCHAR, DATE, BOOLEAN) | | Primary Key (PK) | A unique identifier for each row in a table | | Foreign Key (FK) | A field in one table that refers to the PK in another table (enforces relationships) | | Constraints | Rules such as NOT NULL, UNIQUE, CHECK, DEFAULT that preserve data integrity |