Create procedure with appropriate arguments to perform updates and inserts on department table (Department name will be
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create procedure with appropriate arguments to perform updates and inserts on department table (Department name will be unique). Make sure to upload script execution test cases for all the combinations to prove the validation is successfully working and upload screenshots for each question proving the test cases.
- CREATE DEPT TABLE AND INSERT 6 RECORDS INTO IT (refer to Instructions for Schema) - 6 points
- INSERT THE DEPARTMENT IF NAME DOESN\'T EXISTS - 6 points
- UPDATE THE DEPARTMENT LOCATION IF NAME EXISTS - 6 points
- RAISE ERROR IF THE DEPARTMENT NAME IS INVALID (NULL, ZERO LENGTH) - 6 points
- RAISE ERROR IF THE DEPARTMENT NAME IS A NUMBER -6 points
- ACCEPTED LOCATIONS SHOULD BE AS BELOW - 6 points
MA, TX, IL, CA, NY, NJ, NH, RH
G. DEPARTMENT ID SHOULD BE AUTO-GENERATED - 6 points
H. LENGTH OF THE DEPARTMENT NAME CANNOT BE MORE THAN 20 CHARS - 6 points
I. WHILE INSERTING THE DEPARTMENT NAME CONVERT EVERYTHING TO CAMEL CASE - 6 points
J. MAKE SURE DEPARTMENT NAME IS UNIQUE - 6 points
Posted Date: