5.5. Components of Relational Databases and Technical Terms
A relational database consists of various components. In this section you will be guided through the most important terms that are often used when working with relational databases. Knowing the meaning of the most important words used in the database arena is important in order to understand the next few chapters of this book.
Tables and relations— Every database consists of fundamental components called relations. Relations are tables consisting of various lines and a fixed number of columns.
Primary keys— In order to identify a row of data, every table should have a column containing unique values. This column is called the primary key of a table. A column that is the primary key must ...
Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
