Q&A: What are the potential errors in the design and construction of a DB and how can the errors be avoided?
Question by OhMyGaga: What are the potential errors in the design and construction of a DB and how can the errors be avoided?
Best answer:
Answer by Politically Correct
Your database needs to be as small as possible to do the job and be normalised to 3F. Always declare primary to foreign key relations in your tables.
A database with a large number of NULL values will slow down your processing unnecessarily.
An un normalised database will collect errors and degrade.
A database without primary to foreign key integrity will gradually collect orphaned entries.
Add your own answer in the comments!
I don’t have my textbook with me, but there are something like 13 criteria which maintains the integrity — or fidelity — of a database. To date, only 3 of those sets of rules out of the 13 can be demonstrated with CIS. The rules are called Codd’s 12 Rules.