After establishing the purpose of databases and Database Management Systems (DBMS), we focus on one of the most widely used methods for organizing data: the relational model. This approach provides a structured and logical way to store and manage information effectively.
In this chapter, you will learn the fundamental building blocks of relational databases. We will cover how data is structured within tables using columns (attributes) and rows (records). You will understand the importance of data types, the role of primary keys in ensuring uniqueness, and how foreign keys are used to create relationships between different tables. We will also briefly introduce the concept of normalization as a technique for designing efficient databases.
2.1 Organizing Data in Tables
2.2 Columns and Data Types
2.3 Rows as Records
2.4 Primary Keys for Unique Identification
2.5 Relationships Between Tables
2.6 Foreign Keys for Linking Tables
2.7 Introduction to Normalization Principles
© 2025 ApX Machine Learning