Hi all, i'm not very familiar with normalization and i came across this question.
so I would like to check if base on such scenario where there is a many to many r/s therefore can it be considered as unnormalized as the studnum would actually be repeated.
Students are involved in many assignment, and each assignment may have many students working on it. The number of hours each student works on a assignment, and the start date on which the student starts working on the assignment are saved in the following relational table.
I don't see any problem with the one table that you currently have. Assuming each student has the choice of starting on an assignment at his/her own schedule, the table is normalized. The thing that I don't see is the other tables you will need to store the data - for example, information about students, information about assignments etc.