Click me
Transcribed

7 Deadly Sins of Database Design

7 DEADLY SINS OF DATABASE DESIGN 1. Poor or Missing Documentation It is essential that we have sufficient knowledge about our database system. Keeping records is a must. Brought to you by Accede Holdings http://accede.com.au Ohe ige omal loms 3NF 2NF HELLO MY NAME IS 1NF let od Database 2. Little to No Normalization 6. Not using proper naming standards Data in one table may be easier for data access but not the best 7. Incorrect choice of Primary Keys It is recommended to use option. 1st to 3rd normalization is a must. proper names for easy understanding. Choose your primary keys wisely because it is difficult to correct. 5. Not using foreign keys 3. Not Updating it Often Create External Using efficient validation checks is a must to define Database should be updated often to cope up with changes effectively. Primary der Test valicdation Key Rules each database levels. Tools Foreign Key Selection - dependent update ime for an Foreign Keys: Ede. Done New. Help 4. Improper storage of reference data Store reference data For database tips, advice and tutorials, tune it to Accede's Twitter account at https://twitter.com/Accede_Holdings in a model or have a reference in the modelthat points to reference data. Source: http://blogs.perficient.com/enterpriseinformation/2014/08/18/seven-deadly-sins-of-database-design/

7 Deadly Sins of Database Design

shared by robherr on Apr 30
480 views
0 shares
0 comments
In designing your database, there are errors we fail to notice or too late to correct. This results confusion among end users and at the same time, inefficient database system. Accede Holdings Pty. LT...

Writer


Category

Technology
Did you work on this visual? Claim credit!

Get a Quote

Embed Code

For hosted site:

Click the code to copy

For wordpress.com:

Click the code to copy
Customize size