Database Structure

A database is essentially an electronic filing system that houses a collection of information organized in such a way that allows a computer program to quickly find desired pieces of data.

In the simplest form, a database is composed of tables, columns (called fields), and rows (called records or data). A classic example of a database is a telephone book, which is organized alphabetically so as to make it possible to quickly find a desired piece of data. The telephone book can be considered a table, a storage container for information (see Figure 3.1). Within this table is typically found three columns (or fields)—name, address, and telephone number. Within each of these fields exists rows (or records), the simplest form of ...

Get Sams Teach Yourself SAP™ in 24 Hours, Second Edition 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.