Relational databases consist of many objects, and the most common of these is a table. A table is a logical structure (relation) for storing and retrieving rows of data. It is defined by its columns which are represented by the data types.
Every table should have a primary key as a unique representation of a single row. It is usually a single column that either hosts a sequential number or a unique identifier that would never be used more than once. Tables can also contain two or more columns that together represent the unique row of the table. A table can also host foreign keys which describe its table reference, or relation to another table. For example, a Students table has a unique StudentID column, and the same StudentID is then represented in a Grades table to tie the actual grade to the student. This allows for one student to have none, one...
