Rewrite the relation schema given in the ...

Rewrite the relation schema given in the first question assuming that a teacher can give more than one course in one semester, and a course can be given by more than one teacher in one semester. For example, more than one teacher can give a CEN350 course for the spring 2021 semester. In the spring 2021 semester, each teacher can give any number of courses. You should list the primary and foreign keys for each table and show that your relation schema does not have any redundant data. (you are not required to write any SQL commands, you should just give the relation schema and list keys and functional dependencies for each relation)