Course(scheduled) Table Assignment Normalize the above COURSE table Use (1) the data content and (2) your experience as a student to ascertain the attribute semantics i.e, the functional dependencies Show work using the FD/reduction approach Show final normalized tables. Identify PKs and FKs ROOM TIME COURSENO COURSENAME TUTOR 900 1264 8.00 1265 38 9.00 1266 39 7:00 1562 39 800 1563 14 700 1564 38 800 1264 12 700 1264 French 1 French 2 French 3 Spanish 1 Spanish2 Spanish 3 French 1 French 1 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)