About more training in US, from my understanding, the IT trainning here in US is far more superior than the one in Asian countries.   So when you said lack of...

Well, I will prevent the use of 'cd' keyword other than for primary/fr key. But if i have client that already have a database setup I follow their naming standard.

It should not override duplicate keys whether you are db owner or not.

Probably the problem is not duplicate keys.

Well its not like the name, it's like sometime people know me as programmer or gamer or dba. LOL

I agree, a lot of times I need to rename the fk column, like for manager id that actually employee id.

When designing tables and field I try to avoid using SSN or zip code as primary Key. What if the customer give the wrong ssn and they want to change...

If you always use word ID or CD after the field name, you always know that it is a primary/foreign keys.

I would put description the same for two different tables. So I will have description fields in both Item and Customer Table. It is shorter.

For the primary/foreign key problem, usually...