I need help with the following:

After loading the data to the table write the SQL using ATLER statements to create:

The appropriate primary key. It needs to be a compound primary key using $4$ columns$)$

The appropriate foreign key for the playerid.

A check statement to check that the awardid column contains one of these values:

'Triple Crown', $\text{'}$TSN Reliever of the Year', $\text{'}$TSN Major League Player of the Year', 'Branch Rickey Award', 'Comeback Player of the Year',

'Rookie of the Year', 'Baseball Magazine All$-$Star', 'World Series MVP$\text{'},\text{'}$TSN Fireman of the Year', $\text{'}$TSN Pitcher of the Year', 'Hank Aaron Award',

'Pitching Triple Crown', 'All$-$Star Game MVP$\text{'},$ 'Gold Glove', 'Babe Ruth Award', 'Hutch Award', $\text{'}$TSN All$-$Star', 'ALCS MVP$\text{'},$

'Outstanding DH Award', $\text{'}$NLCS MVPTSN Guide MVP$\text{'},$ 'Reliever of the Year Award', 'Lou Gehrig Memorial Award', $\text{'}$TSN Player of the Year',

$\text{'}$Cy Young Award', 'Roberto Clemente Award', 'Most Valuable Player', 'Rolaids Relief Man Award', 'Silver Slugger', $\text{'}$NLCS MVP$\text{'},$

$\text{'}$TSN Guide MVP$\text{'}$

Hint: You can cut and paste this list if you use an IN clause for your check

The Constrains $($primary key, foreign key, and check statement$)$ must have a name included when you add the constraint. The constraint name must be different than the column the constraint is on$.$ An example would be naming the primary key constraint AwardsPlayer$\_$PK