This homework assignment itakes logical data model created aprovided and making some of the critical choices required during the creation of a physical relational data model.

Part $1$: Choose SQL Data Types

Select an appropriate data type for each table column, including any required parameters for the data type you selected such as length, precision, and scale. You may submit your choices using any of these methods:

An ERD that shows the data type $($assuming you are using a data modeling tool that can display data types on the ERD$).$

Generated CREATE TABLE DDL statements for each of the tables in the schema $($assuming you are using a physical data modeling tool capable of generating the DDL statements$).$

A spreadsheet or Word table that shows table name, column name and data type. Here is an example $($using a different schema$)$: