creating additional tables

FIELD NAME DATA TYPE FIELD SIZE PRIMARY KEY DESCRIPTION
Trainer Number TEXT 2 YES Trainer Number (primary Key)
Last name TEXT 10 NO Last Name of Trainer
First Name TEXT 8 NO First Name of Trainer
Address TEXT 15 NO Street Address
City TEXT 15 NO City
State TEXT 2 NO State (Two-Character Version)
Zip Code TEXT 5 NO Zip Code (Five-Character version)
HOurly Rate Currency Hourly Rate of Trainer
YTD Earings Currency YTD EARnings of Trainer