MS Access database project - Sales commission reports and sales vouchers


The diagram below shows a database entity relationship diagram for a  trucking company.  Tables include a driver log (main table/entity), a mileage log, hours log, and more.

The diagram is shown in standard ERD (entity relationship diagram) notation.

PK = Primary Key.  The entry in the database that is a unique identifier for each entry, like an employee ID number.

FK = Foreign Key.  This key relates to another table, and is the primary key in another table.

SK = another important key data field, which is often unique.  For example, a person's last name. These are important to have if the primary key is lost or unknown.