32
Chapter 3: Database Fundamentals
What is a relational database?
A
relational database
is a structured collection of information that is related to a particular subject
or purpose, such as an inventory database or a human resources database. You use databases to
manage information. Information, such as product name, cost, and on-hand inventory, is stored
in a database. Within the database, you organize the data into storage containers called tables.
Tables
are made up of columns and rows. Columns represent individual
fields
in a table. Rows
represent
records
of data in a table. You can think of database tables as grids, as in the following
example:
Each field in the table contains one piece of information. In an employee table, for example, one
column contains the employee name, another contains the employee phone number, and the
other columns each store one piece of information, such as the address, city, state, zip, and salary
information. Each record represents one set of related information. For example, an employee
table might store information about one employee per row. The number of rows in a table
represents the total number of table records.
Field (column)
Record
(row)
Summary of Contents for COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION...
Page 1: ...COLDFUSION MX7 Getting Started Building ColdFusion MX Applications...
Page 6: ...6 Contents...
Page 10: ......
Page 14: ...14 Chapter 1 Introducing ColdFusion MX...
Page 38: ...38 Chapter 3 Database Fundamentals...
Page 40: ......
Page 58: ...58 Chapter 5 Lesson 2 Configuring Your Development Environment...
Page 70: ...70 Chapter 6 Lesson 3 Retrieving Data...
Page 84: ...84 Chapter 7 Lesson 4 Building Dynamic Queries...
Page 96: ...96 Chapter 8 Lesson 5 Creating a Trip Detail Page...
Page 102: ...102 Chapter 9 Lesson 6 Creating a Main Application Page...