Clarification of Database-Related Terms
Now that you understand what a database is, I must clarify some important database terms for you. In the SQL world (you will learn about SQL in depth in Chapter 6, “Introducing SQL”), this collection of data is called a table. The individual records in a table are called rows, and the fields that make up the rows are called columns. A collection of tables is called a database.
Picture a filing cabinet. The cabinet houses drawers, each of which contains groups of data. The cabinet is a way to keep related but dissimilar information in one place. Each cabinet drawer contains a set of records. One drawer might contain employee records, and another drawer might contain sales records. The individual records ...
Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started 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.
