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

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.