Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started