SQLConfiguration SQLConfiguration


Database Concepts  «Prev 

Collection Information Stored

Database Table

CustNo, LName, FName, ADDR1, ADDR2

  1. This image shows a portion of a customer database. Each row in the table represents a single record, which contains specific information for each customer.
  2. Each table column contains a specific record field. Every piece of information for each customer is stored in the individual fields. The information contained in this database includes the customer number [CustNo], last name [LName], first name [FName], address [ADDR1], and more, which is not visible in this image.
  3. The Customer Number is used to uniquely identify each record and is called a "unique key."