View and Joined Table Design

View Design
[Proposal] Do not nest views unless they have strong dependency on each other.
[Proposal] Try to avoid collation operations in a view definition.
Joined Table Design
[Proposal] Minimize joined columns across tables.
[Proposal] Use the same data type for joined columns.
[Proposal] The names of joined columns should indicate their relationship. For example, they can use the same name.