Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started