March 13th, 2010
Base Table, Part 1 of 2
Posted by
admin in
B. SQL Basics
In a relational database, the physical data exists in a Base Table.
A table consists of columns or attributes (vertically) and rows or entities (horizontally).
Here is a sample store table with column headings:
A row is the horizontal entry and is like a record in a legacy database. It normally has a unique, identifying key, so that all the data in that row may be identified and retrieved.
A column is the vertical entry in the table and contains information associated with a specific field in the table.
The primary key is a column that makes each row in the table unique and identifiable. This eliminates the possibility of duplicate rows.
