Skip to main content

Posts

Showing posts with the label Database

Points to consider for creating new tables

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...