National 5 Design Designing INSERT, UPDATE and DELETE queries Designing queries and establishing a data dictionary are important. Decisions should be informed by the Data Protection Act.

Examples are: SELECT queries retrieve data from the database INSERT queries insert new values into a database UPDATE queries edit values in a database DELETE queries delete data from a database.