1. Based on the information provided in Figure P3.17, write a list of business rules that describe the relationships between entities for the TransCo database.

2. Based on the information provided in Figure P3.17, create a data dictionary for the TransCo database in Word or Excel. The data dictionary should contain (at least) all the attribute names and characteristics for each table in the system.

Table name: TRUCK Database name: Ch03_TransCo Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE Table name: BASE Primary key: BASE_CODE Foreign key: none Table name: TYPE Primary key: TYPE_CODE Foreign key: none