Search results for 'shipping'

IT358 Unit 7 Synonyms Index and Sequence

Outcomes addressed in this activity:
Describe how the schema objects work
Describe how sequences and indexes are created, modified, and removed within Oracle
Describe when to use an Index
Utilize Synonyms

Project requirements:
In this project, you will create a view, synonym, and index:
1. Answer the Review Questions #1–5 from Chapter 6.
2. Complete Hands-on Assignments #1-10.

Oracle 11G SQL Chapter 6 Hands-On assignment Solution
1. Create a sequence to use for populating the Customer# column of the CUSTOMERS table. When setting the start and the increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values, not cache any values, and no minimum or maximum values should be declared.
2. Add a new customer row using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = Shoulders, first name = Frank, and zip = 23567.
3. Create a sequence that will generate integers starting with the value 5. Each value should be three less than the previous value generated.The lowest possible value should be 0, and the sequence should not be allowed to cycle. Name the sequence MY_FIRST_SEQ.
4. Issue a SELECT statement that will display NEXTVAL for MY_FIRST_SEQ three times. Because the value is not being placed in a table, use the DUAL table in the FROM clause of the SELECT statement. What causes the error on the last SELECT?
5. Change the setting of MY_FIRST_SEQ so the minimum value that can be generated is –1000.
6. Create a private synonym that will allow you to reference the MY_FIRST_SEQ object as NUMGEN.
7. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.
8. Create a Bitmap index on the CUSTOMERS table to speed up queries that search for customers based on their state of residence. Verify that the index exists, and then delete the index.
9. Create a B-tree index on the customer’s Last Name column. Verify that the index exists by querying the data dictionary. Remove the index from the database.
10. Many queries search by the number of days to ship (number of days between the order and shipping dates). Create an appropriate index that might improve the performance of these queries.

CIS 170 Week 2 iLab 2 of 7 Decisions

Scenario/Summary
You will code, build, execute, debug, and test two programs using decision structures. The first program will calculate the shipping charge based on a given purchase amount. The second program translates a given TV channel to its call sign.

Part A: Calculate Shipping Charge
Requirements
Your mission: Write a program that gets the amount of a purchase from the user and then calculates the shipping charge, based on the following table:
$0.00 - $250.00: $5.00
$250.01 - $500.00: $8.00
$500.01 - $1,000.00: $10.00
$1,000.01 - $5,000.00: $15.00
over $5,000.00: $20.00
Sample output from program:
Enter a purchase amount to find out your shipping charges.
Please enter the amount of your purchase: 234.65
The shipping charge on a purchase of $234.65 is $5.00.
Press any key to continue . . .
Tips
Best practice: Put yourself in the place of the program. What questions would you ask a customer in order to get the best input? How would you determine the correct shipping charges if you had to make the decisions yourself? Write out the questions you would ask yourself on paper as pseudocode and/or in Visual Studio as C# comments, and then implement them one by one, testing as you go. Remember to not write too much at one time. Always add and test functionality incrementally!
You can use the pseudocode below as a guide:
Prompt the user for the sale amount
Is sale amount greater than $5,000.00?
 If so, shipping is $20.00
If not, is sale amount greater than $1,000.00?
 If so, shipping is $15.00
If not, is sale amount greater than $500.00?
 If so, shipping is $10.00
If not, is sale amount greater than $250.00?
 If so, shipping is $8.00
If not, is sale amount greater than $0.00
 shipping is $5.00
If not
 shipping is $0.00
If shipping is $0.00
 Display "Error incorrect input"
If not
 Display sale amount and shipping charge

Part B: TV Channel to Call Sign
Requirements
Your mission: Write a program that translates a TV channel (1 through 10) in your area to its respective call sign. For example, in the New York metropolitan area, channel 2 translates to WCBS. If a channel is unused in your area, tell the user that this is the case.
Sample output from program:
Translate TV Channel Number to Call Sign
Enter channel number: 1
Channel 1 is undesignated in your area
Enter channel number: 2
Call sign for channel 2 is WCBS
Enter channel number: 6
Call sign for channel 6 is WRNNDT
Tips
Best practice: Put yourself in the place of the program. What steps would you personally need to perform in order to process a channel translation yourself? Write out those steps on paper as pseudocode and/or in Visual Studio as C# comments, and then implement them one by one, testing as you go. Remember to not write too much at one time. Always add and test functionality incrementally!
Pseudocode: Although there are several valid ways to write the program, the following is an outline of one way to design the overall logic.
Declare variables for channel and call sign
Get channel number from user
Use appropriate decision structure to translate number to call sign
If number is valid in area
Print out translation
If not
Tell user this is the case

Midterm Exam Track Order and Video Bonanza Project

Question One:
Modify your work from midterm project to keep track of each order item in an array. You will then include all the ordered items in the summary. Remove the module level summary variables from the form and loop through the array when totaling the order.

Create an array of a structure, which holds the description, quantity, sales price, and extended price (the quantity times the sales price). As each purchase item is added to the order, store the information in the structure array then update the summary text box to reflect the newly ordered item.

