Assignemnt: Instructions to Learners

Step 1

Select an ER diagram that you have worked on during one of the discussions in a prior module. This ER diagram should be in at least third normal form and contain at least three tables and at least two relationships. Post an initial message with the following elements:

1. Write a description for a scalar function that would be useful in your database. Some examples:

1. Format a 9-character social security number (e.g., "123456789" formats as "123-45-6789")
2. Format a proper name (e.g., "MARY" formats as "Mary" and "sally" formats as "Sally")
3. Determine the last time given user whose primary key is provided to the function changed his/her password
4. Determine the last name for a given user's primary key

2. Write a description for a stored procedure that would be useful in your database. Some examples:

1. Return a record set of all users born in the provided month
2. Delete all users with the provided last name
3. Deduct an amount from an account, if possible

3. Attach your ER diagram to your initial message or embed it as an inline image.

Step 2

Select the initial messages of at least three classmates whose requirements sound interesting. Write a stored procedure and a function for each initial message and post them as responses to your classmates. Be sure to target the DBMS of your choice. Do not use a code generator or graphical tool to write the procedure and function; write them on your own. For the stored procedure, determine an appropriate transaction isolation level and create and commit or rollback the transaction as appropriate inside the procedure.