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 ...