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

$2.$ You don$$t need to insert any data. Just write a script that can create the structures.

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

up with.

$4.$ Use your discretion to select appropriate datatypes.

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

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

database.

$7.$ At the end of your DDL file, include a query that could be used to calculate the $$earnings$$

value for an Employee. Every time an episode of a series is played, the actors get paid a

certain amount of money based on their royalty rate for that series. An actors earnings is

the sum of all these earnings. RoyaltyRate is a currency value, such as $$0\mathrm{.}05.$