Below are the points which can be consider while creating new table in the database. Comments ( Always add comments to columns and tables) a. I always find comments incredibly helpful, they could answer some of the business / content questions. b. You can add table and column comments. c. Add comments at the table level at the very least to indicate the contents of the table and the relationship between the two (other than simply knowing parent-> child by way of the Foreign Key). d. Column comments are useful, as long as they do not simply restate the column name e. There are undoubtedly some terms for which there is a Glossary of Terms etc. in which case repeating the definition given there is also of little value. f. However if the contents may not be i...
A Full Stack developer who is facing problems in development cycle and here you find solution of errors of those problems.This includes all exception and configuration issues. Solutions which i have written in blog are the one which worked for me after killing my time :) .