[SOLVED] Assignment 9

I’m studying for my MySQL class and don’t understand how to answer this. Can you help me study?

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
[SOLVED] Assignment 9
Get a 15% Discount on this Paper
Order Now

Q1 Add a new row in the ORDERS table with the following data: Order# is 2222, customer# is 2121, and the order date is January 22, 2016. Describe the error raised and explain what causes this error. Write another query with a change that allows it to succeed. You may use any valid data.

Q2 Create a script using substitutions variables that allow the user to set a new retail price for a book based on ISBN. NOTE: Important information regarding substitution variables in this week’s supplemental materials.Run your script for the following values ISBN = 1059831198 and retail = $99.99

Q3 Write a query to create a new price list for books written by the same author. Allow the user to enter only the first 4 letters of the last name and the first letter of the first name, they should be able to get the right author. Ask the user to input a percentage and calculate the new discounted price based on the current retail price minus this percentage. Round the result to cents (two decimals). For your example query, assume the user wants to discount the price of James Patterson books by 20%. Please, check your lab work for Chapter 10. We covered a similar query but without the use of substitution variables.

Please, check your lab work for Chapter 10. We covered a similar query but without the use of substitution variables. I posted the partial query in this week’s Discussion Board.

Q4 Question 5 on page 177

(I deleted old Q5 here because it was a duplicate of Q2)

Q5 Question 9 on page 177

Attach and submit your completed assignments in RTF, TXT or SQL format. Please do not include any results from your queries.

ONLY submit the SQL scripts using the following naming convention: HW#_Q#_YourInitials.

For example:

HW9_Q1_DV

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Technology
My paper was sent back after my due date time
Customer 452901, November 12th, 2022
Nursing
Thank you for the outstanding work .
Customer 452635, June 5th, 2022
Other
Great
Customer 452813, January 21st, 2024
Human Resources Management (HRM)
Thank you so much for your time.
Customer 452701, September 5th, 2023
Nursing
Always pleased with the writers work.
Customer 452707, September 9th, 2023
Nursing
Always on time and a life saver for sure!!!!!!!!!!!!
Customer 452453, October 22nd, 2021
public speaking
The work was excelent and very professional.
Customer 452653, November 1st, 2021
Other
GOOD
Customer 452813, July 5th, 2022
Nursing
Great paper!
Customer 452707, June 29th, 2023
Other
GOOD
Customer 452813, July 5th, 2022
Accounting
Thanks for your support
Customer 452701, February 3rd, 2022
Social Work and Human Services
Thank You, Don!!! :)
Customer 452587, November 9th, 2021
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information