Test Data Output
Jane Smith
123 Someplace
Anywhere, CA 99999

Quantity - Description @ Price = Extended Price
2 - Deluxe Cooler @ 68.00 = $136.00
1 - Axe @ 5.00 = $5.00

Subtotal: $141.00
Shipping: 10.95
Total: $151.95

Question Two:
Create a project for Video Bonanza to view a list of Movies. Use a dropdown list box for the movie categories. When a category is selected, display a list of released movie titles in a second list box titled Movie List. Using either buttons or a menu allow the user to display a count of the number of movie titles for the selected category.

The category list will have these categories: All, Comedy, Drama, Action, Sci-Fi, Horror, and New Releases. Do not sort the category list. When the program begins, the All movies category will be selected and the Movie List listbox (which is sorted) will display all the movies. When a category is selected, clear the movie titles list box and fill it with only the movies for that category (hint: use the SelectedIndexChanged event).

Use a two dimensional array to store the movies by category. The movies by category are:
Comedy:
Mrs. Housefire
Twister Act
Home by Yourself

Drama:
Dancing With Fools

Action:
A Dependent's Pay
Home and Around

Sci-Fi:
Jura's Park

Horror:
Ghost Man

New Releases:
Women in White
An American Resident

For the report display all the movie titles by category and output it in the Print Preview dialog box

Programming In VB Web Applications Exercise 9.2 Rough Riders Rodeo

Rough Riders Rodeo wants to sell tickets online. Allow the user to enter the number of tickets needed. The data entry screen should also include the shipping address for the tickets, a credit card number, expiration date, and a drop-down box allowing the user to select the type of credit card. Also include a check box for attending the Awards Event. Include a hyperlink for confirming the order. Make the link invisible to begin with, but display it after the Submit button has been clicked.
The confirmation page should say "Thank you for your order".
'The tickets are Sl5 for just the rodeo. $25 if they want to attend the awards event. Note that all members of the party must select the same type of tickets.
When the user selects the Submit button. display the amount due and display a link to confirm the order (make the existing link visible). Use an UpdatePanel to improve performance.

Assignment 2 Fran’s Virtual Fruit Stand, Part 2

Use the concepts and scenario from Assignment 1 to help Fran’s Virtual Fruit Stand increase the functionality of its online shopping cart. When a customer checks out, the shopping cart must store the required data pertaining to each item the customer is buying. Your job is to design a program that will prompt the user for the required data and then store it. The required data includes the item name, the price per pound, and the number of pounds of that item being purchased. When complete, your program should include three (3) arrays, two (2) loops, one (1) and / or conditional statement, and one (1) variable.

Using Visual Logic, design a flowchart that is also a fully functional program to add functionality to the online shopping cart. According to your design, the program must:

Continually accept data regarding the purchase of fruit as specified below until the user enters a sentinel value, or until five (5) items are entered, whichever comes first.
Prompt the user for each item and accept the name of the fruit (e.g., “dried apples”), the price per pound, and the number of pounds sold in a month.
Store the required data in three (3) arrays (e.g., one (1) for the item name, one (1) for the price per pound, and one (1) for the number of pounds being purchased) with corresponding index values. Note: For example, index value 3, when applied to the “itemName” array, would give us the name of the third item that the customer is buying. That same index value of 3, when applied to the “pricePerPound” array, would give us the price per pound of that same third item that the customer is buying.
Store up to five (5) values in each of the three (3) arrays.
Provide functionality in which the user ends the program by typing a sentinel value, and the program tells the user what the sentinel value is. Note: An acceptable message may read “Type n to end the program.”, where “n” is the sentinel value. If the user does not end the program in this way, then the program ends when it has collected the data for five (5) items.
Print an itemized receipt with the following data after the last item in the purchase has been saved to the array.
Item name
Price per pound of each item
Number of pounds purchased of each item
Subtotal price for each item, calculated as price per pound multiplied by the number of pounds
Total weight of the entire order (in pounds)
The cost of shipping which is based on the total weight of the entire order, calculated as 50 cents per pound. Note: For example, if the entire order weighs seven (7) pounds, the cost of shipping would be $3.50.
Grand total price of all items and shipping.

Note: Use the “console” option in the output command to accomplish this task. An example of an acceptable output has been provided below:

CMIS420 Advanced Relational Database Final Programming Project

In this project, you will design a secure database with several tables using good relational database design techniques.

Project Objectives:
After completing this Project, you should be able to:
Explain the purposes of advanced database objects including indexes, clusters, sequences, and views
Develop and implement functions, triggers, and stored procedures/packages

Project Requirements:
1. Using the Oracle database engine, design and develop a relational database to store user information to support a large online shipping company. Information that needs to be stored includes user name, detailed mailing address, and shipping information including number of packages, weight, cost, destination, origin, and tracking information allowing users to determine where a package is, and when and who signed for the package once it arrives. Other business data should be present showing how much the shipment costs and invoicing capability to send bills to customers. Your design should be normalized and well-designed for scalability for additional customers and shipment locations.

