SAMS Teach Yourself ASP.NET in 24 Hours

Summary

In this hour we learned that databases are software systems designed for storing structured data that can be efficiently accessed and modified. Data in a database is structured by means of tables. A table is described by its columns (sometimes referred to as fields), each of which has a name and a type.

Database tables can have a special kind of column known as a primary key column, a column of type int whose value is automatically provided by the database system when adding a new record. The primary key column's purpose is to identify as unique each record in a table.

In addition to columns, database tables contain rows. The rows of a table make up the table's data. For example, in Figure 13.17, the Customers table has five rows, which ...