Where was this video, I mean I have been struggling with this and getting more confuse with other RUclips videos but this right here is magic, thank you sir
Why is the ticket number not a determinant for the code? I did not observe any instances in the table where the same ticket number corresponds to multiple fines.
You are correct; however, this is a limited amount of data. The argument is that a ticket could have multiple fines on it. For example, if you got pulled over for speeding you could also have received a fine for no seatbelt on, broken taillight, etc. If we had more data, this would be more readily apparent. The data is a good starting point, but we also have to use some additional reasoning.
@@DustinOrmond Thank you for responding to my query. So it depends on the argument. If the argument is that one ticket only has one fine, then the design will be different.
Just blown away by your detailed and super explanation. Learned alot in a few minutes more than what I learnt for a whole month.thankyou
Just went through your entire play list. This well organized and well explained. Thank you!
I wish I had seen your channel before I spent much time understanding this concept. Expert decomposition.
completed whole playlist in one go, such a nice engaging and simplified teaching methodology, thanks 🙌
Where was this video, I mean I have been struggling with this and getting more confuse with other RUclips videos but this right here is magic, thank you sir
One of the best playlist on normalization. Thank you!
Explained extremely well, thanks a lot for this playlist
Thank you so much. Your playlist on normalization is so easy to follow and understand :)
amazing video. explained well, better than mu uni proffesor. thanks!
Best explanation on normalization! Thanks a lot
Better than my $60k a year private college professors
helpful,thank youuuuuu
Why is the ticket number not a determinant for the code? I did not observe any instances in the table where the same ticket number corresponds to multiple fines.
You are correct; however, this is a limited amount of data. The argument is that a ticket could have multiple fines on it. For example, if you got pulled over for speeding you could also have received a fine for no seatbelt on, broken taillight, etc. If we had more data, this would be more readily apparent. The data is a good starting point, but we also have to use some additional reasoning.
@@DustinOrmond Thank you for responding to my query. So it depends on the argument. If the argument is that one ticket only has one fine, then the design will be different.
@@yennychen3370 Correct.
What software is this?
It is my own custom-built software, not available to the public yet.
why is the Code considered a Primary Key?
Because code determines fine is a functional dependency.
does anyone have the ER diagram for this 3NF database?
Blurred