This is a question for a SQL Expert

Week3 Homework 2 Describe Real Estate tables Using the example below fill out RealEstate tables information in SOW Form above. Please Don't change Table Names and Column Names The table names start with "re_" to identify our lab project. PK are defined as "INT Primary Key Auto_increment", corresponding FK are defined as INT

Should look like the below example

\begin{tabular}{|l|l|l|l|l|} \hline re_State & & & ParentTable & ParentTable \\ \hline & & & & \\ \hline StatelD & INT Auto_Increment & PK & & \\ \hline SateName & & & & \\ \hline & & & & \\ \hline re_City & & & & \\ \hline & & & & \\ \hline CitylD & INT Auto_Increment & PK & & \\ \hline CityName & & & & \\ \hline StatelD & & & & \\ \hline \end{tabular} re_Zip \begin{tabular}{|l|l|l|l|l|} \hline & & & & \\ \hline ZipID & INT Auto_Increment & PK & & \\ \hline ZipCode & & & & \\ \hline CityID & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline re_House & \multicolumn{2}{|l|}{} & & \\ \hline \end{tabular} re_HouseType \begin{tabular}{|l|l|l|l|l|} \hline re_State & & & ParentTable & ParentTable \\ \hline & & & & \\ \hline StatelD & INT Auto_Increment & PK & & \\ \hline SateName & & & & \\ \hline & & & & \\ \hline re_City & & & & \\ \hline & & & & \\ \hline CitylD & INT Auto_Increment & PK & & \\ \hline CityName & & & & \\ \hline StatelD & & & & \\ \hline \end{tabular} re_Zip \begin{tabular}{|l|l|l|l|l|} \hline & & & & \\ \hline ZipID & INT Auto_Increment & PK & & \\ \hline ZipCode & & & & \\ \hline CityID & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline re_House & \multicolumn{2}{|l|}{} & & \\ \hline \end{tabular} re_HouseType