Our database is SQL server. Our naming convention is CamelCase and do not use underscores. A contractor is creating a database (warehouse) and it will primarily use SASS to access the data. The contract used a naming convention as:
FIRST_NAME, LAST_NAME, etc..
Tables are perfixed with DIM. Example: DIM_PERSONNEL
Some fields are prefixed with DIM. Example: DIM_BUSISES_YEAR_KEY
The boolean fields are defined as character. Example IS_MILITARY CHAR(1) NOT NULL
He said these are SASS standards. The question I have for the SASS group. Are these standard used for creating databases even if the client is using a database that has other standards or should we use the DB standards.
Any other feedback concerning the standards is greatly appreciated. Please provide a link to a document if you reference one.
FIRST_NAME, LAST_NAME, etc..
Tables are perfixed with DIM. Example: DIM_PERSONNEL
Some fields are prefixed with DIM. Example: DIM_BUSISES_YEAR_KEY
The boolean fields are defined as character. Example IS_MILITARY CHAR(1) NOT NULL
He said these are SASS standards. The question I have for the SASS group. Are these standard used for creating databases even if the client is using a database that has other standards or should we use the DB standards.
Any other feedback concerning the standards is greatly appreciated. Please provide a link to a document if you reference one.