To start your lab you will need a struct to read data into. The struct definition should be placed above main () and belowusing namespace std. The struct should be called PurchaseType and contain the following fields:1. string customerID2. string productName3. double price4. int qtyPurchased5. double taxRateWrite a complete program that:1. Uses a user defined function:void openFile (ifstream& iFile, string prompt)Which gets the name of a file from the user and opens it into iFile by:Prompting the user for a filename using prompt and reading the filename into a string.b. Opening the file name obtained in (la) into iFile, and verifying that it opened. If the file does not open theprogram should output an error message and continue from (1a) until a valid file name is entered. See theexample output for error formatting.a.i.The file contains strings, integers, and doubles with 5 values per line with 10 lines of data in the file.Each line of data represents a different item purchased by a customer.2. Creates an array of instances of the PurchaseType struct to hold the data from the file obtained in (1).3. Uses a user defined function:void readFile (ifstream& iFile, PurchaseType purchases [])Which reads the data from iFile into purchases by:iFile contains rows of data which correspond to the elements of the PurchaseType struct. Iterate throughiFile inserting the rows of data, using str.find () str.substr(), into purchases until eof is hit.а.4. Uses a user defined function:void printPurchaseData (PurchaseType purchases [], int size)Which prints the data contained in purchases by:Using iomanip to nicely output all the data in a tabular format. You will need to calculate the total price foreach product purchased by multiplying the price of each product by the quantity purchased, and thenа.multiplying by the (tax rate + 1). See the example output for formatting.b. Keeping track of each total found and outputting the average total at the end of the table.c. Keeping track of the count of unique customers and outputting the total unique customers at the end of thetable. Enter file name**purchases1.csv| Customer ID | Product Name | Price | Quantity | Tax Rate | Total |A134CX2 Ishirt | 10.00 |1 |8.25 | 10.82 |pants | 15.95 |jacket | 24.49 |blouse | 19.99 |A134CX2 |2 |8.25 | 34.53 |8.25 | 26.51 |8.25 | 21.64 |8.25 | 16.22 |8.25 | 32.44 |8.25 | 35.66 |7.15 | 21.41 |7.15 | 80.33 |A134CX2 I1 |1 |1 |3 |4J3712I |pants | 14.98 |mittens Isocks | 10.98 |4J3712I |4J3712I |9.99 |4J3712I |3 1gloves |cap | 24.99 |earrings | 49.99 |B834621 |9.99 |2 |B834621 |3 11 |27G8ZZY |8.25 | 54.11 |Unique users:4Average total: $33.37

Here is the code according to the question requested.

Enter file name **purchasesl.csv +-- --- ------+ | Customer ID | Product Name | Price | Quantity | Tax Rate | Total | -+---- A134CX2 | A134CX2 | A134СХ2 | shirt | 10.00 | pants | 15.95 | jacket | 24.49 | blouse | 19.99 | pants | 14.98 | mittens | socks | 10.98 | 1 | 2 | 1 | 8.25 | 10.82 | 8.25 | 34.53 | 8.25 | 26.51 | 8.25 | 21.64 | 8.25 | 16.22 | 8.25 | 32.44 | 8.25 | 35.66 | 7.15 | 21.41 | 7.15 | 80. 33 | 8.25 | 54.11 | 4J37121 | 4J37121 | 4J37121 | 3 | 3 1 2 1 9.99 | 4J37121 | gloves | cap | 24.99 | earrings | 49.99 | B834621 | 9.99 | B834621 | 3 1 27G8ZZY | 1 | -+- +- Unique users: 4 Average total: $33.37

Enter file name **purchasesl.csv +-- --- ------+ | Customer ID | Product Name | Price | Quantity | Tax Rate | Total | -+---- A134CX2 | A134CX2 | A134СХ2 | shirt | 10.00 | pants | 15.95 | jacket | 24.49 | blouse | 19.99 | pants | 14.98 | mittens | socks | 10.98 | 1 | 2 | 1 | 8.25 | 10.82 | 8.25 | 34.53 | 8.25 | 26.51 | 8.25 | 21.64 | 8.25 | 16.22 | 8.25 | 32.44 | 8.25 | 35.66 | 7.15 | 21.41 | 7.15 | 80. 33 | 8.25 | 54.11 | 4J37121 | 4J37121 | 4J37121 | 3 | 3 1 2 1 9.99 | 4J37121 | gloves | cap | 24.99 | earrings | 49.99 | B834621 | 9.99 | B834621 | 3 1 27G8ZZY | 1 | -+- +- Unique users: 4 Average total: $33.37

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

