developers

    Forum Stats

  • 3,873,629 Users
  • 2,266,619 Discussions
  • 7,911,595 Comments

Discussions

how to create this case study in oracle

2678332
2678332 Member Posts: 3
edited May 25, 2014 4:54AM in Oracle Call Interface (OCI)

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..

Answers

This discussion has been closed.
developers