Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

how to create this case study in oracle

2678332May 22 2014 — edited May 25 2014

Orient Courier Service is a leading provider of courier services to international/domestic destinations.  The service has offices all over the country where it picks up parcels for delivery. When a customer walks in for handing over packets for delivery the clerk at the desk keys in the customer’s name, address, email, hp no,weight (package) as well as the receiver’s name, address, hp no, city and country. All the fields are compulsory except the email address. Amount is also entered and is calculated based on fixed charges which are stored in the database. For example.

City

Charges

Johor Bahru

10/kg

Sydney

30/kg

London

25/kg

Based on the above scenario you have to come up with a physical database with the following.

  1. A stored function to calculate delivery charges given city and weight

Hint (create two parameters city and weight)

  1. A stored procedure to insert records into deliveries table

HINT create stored procedure with parameters for each field in the deliveries table for ex customer address, phone, email and receivers’s address etc

please help me to solve this case study, i new in  oracle..

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2014
Added on May 22 2014
2 comments
1,267 views