# "New" means new compared to previous level provincial_capitals 'Yukon': 'Whitehorse', 'Manitoba': 'Winnipeg', 'BC': 'Victoria', 'Ontario': 'Toronto' input () while province_name != 'exit': province_name if province_name in provincial_capitals: print (provincial_capitals [province_name]) del provincial_capitals [province_name] # New line else: print ('x') province_name input () U Input Yukon BC Yukon lowa exit Output
ELéarning What happens when the user clicks on submit button in the form ? O d. NOT all fields of the form will be automatically stored in the $_POST array. O b. all fields of the form will be automatically stored in the $ POST arroay. all fields of the form stored in the $ POST array and the user must enter the values. all fields of the form will be automatically stored in the $_GET array.
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles Questtion: mov edx,[myDoubles + edi] ; EDX =?
php script
DO NOT COPY FROM OTHER WEBSITES
Lect 1A: linked-list HW 1 link list : Create Visual C++ project and. Due Tomorrow, 4:00 AM Posted 3:19 PM Project name should be 'HW1+student name for example 'HW1 Ahmed Ali Ahmed' 18 -Compress the project file as zip file and upload it here. -Screenshots for the entire codes and classes Turned in Assigned -Screenshot for the result. View assignment تسجبل محاطرة يوم 5/5/2021 Posted 3:14 PM ...
Rent a Car Using Mysqli (procedural or object) Commands (not the pdo): A company wants to record their cars with the followingproperties in order to give chance to the customers to make a search: Cars should be recorded with the following fields.: Car plate(primary key), make, model, car type. (Car types are listed as: mini, economy, luxury, convertible, sports, mini van) You must create 3 forms( 1 html for menu and 2 self-calling phpfiles) and a mysql table (which has the above fields). 1. Menu as html which will have link to other files. 2. A Form to add a new car into db table. (Hint: car type mustbe drop down list based on the types listed above. Plate shouldprimary key.) 3. A form to search a car. Search could be made via using any of the following threecriterias: i. Based on plate ii. Based on Make iii. Based on car type
.</tr> </table> </form></body></html>.
I need the answer as soon as possible
body { font-family: Georgia, serif; font-size: 100%; line-height: 175%; margin: 0 15% 0; background-color:rgb(210,220,157); background-image: url("/Users/332bo/Desktop/Week_9_Lab/images/bullseye.png"); /* Rounded Shape image */ background-repeat: no-repeat; background-size: contain; } header { margin-top: 0; padding: 3em 1em 2em 1em; text-align: center; border-radius:4px; background-color:hsl(0, 14%, 95%); background-image: url("/Users/332bo/Desktop/Week_9_Lab/images/purpledot.png"); background-repeat: repeat-x; } a { text-decoration: none; color:rgb(153,51,153); } a: visited { color: hsl(300, 13%, 51%); } a: hover { background-color: #fff; } a:focus { background-color: #fff; } a:active{color:#ff00ff;} h1 { font: bold 1.5em Georgia, serif; text-shadow: 0.1em 0.1em 0.2em gray; color: rgb(153,51,153);} h2 { font-size: 1em; text-transform: uppercase; letter-spacing: 0.5em; text-align: center; color:rgb(204,102,0); }dt { font-weight: bold; } strong { font-style: italic; } ul {…
3. Which among the following shows a valid use of the Direction enumeration as a parameter to the moveCharacter function? Select al that apply. enum Direction { case north, south, west, east}func moveCharacter(x: Int, y: Int, facing: Direction) {// code here} moveCharacter(x: 0, y: 0, facing: .southwest) moveCharacter(x: 0, y: 0, facing: Direction.north) moveCharacter(x: 0, y: 0, facing: .south) moveCharacter(x: 0, y: 0, facing: Direction.northeast)
A bucket list is a collection of goals, dreams, and aspirations that you would like to accomplish within your lifetime. The purpose of this assignment is to develop a program that allows the user to manage their personal bucket list and save it to an XML file bucketlist.xml. For full credit, run the program and create a file with at least three entry elements. Submit a document containing a copy of the source file, a screenshot of the program in action, and the contents of the XML file. File Structure Below is the basic structure (i.e. schema) for the XML file. You may add additional elements. <bucketList> <entry> <rank></rank> <description></description> <status></status> </entry> </bucketList> Note: Before running the program, manually create an XML input file with at least one entry element that contains values in each child element. GUI Requirements At a minimum, your GUI must meet the below requirements. No minimize…