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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!