Higher Design Relationships and entity relationship diagrams Designing queries and establishing a data dictionary are important and attributes and relationships should be clearly defined.