Preserving Data Integrity6:33 with Alena Holligan
Deleting information can spell disaster for our database. We can easily lose things we need to keep track of. First we'll keep items from being so easy to delete, by asking the user to verify that they actually want to delete the item. Second, we're going to prevent users from deleting information we don't want them to delete.
Deleting Projects with Tasks
Be cautious when deleting information from ANY data source. This video covers the concepts of asking the user to be sure they want to delete and also not allowing projects to be deleted if they have any tasks assigned. There are many other options we could choose for handling data integrating.
A few more things to consider:
- Don't show delete if project has tasks
- Hide project instead of delete
- Reassign tasks to another project
You need to sign up for Treehouse in order to download course files.Sign up