All resourcesGuidesCoursesTips

Troubleshooting databases

Practice with troubleshooting

 In your companion doc, use your table from Translating from a spreadsheet (or the answer tables HERE):
  1. Run the Update troubleshooting test - is there an issue with updating information
    1. Do you have to update the same information in multiple places?
    2. Would a relation help?
  2. Test the Insert troubleshooting - is there an issue with adding new information?
    1. Could issues be solved with a relation?
    2. Would blank/isnotblank help?
    3. Do we have a correct hierarchy?
  3. Troubleshoot for Delete issues - when you delete something does everything work as intended?
    1. Could issues be solved with a relation?
    2. Would archiving be a better choice than deleting?

Was this helpful?

YesNo