So.... who knows Database basics - Finding anomolies

greedostick

Obsessed Neo-Fan
15 Year Member
Joined
Aug 11, 2003
Posts
4,475
Taking databases this semester. Going OK I guess. I understand 1NF, 2NF, 3NF, making ERD's, Crow diagrams etc...

But I am struggling on how I pick out anomolies in these charts and diagrams.

Example, data, insertion, deletion, duplicate anomalies.

Anyone have any "pro tips" on how to pick these out of a diagram?
 

Tjanko04

Mr. Big's Thug
Joined
Aug 19, 2016
Posts
202
If you want to supplement your current courses, check out SoloLearn for SQL on either the Play store or the Apple equivalent. I got a certificate for completing the course and you can work on it wherever you have a free minute to hop on your phone. I don't work with it enough to give you any pro tips though. Most of the development I do for work is working in conjunction with databases, but not actually developing the software on the back end.
 
Top