2007-03-23 04:42:32 · 6 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
When you enter data into the database - you enter it once. Then because of the relationships you form with the tables the data may be used in several places.
2007-03-23 04:48:31 · answer #1 · answered by Gatekeeper 4 · 1⤊ 0⤋
Reduced Data Redundancy
2016-11-07 09:06:10 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Primary Key: 17834435 Primary Key: 17834435, Name: John Doe Primary Key: 17834435, Age: 32 Primary Key: 17834435, Weight: 142 LBS Primary Key: 17834435, Height: 71 Inches Redundant, is it not? Primary Key: 17834435, Name: John Doe, Age: 32, Weight: 142 LBS, Height: 71 Inches That's better. =) One to Many rocks. Many to many is like wtf? it's a network. Things get crazy (good luck), Having a good relationship type is critical in database design. Make sure you know your needs. Check out "normalization" and the normal forms (1NF, 2NF, 3NF). If you do some reading up on this, you will understand it fully.
2016-03-18 05:39:39 · answer #3 · answered by Anonymous · 0⤊ 0⤋
You would WANT to have everything in a single list. Problem with this idea is that if you delete a line, you may lose OTHER important data. To tackle this, we NORMALIZE our data.
Take a look at this:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
2007-03-23 17:00:46 · answer #4 · answered by Jeffrey F 6 · 0⤊ 0⤋
eliminate repetition of data, for example date,month and year is group in the same group of data
2007-03-23 04:46:25 · answer #5 · answered by Anonymous · 1⤊ 0⤋
It Checks for duplicates; Of Course it needs to check closely, since some files are close edits and need to be there for Various reasons.
2007-03-23 04:45:43 · answer #6 · answered by Mictlan_KISS 6 · 0⤊ 1⤋