Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
koi_s3ng
Starting Member
1 Post |
 Posted - 2013-11-10 : 04:11:32
|
| 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 havemany students working on it. The number of hours each studentworks on a assignment, and the start date on which the student startsworking on the assignment are saved in the following relational table.StudentProject (StudNum, AssnNum, HoursWork,DateStartWorkOnAssn) |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-10 : 08:43:55
|
| 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. |
 |
|
|
|
|
|
Normalization.