1. Exercise 2

The Jambon Factory checks the performance of its carriers each quarter by looking at different evaluation categories (scorecards). The Jambon Factory sends a report called "Rating Report" about its carriers' performance to its traffic department at the end of each quarter. The specific report shown below corresponds to the Quarter 4 20XX for the following less-than-truckload carrier: Jean Marteau (ID: 67859). A carrier has an ID, a name, an address, and can be categorized as truckload or less-than-truckload.

Draw an ERD reflecting the data contained in the Rating Report. A scorecard has a code (e.g. SAF238) and a name. Any scorecard for a certain carrier at a certain date, displays the score the Source attributed to that carrier at that time. Assume that each scorecard is provided by one external source only. A source can provide several types of scorecards. A source has a name (e.g., SAFER or FMCSA), a HQ address, and an authority level. The authority level of the sources can be "Federal" or "State".

Explain what you chose for the identifier of each entity type on your ERD.

Jambon Factory Rating Report QUARTER 4 20XX NAME: Jean Marteau ID: 678529 ADDRESS: 102 Bread street, Morganville ACTIVITY: Less Than TruckLoad Scorecard Scorecard name Source Authority Score SAF238 Safety - accidents SAFER Federal 687 CRED24 Credit - payment FMCSA Federal 645