Question: Below is a college's teaching assignment record. Instructor Name Semester Instructor Department Course Assignment Jimmy Chen Summer 2021 Computer Science (CS201, Java Programming), (CS403, Advanced
Below is a college's teaching assignment record.
| Instructor Name | Semester | Instructor Department | Course Assignment |
| Jimmy Chen | Summer 2021 | Computer Science | (CS201, Java Programming), (CS403, Advanced Java Programming) |
| Sarah McDonald | Summer 2021 | Data Science | (DS101, Introduction to Data Science) |
| Terri Shroll | Summer 2021 | Data Science | (DS201, Python Programming), (DS204, Statistics in Data Science) |
| Dennis Johnson | Spring 2022 | Computer Science | (CS204, Data Structure and Algorithm), (CS205, Discrete Mathematics) |
| Michael Rozavy | Spring 2022 | Data Science | (DS530, Big Data and Data Management) |
| Jun Shan | Summer 2021 | Computer Science | (CS201, Java Programming) |
Is this 1NF compliant? Why?
If it is not 1NF compliant, create a 1NF compliant model based on the data above.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
