Relationships and entity relationship diagrams A table in a database holds the attributes for one entity only. Data can then be added in the form of records.

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.