This illustrates a typical third-normal form schema. In it, the tables are: