practice in converting an ERD into a set of Relations, Normalizing the Relations, and creating a Relational Database in Microsoft SQL Server using Microsoft SQL Server Management Studio (SSMS)

first, Review the attached ERD to DB Exercise (PDF document) and create a set of Relations - tables. Once you have a set of Relations, normalize them to 3rd Normal Form, and create the tables in SQL Server.

second, Review the attached proposed solution ERD to DB Tables (Excel spreadsheet). This is only one solution, multiple solutions are possible

Entity Relationship Diagram \begin{tabular}{|l|l|l|l|} \hline \multicolumn{1}{|c|}{ STUDENT } \\ \hline PK & E-Number & \multicolumn{1}{|c|}{ COURSE } \\ \hline Student_Name (Address1,_Address2, City, State) \{Phone_Number\} [Age] Emergency_Contact \{Contact_Number\} Contact_Relationship \{High_School\} \{College\} \{Major\} Minor & Course_Number Course_Description Course_Section Instructor Term Grade_Preference Instructor_Phone Instructor_Office Department \\ \hline \multicolumn{1}{|c|}{ SPORT } \\ \hline \end{tabular}