# CS320 Lab1

Satisfactory Essays
874 Words
Grammar
Plagiarism
Writing
Score
CS320 Lab1
Lab #1
Download Oracle 11g Express Edition either 64bit or 32bit version that the
Instructor has provided. Load and run the CS320.sql script and you then should be able to answer this lab. Please submit queries as download the results in a CSV file format and submit it to the course canvas. This covers SQL Part A (Chapters 2,8&
9 from the text Oracle 11g Sql by Joan Casteel
1. Create a list containing the publisher’s name, the person usually contacted, and the publisher’s telephone number. Rename the contact column “Contact Person” in the displayed results.
2. Determine which categories are represented in the current book inventory. List each category only once.
3. Create a list of authors that displays the last name followed by the first name for each author. The last names and first names should be separated by a comma and a blank space. 4. List all information for each order item, include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading “item total” in the output.
5. Create a mailing list from the customers table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name”. The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location”.
6. To determine the percentage of profit for a particular item, subtract the item’s cost from the retail price to calculate the dollar amount of profit, and then divide the profit by the item’s cost. The solution is then multiplied by 100 to determine the profit percentage for each book. For the column displaying the percentage markup, use “Profit %” as the column heading.
7. Which customers live in New Jersey? List each customer’s last name, first name,

## You May Also Find These Documents Helpful

• Powerful Essays

Total profit is calculated from subtracting the combined total fixed and variable costs from the total revenue generated. Total costs are derived from the fixed cost of \$9,000 in addition to calculating the average variable cost formula provided by the regression analysis multiplied by the profit-maximizing average daily production capacity calculated at each price level.…

• 1521 Words
• 7 Pages
Powerful Essays
• Satisfactory Essays

Cost of goods sold—operating revenue: 180,000 divided by ending inventory of 5000; 180,000/5000 = 36…

• 546 Words
• 3 Pages
Satisfactory Essays
• Powerful Essays

a. The total revenue made from selling each extra unit of output as per the price at Line B.…

• 3065 Words
• 14 Pages
Powerful Essays
• Satisfactory Essays

Using FIFO, calculate (a) ending inventory, (b) cost of goods sold, (c) sales revenue, and (d) gross profit.…

• 1158 Words
• 14 Pages
Satisfactory Essays
• Powerful Essays

• You begin with the author’s surname – comma – and initials followed by a full stop.…

• 1795 Words
• 8 Pages
Powerful Essays
• Satisfactory Essays

Menu item |Number sold |Standard/budgeted portion cost | |A |580 |\$4.45 | |B |285 |\$6.20 | |C |600 |\$4.15 | |D |200 |\$6.00 | |E |475 |\$5.95 | |F |320 |\$7.05 | |G |545 |\$6.10 | |H |200 |\$6.95 | |Totals |3,205 | | | | | | |Solve all problems for 2 decimal places (x.xx) | | | |Food sales |\$57,680.30 | | | | | | |1. Food cost \$ based on standard cost figures |\$17834.75 |(1 pt) | | | | | |2. Food cost % based on standard cost figures |30.92% |(1 pt) | | | | | |3. Contribution margin \$ |\$39845.55 |(1 pt) | | | | | |Actual inventory figures | | | |Opening inventory |\$6,415.60 | | |Purchases |\$19,950.30 | | |Ending inventory |\$6,852.65 | | | | | | |4. Cost of goods sold \$ |\$19513.25 |(1 pt) | | | | | | | | | |5. Food cost % based on actual cost figures |33.83% |(1 pt) | | | | | | | | | |6. Difference between standard and actual cost in \$ |+1678.5 |(1 pt) + or | | | | | |7. Difference between standard and actual cost % |+2.91% |(1 pt) + or | |…

• 689 Words
• 3 Pages
Satisfactory Essays
• Good Essays

61. As a general guideline, your selling price should be approximately what percent more than your cost of goods?…

• 1367 Words
• 7 Pages
Good Essays
• Satisfactory Essays

After finding the price the company wanted to find the revenue. The formula for revenue is {R(x) =xp}.The x in xp stands for the number of retailors that are likely to buy at their set price per seat. With that given we know the formula for price; therefore we have to write the new equation like {R(x) = x(100-25x)}. After writing out the first equation\ is to distribute. The equation for revenue now would end up looking like Rx= 100x-25(squared). After finding the formula for the revenue the next thing the…

• 483 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

6. For each order, list the order number, order date, number of the customer that placed the order, and name of the customer that placed the order.…

• 672 Words
• 3 Pages
Satisfactory Essays
• Good Essays

Actual cost percent- the ratio of actual cost of sales to total sales for a…

• 1195 Words
• 5 Pages
Good Essays
• Powerful Essays

The objective is to Maximize total profit. Profit is calculated for each variable by subtracting cost from the selling price.…

• 866 Words
• 4 Pages
Powerful Essays
• Better Essays

Lastname, Firstname. “Title of the Article.” Name of the Scholarly Journal Volume.Issue (Date): first page-last page.…

• 606 Words
• 3 Pages
Better Essays
• Better Essays

Always list author last name and then the date of publication. Use a comma to separate them.…

• 883 Words
• 4 Pages
Better Essays
• Satisfactory Essays

The objective is to maximize total profit. Profit is calculated for each variable by subtracting cost from the selling price.…

• 418 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

6. When a company sells a \$100 service with a 20% trade discount, \$80 of revenue is recognized.…

• 14932 Words
• 105 Pages
Powerful Essays