National 5 Design Relationships and entity relationship diagrams Designing queries and establishing a data dictionary are important. Decisions should be informed by the Data Protection Act.