9.1 Updating, Deleting, Sorting and Searching for Data

Databases are used to store and organise large amounts of data on a computer.Databases are used in many aspects of every day life. Data may need to be deleted or removed from a database. An example of where data would need to be deleted is if a customer dies. If data is no longer correct, it will need to be updated. An example would be when a customer has recently moved house and their address details have changed. With databases, you can also dort data in either ascending (0-10, A-Z) or  descending (10-0, Z-A). An example would be if a company needs to find a customer who placed an order on a particular day-it is…