Question: 1. Write a description for a scalar function that would be useful in your database. Some examples: Format a 9-character social security number (e.g., 123456789


1. Write a description for a scalar function that would be useful in your database. Some examples: Format a 9-character social security number (e.g., "123456789" formats as "123-45- 6789") Format a proper name (e.g., "MARY" formats as "Mary" and "sally" formats as Sally") Determine the last time given user whose primary key is provided to the function changed his/her password 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: Return a record set of all users born in the provided month Delete all users with the provided last name 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 by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
