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.

A table in a database holds the attributes for one entity only. Data can then be added in the form of records. Rather than storing information in one table, relational databases store data across ...