New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

179 Pages
CPC Portfolio part B

Summary of reason for hospitalisation (including length of stay):     List of main medical and nursing health issues for this hospitalisation.   &nb ...

Type

Thesis

Subject

5 Pages
MBA

1. Disscussthestrategicmanagementprocessanditsapplicabilitytoacompanythatis planningtoinvestoverseas.Elaborateontheprocessesinvolvede.g.abusiness ideathatwouldmeetoverseasstakeholderneedsetc. 2. Dr ...

Type

Thesis

Subject

23 Pages
INDG 100 Indigenous Education and Perspectives

Questions – Be sure to answer all parts of each question.  1) Use Suzanne Methot’s Legacy: Trauma, Story and Indigenous Healing, Dakota 38 and your own perspective (where r ...

Course

indg 100

Type

Essay

Subject

University

Selkirk College

20 Pages
Procurement & Contracts

The Edinburgh Education Academy is not experienced in new construction or renovation of existing buildings. Their core business is the delivery of high quality independent education. They aim to upg ...

Type

Thesis

Subject

Business Management

Question

Answered

1.   (10 pts) Write a PL/SQL block to retrieve the hire date of each employee from the
EMPLOYEE table and print them to the screen.

a.    Use a loop to retrieve the employee numbers and hire dates of all employees currently in the EMPLOYEE table and store them in an associative array, using the employee number as the associative array index.  
TBL_HIREDATE
7369    17-DEC-03
7499    20-FEB-99
7521    22-FEB-03
7566    02-APR-91
7654    28-SEP-97
7698    01-MAY-98
7782    09-JUN-96
7788    09-DEC-04
7839    17-NOV-91
7844    08-SEP-99
7876    12-JAN-99
7900    03-DEC-01
7902    03-DEC-05
7934    23-JAN-00

b.    Use another loop to retrieve the hire dates from the associative array and print them to the screen, using DBMS_OUTPUT.PUT_LINE.      
        anonymous block completed
17-DEC-03
20-FEB-99
22-FEB-03
02-APR-91    
…  …
 
Note: Question 2 uses BB_SHOPPER and BB_BASKET tables

2.  (10 pts) Write an anonymous PL/SQL block with a cursor to retrieve and display information about shoppers based on their total purchases (For example, in BB_BASKET table, the total purchase for idShopper 21 should be 32.4+34.36):

Total purchases    Message
150 or more    Valuable customer
Between 50 and 150    Regular customer
50 or less    Needs promotion

Sample output:
anonymous block completed
Scott Savid is a regular customer.

Monica Cast needs promotion.
Camryn Sonnie is a regular customer.
Margaret Somner is a valuable customer.

Note: Question 3 uses BB_SHOPPER and BB_BASKET tables

3.  (10 pts) Write an anonymous PL/SQL block to count number of orders placed by a shopper. Raise a user-defined exception if a shopper hasn’t placed any orders.


Sample output for idshopper = 23

anonymous block completed
This shopper placed 3 orders.

Sample output for idshopper = 26

anonymous block completed
This shopper hasn't placed any orders.


 
Note: Question 4 uses EMPLOYEE table.

4. (10 pts)  Create a stored procedure called INCREASE_SALARY to increase all employees’ salaries in a department.  The procedure should receive the following two parameters: department number and salary increase amount.  The new salary for an employee is calculated based on the following formula: New salary = Old salary + Increase amount.  

Including the following two exceptions in the procedure:
a.    If the department number provided is not in the DEPTNO column, generate a message “This department doesn’t exist.”
b.    If the salary increase amount is less than 100 or greater than 1000, then generate a message “The specified amount is invalid.”

Business Management

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

13 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com strives to deliver quality content to students of USA and deliver assignment writing services as per individual assignment assistance. We have built up a pool of 3800+ assignment experts who provide academic writing help in more than 100+ subjects. Our skilled and experienced assignment writers deliver custom-made assistances, and they offer need-based university assignment help to students as per their assignment demands.

More Business Management: Questions & Answers

Q

CPC Portfolio part B

Summary of reason for hospitalisation (including length of stay):     List of main medical and nursing health issues for this hospitalisation.     After care arrangement plan (to rehab, another hospital, home - who will be primary car ...

View Answer
Q

MBA

1. Disscussthestrategicmanagementprocessanditsapplicabilitytoacompanythatis planningtoinvestoverseas.Elaborateontheprocessesinvolvede.g.abusiness ideathatwouldmeetoverseasstakeholderneedsetc. 2. Driversmeanthereasonswhyacompanywouldgooverseas.Discussandexplain thecausesofglobalizationandthediffe ...

View Answer
Q
icon

We aren't endorsed by this University

INDG 100 Indigenous Education and Perspectives

Questions – Be sure to answer all parts of each question.  1) Use Suzanne Methot’s Legacy: Trauma, Story and Indigenous Healing, Dakota 38 and your own perspective (where relevant) to answer the following.  A) What is intergenerational trauma? What are some cau ...

View Answer
Q

Procurement & Contracts

The Edinburgh Education Academy is not experienced in new construction or renovation of existing buildings. Their core business is the delivery of high quality independent education. They aim to upgrade their current facilities and introduce a new nursery provision from 2 to 5  years to comp ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?