|
Welcome to our web site
For example, a hockey trading card could be called a record: it
brings together the name, photograph, team, and statistics of
one player. Using database terms, each of these related pieces
of information is called a field: each hockey card “record” has
a name field, a photograph field, a team field, and various
statistic fields.
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.
Introduction to our web site
A database can contain more than one table, each with a unique
name. These tables can be related or independent from one
another.
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. |
|
|