|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3/4/2003
A database can contain more than one table, each with a unique
name. These tables can be related
3/4/2003
A database can contain more than one table, each with a unique
name. These tables can be related |
|
|
|
|
A collection of records that share the same
fields is called a table because this kind of information can
easily be presented in table format: each column represents a
field and each row represents a record. In fact, the word
column is synonymous with the word field, and the word row is
synonymous with the word record.
A database can contain more than one table, each with a unique
name. These tables can be related or independent from one
another.
A subset of data extracted from one or more tables is called a
recordset (or a DataSet in ASP.NET). A recordset is also a
table because it’s a collection of records that share the same
columns. For example, a hockey team roster listing the names
and positions of the players could be called a recordset: it
consists of a subset of all the possible information about the
players, including goals, assists, penalty minutes, and so on. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|