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
Writer
Source
http://acced...ase-designCategory
TechnologyGet a Quote