Given this ERD, write the DDL statements required to create the database.

$$ You don$$t need to insert any data. Just create the structures.

$$ Use the mapping rules discussed in class to determine what relations and fields you will

end up with.

$$ Use your discretion to select appropriate datatypes.

$$ Players must have names.

$$ Your resulting database must enforce basic integrity rules. Specifically the keys.

$$ You should be able to run your DDL statements in Access one at a time to create your

database

$$ Hint: You will need to create Team table first, then Player, then add the foreign key to

Team. Otherwise you will get a dependency loop caused by the foreign keys.