please help its my test review and i have no idea how to do it. An Amazon Market
ID: 3573979 • Letter: P
Question
please help its my test review and i have no idea how to do it.
An Amazon Marketplace store has recruited you to design code based on data from an Excel file. The file has been uploaded to Week 15 (BooksAmazonlow.xlsx). The store would like for you to upload the Excel file information and given the information, ask the purchaser the following question: How many titles are you going to order? After this, the user should be asked the following questions: How many copies? What is the ISBN of the book you are interested in purchasing? The code should compute the subtotal for each book entered. After the user enters all the books, the user should be asked: What is your first and last name? What is your street address? What is your city, state, and zip? What is the phone number (with area code in parenthesis)? The user should then see: "The grand total (with shipping) is: Total + $15 shipping. Next, the code should give the user a menu question: Would you like an email file of your order ? Yes or No If yes, the code should create a text file (Bookorder050515.txt). Send to the text file using the following: Include the customers information (questions 1-4). A table with all book purchases. The table should have the following column-ISBN. Quantity. Price, and Subtotal (Product of the price of the books quantity). Include all column headings. The statement: "The grand total (with shipping) is: Total + $15. We accept all major credit cards. Thank you and have a nice day. If no. the user should see: "We accept all major credit cards. Thank you and have a nice day." Using the Excel file from Problem 2, ask the user the following questions: What is the ISBN of the book you are interested in purchasing? How many copies? Provided that the user does not put in the ISBN 1234567S9. the subtotal should be continuously add the books entered. Once the user enters the ISBN 123456789 (regardless of the quantity), the user should see the following: Your grand total (with shipping) is. We accept all major credit cards. Thank you and have a nice day. Note: Include a statement at the beginning of the code that states: "Please enter in ISBN 123456789 when your order is finished."Explanation / Answer
Hint:
Below is the code which will read the Excel file, validate and update the database and update excel with comments of validation messages and success.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.