Oracle
Need Help in Oracle Assignment?
We can help you if you are having difficulty with your Oracle Assignment. Just email your Oracle Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Oracle Assignment.
4 Item(s)
Grid List
-
CMIS 320 Lab 4 Homework 4 Choose Oracle datatypes
$8.00CMIS 320 Lab 4 Homework 4 Choose Oracle datatypes
Instructions
Learn More
Choose Oracle datatypes for the following attributes from a normalized relation including:
Vendor(VendorID, Address, ContactName)
Item (ItemID, Description)
PriceQuote(VendorID, ItemID, Price)
Describe why you selected the datatypes for each attribute. -
Oracle 11g SQL Joan Casteel Chapter 12 Hands-On Assignments
Regular Price: $10.00
Special Price $8.00
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.
Learn More
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. -
Oracle 11g SQL Joan Casteel Chapter 11 Hands-On Assignments
Regular Price: $10.00
Special Price $8.00
Oracle 11g SQL Joan Casteel Chapter 11 Hands-On Assignments
To perform these assignments, refer to the tables in the JustLee Books database.
Learn More
1. Determine how many books are in the Cooking category.
2. Display the number of books with a retail price of more than $30.00.
3. Display the most recent publication date of all books sold by JustLee Books.
4. Determine the total profit generated by sales to customer 1017. Note: Quantity should be reflected in the total profit calculation.
5. List the retail price of the least expensive book in the Computer category.
6. Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit.
7. Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn't recently placed an order with JustLee Books.
8. Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50.
9. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
10. What's the retail price of the most expensive book written by Lisa White? -
Oracle 11g SQL Joan Casteel Chapter 10 Hands-On Assignments
Regular Price: $8.00
Special Price $5.00
Oracle 11g SQL Joan Casteel Chapter 10 Hands-On Assignments
To perform the following assignments, refer to the tables in the JustLee Books database.
1. Produce a list of all customer names in which the first letter of the first and last names is in uppercase and the rest are in lowercase.2. Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text "NOT REFERRED" if the customer wasn't
referred to JustLee Books by another customer or "REFERRED" if the customer was referred.3. Determine the amount of total profit generated by the book purchased on order 1002. Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places. Take into account that the customer might not pay the full retail price, and each item ordered can involve multiple copies.
4. Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.)
5. Display the current day of the week, hour, minutes, and seconds of the current date setting on the computer you're using.
6. Create a list of all book titles and costs. Precede each book's cost with asterisks so that the width of the displayed Cost field is 12.
7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure each different length value is displayed only once (not once for each book).
8. Using today's date, determine the age (in months) of each book that JustLee sells. Make sure only whole months are displayed; ignore any portions of months. Display the book title,
publication date, current date, and age.9. Determine the calendar date of the next occurrence of Wednesday, based on today's date.
10. Produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number, if it exists.
Learn More
4 Item(s)
Grid List
You have no items in your shopping cart.
