For each entity in the E-R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables. Refer to the sample metadata table in Chapter 5 of the textbook for an example and use the provided metadata table template for question 1 below to format and document detailed column properties.

Note: Use the following metadata table template for question 1 of the assignment.

TABLE PROPERTY SPECIFICATION
Column Name	Data Type	Key	Required	Default Value	Remarks

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ COLLEGE } \\ \hline PK & Collegename \\ \hline & DeanFirstName DeanLastName Phone Building Room \\ \hline \end{tabular}