Course(scheduled) Table Assignment Normalize the above COURSE table Use (1) the data content and (2 ROOM TIME COURSENO COURSENAME TUTOR your experience as a student to 12 900 1264 800 1265 38 900 1266 39 700 1562 39 800 1563 114 700 1564 38 800 1264 1 700 1264 French 1 French 2 French 3 Spanish 1 Spanish 2 Spanish 3 French 1 French 1 ascertain the attribute semanties iethe functional dependencies Show work using the FD ireduction approach Show final normalized tables Identily PKs and FKs JL PS KL KL KR PS JL 2a. Use the data content in the table to ascertain the attribute semantics; that is, the functional dependencies. If necessary, state your assumptions. Also, as students to ascertain the semantics and functional dependencies. 2b. As a student to determine the semantic dependencies Note too that there are NULL values in this table. Show work using the FD/reduction approach. Show final normalized tables. Identify primary keys (PKs) and foreign keys (FKs)