I need help with the following attached assignment.

Using the information provided in the Baseball Database documentation included in Module $1,($See the image below$)$

Baseball database documentation

write the DDL to create the AwardsPlayers table. After you have created the table, load the data provided in the attachment.

$07-$ AwardsPlayers Data.$sql.dar{r}_{?}$

Submit your answer as a single file with an $SQL$ extension. For this assignment, your script is required to:

Write the DDL to create the AwardsPlayers table. The script should include an IF statement $($see script for creating the baseball database

for examples$)$ so that it could be run several times without changing anything in the script. See slide $12$ of the chapter PowerPoint for an

example of creating a table.

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$,$ 'Gold Glove', 'Babe Ruth Award', 'Hutch Award', $\text{'}$TSN All$-$Star', 'ALCS MVP$,$

'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', 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

Last, run the ${07}_{?}-$AwardsPlayers Data$-2\mathrm{.}591$

Reference the Baseball Database Documentation darr so that you use the correct column names. Creating your own column names will

cause your queries in future assignments not to run when $1$ grade them. This will result in points being taken off those submissions for

not following good database lifecycle management.

Your answer must be submitted as a $.$sql file. Your submission must include the SQL for steps $1$ to $3.$ The INSERT statements to add the data

do not have to be included. If your create table is correct, the data will load without problems.

Note: Some of the future assignments will rely on this table, so if you do not receive a $100,$ you must still correct the table in your database.

If there are errors, I will tell you about them in the grading comments