(Solved) : Given Following Table Structure Sample Data Studentid Studentname Major Courseid Courseti Q30689099 . . . .

You are given the following table structure with sample data init. Student_ID Student_Name Major Course_ID Course_TitleInstructor_Name Instructor_Location Grade 145500675 Powell EngENG420 Instruments David B101 B 145500675 Powell Eng ENG530 PLCDesign Peter B117 A 234390137 Anderson IT SIT772 Database Sys JackT201 C 234390137 Anderson IT SIT771 OOD Fred T212 A 543291073Anderson IT SIT773 Soft analysis Margarete T233 B Exercise 1: Drawthe dependency diagram of the table, and normalize the table toensure all generated tables are in 3NF. Present all tablesgenerated from the normalization. Exercise 2: Write SQL code tocreate the generated tables.

Expert Answer

An answer will be send to