2. Your design should allow for inserting, updating, selecting and deleting information

3. A trigger should be used to generate invoices once a customer reaches $200 in shipping costs.

4. An instead-of trigger should be employed to update and/or populate multi-table views.

5. You should include packages, indexes, views and other helpful database components that will assist you in your design.

6. Your scripts should work perfectly allowing the creation of all of the tables, triggers, views and other database components and provide test scripts that demonstrate the use of the system.

7. You do not need a GUI component but your scripts should demonstrate all of the functionality of the system.

Deliverables:
All sql scripts and run scripts and instructions for successfully building your database and testing your database.
An ERD diagram of your database design showing primary keys, foreign keys and other constraints.
3. Well-written word document describing:
a. The database design
b. How to set up and test your database
c. The test data and results you used for your database,
d. Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.

Oracle 11g SQL Joan Casteel Chapter 12 Hands-On Assignments

To perform these activities, refer to the tables in the JustLee Books database. Use a subquery to accomplish each task. Make sure you execute the query you plan to use as the subquery to verify the results before writing the entire query.

1. List the book title and retail price for all books with a retail price lower than the average retail price of all books sold by JustLee Books.
2. Determine which books cost less than the average cost of other books in the same category.
3. Determine which orders were shipped to the same state as order 1014.
4. Determine which orders had a higher total amount due than order 1008.
5. Determine which author or authors wrote the books most frequently purchased by customers of JustLee Books.
6. List the title of all books in the same category as books previously purchased by customer 1007. Don't include books this customer has already purchased.
7. List the shipping city and state for the order that had the longest shipping delay.
8. Determine which customers placed orders for the least expensive book (in terms of regular retail price) carried by JustLee Books.
9. Determine the number of different customers who have placed an order for books written or cowritten by James Austin.
10. Determine which books were published by the publisher of The Wok Way to Cook.

Programming in Visual Basic 2010 Chapter 4 Novelty Solution

Create a Visual Basic Windows application. Use the following names for the solution, project, and form file, respectively: Novelty Solution, Novelty Project, and Main Form.vb. Save the application in the VB2010\Chap04 folder. Create the interface shown in the figure 4-65. When the user clicks the Calculate Total button, the button's Click event procedure should add the item price to the total of the prices already entered; this amount represents the subtotal owed by the customer. The procedure should display the subtotal on the form. It also should display a 3% sales tax, the shipping charge, and the grand total owed by the customer. The grand total is calculated by adding together the subtotal, the 3% sales tax, and a $15 shipping charge. For example, if the user enters 26.75 as the item price and then clicks the Calculate Total button, the button's Click event procedure should display 26.75 as the subtotal, 0.80 as the sales tax, 15.00 as the shipping charge, and 42.55 as the grand total. If the user subsequently enters 30 as the price and then clicks the Calculate Total button, the button's Click event procedure should display 56.75 as the subtotal, 1.70 as the sales tax, 15.00 as the shipping charge, and 73.45 as the grand total. However, when the subtotal is at least $100, the shipping charge is 0.00. Code the application. Save the solution and then start and test the application. Close the code editor window and then close the solution.

ITSE 2309 LAB 1 Database and SQL Queries

Submit: Query Statements Query Output
Chapters 2,3,4,5 11g SQL book
Objectives: Be able to access ORACLE/SQL Plus Be able to do simple SQL operations

Steps:
- Log onto the sample Oracle 11g database created.
- See Chapter 7 in "Database Systems" for information on coding, saving, and executing your queries.
- Save the output of the queries by using the SPOOL option ( see chpt 14 in 11g SQL in lab resources tab)
- Save both the queries code and the output of the queries as "Lab1_LastName.txt and submit via Blackboard—using the - Attach file – Upload function

Do the following queries:
1. List all columns and rows in the stock table.
2. List the last name, first name, and company of all customers (List the columns in that order). Place the list in alphabetical order by company name.
3. List the company names for all customers from Sunnyvale, Redwood City, or San Francisco.
4. List all orders that were placed between the dates 12/31/1999 and 01/03/2000. List order number, order date, customer number, ship date, and paid date. (Hint: Specify year in single quotes 'DD-MMM-YYYY')
5. List the order number, order date, and shipping charges for all orders that are not on backlog and for which the shipping charge is over $15.00.
6. List all stock items which are baseball items which have a unit price greater than $200.00 and a manufacturer code which starts with 'H'. (Hint: use LIKE)
7. List the company name for all customers who have orders. Don not list a company more than once.
8. List the customer number and the description (from the stock table) of all items ordered by customers with customer numbers 104-108. Order the output by customer number and description. (There should be no duplicate rows in your output).
9. List the number of (distinct) customers having an order. Label the column "Total_Customers_with_Orders".
10. For each customer having an order, list the customer number, the number of orders that customer has, the total quantity of items on those orders, and the total price for the items. Order the output by customer number. (Hint: You must use a GROUP BY clause in this query).