Suggested Practices

Objective 3.1: Design Code that Validates Input Data and Permissions

• Practice 1 Create a table called Customers, one called Orders that references the Customers table, and another called OrderRows that references the Orders table. Implement the foreign key constraints with cascading updates and deletes. Test the behavior of these constraints by inserting, updating, and deleting data in the tables.

Objective 3.2: Design Code that Detects and Reacts to Errors

• Practice 1 Create a stored procedure that includes a try/catch block. Test the behavior of nested try/catch blocks by adding additional try/catch blocks both in the outer try block and in the outer catch block of the stored procedure.