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

Customers CustomerID INT ◆ FirstName VARCHAR(50) ◆ LastName VARCHAR(50) H > Email VARCHAR(100) > Address TEXT Indexes F | Orders OrderID INT > CustomerID INT > OrderDate DATE ◆ TotalAmount DECIMAL (10,2) Indexes # ShippingInformation ShippingID INT > OrderID INT → ShippingAddress TEXT ShippingDate DATE -K > EstimatedArrivalDate DATE → ShipmentStatus VARCHAR(50) Indexes Reviews ReviewID INT > ProductID INT > CustomerID INT ◆ Rating INT Comment TEXT > DatePosted DATE Indexes OrderDetails OrderDetailID INT ▶I > OrderID INT HI-KO ProductID INT → Quantity INT Subtotal DECIMAL (10,2) Indexes T Categories CategoryID INT ◆ CategoryName VARCHAR(255) Indexes Products ProductID INT -H ProductName VARCHAR(255) > Description TEXT ◆ Price DECIMAL (10,2) -I+ CategoryID INT > DiscountID INT Indexes Discounts DiscountID INT ◆ Discount Code VARCHAR(50) ◆ Discount Percentage DECIMAL (5,2) > StartDate DATE > EndDate DATE Indexes For the design above, Write in SQL a query to print customer names who made…
mysql> DESC bookauthor; mysql> DESC author; mysql> DESC book; | Field | Туре | Field | Туре | Field Тур | int(11 | varchai author_order | int(11 royaltyshare | decima: author_id isbn | author_id | int(1: | ssn lastname | firstname | varch: | phone | address | city | state | zip | varch: | varch: isbn var I name | type pub_id I price | advance I ytd_sales I pubdate var var | varch: | varch: | varch: | varch: | varch: | int dec | dec int mysql> DESC bookeditor; | dat | Field | Туре mysql> DESC editor; mysql> DESC publisher; editor_id | int(11) | varchar(1 | Field isbn | Field | Туре editor_id ssn pub_id | int(11) | varchar(40) varchar(40) varchar(20) varchar(2) lastname name firstname address | phone editor_position salary | city state
Sname ood postal Cade STREET 1ocates in CITY COUNTRY locato ig Cnome Which of the following is TRUE for the given ERD? Select one: a.Primary Key of COUNTRY is (cname, ctname, sname} b.Primary Key of STREET is (cname, ctname, sname} c.Primary Key of CITY is {ctname, sname} d.Primary Key of STREET is {ctname, sname}
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12
Select distinct a.CUST_FNAME, a.CUST_LNAME, a.CUST_STREET, a.CUST_CITY, a.CUST_STATE, a.CUST_ZIP from LGCUSTOMER a, LGBRAND b, LGPRODUCT c, LGINVOICE d, LGLINE e Where a.CUST_CODE = d.CUST_CODE And b.BRAND_ID = c.BRAND_ID And d.INV_NUM = e.INV_NUM And c.PROD_SKU = e.PROD_SKU And b.BRAND_NAME = 'Foresters Best' And PROD_CATEGORY = 'Top Coat' And d.INV_DATE > '2017/07/15' And d.INV_DATE < '2017/07/31' Order By a.CUST_STATE, a.CUST_LNAME, a.CUST_FNAME; However it is not ordered correctly? Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between 2017-7-15, and 2017-7-31. If a customer purchased more than one such product, display the customer’s information only once in the output. Sort the output by state, last name, and then first name
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)
Create a JavaScript Arrow function that meets the following requirements: _missingSpace(string)• Authored using arrow expression syntax (constant name _missingSpace)• The function is passed a string argument• The function inserts a white space between every instance of a lowercase character followed immediately by an uppercase character, and returns the modified string, with whitespaces, back to the caller.• Console log output is NOT permitted.• The function should pass each of the illustrated examples below at a minimum._missingSpace(“”) → “”_missingSpace(“a”) → “a”_missingSpace(“A”) → “A”_missingSpace(“Ba”) → “Ba”_missingSpace(“aB”) → “a B”_missingSpace(“BaB”) → “Ba B”_missingSpace(“GeorgeBrownCollege”) → “George Brown College”_missingSpace(“SheWalksToTheBeach”) → “She Walks To The Beach”_missingSpace(“TheGreatUpset”) → “The Great Upset”
Stal >>> Run PS6_P2_solution.py Vehicle: Make: Tesla Model: Model 3 Year: 2022 Age: 1 years Vehicle: Make: Ford Model: F-150 Year: 2020 Max Load: 10000 lbs Age: 3 years Can the truck carry 11000 lbs? No >>>
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
Which of the following is true if the property value of a name-value pair added by an element with an itemprop attribute is a time element? a) The value is the element’s datetime value b) The value is the value of the element’s content attribute, if any, or the empty string if there is no such attribute c) The value is the value of the element’s value attribute, if it has one, or the empty string otherwise d) The value is the element’s textContent
consumers for residential housing. Your task is to create an application to be used by the loan officers of the company when presenting loan options to its customers. The application will be a mortgage calculator that determines a monthly payment for loans. The company offers 10-, 15-, and 30-year fixed loans. The interest rates offered to customers are based on the customer’s credit score. Credit scores are classified into the following categories: Table 1: Credit Score Categories Rating Range Excellent 720-850 Good 690-719 Fair 630-689 Bad 300-629 The program should initially prompt the user (the loan officer) for the principle of the loan (i.e. the amount that is being borrowed). It should then ask him or her to enter the customer’s credit score. Based on the customer’s credit score, the program will randomly generate an interest rate based on the following ranges: Table 2: Interest Rate Assignments…
Monthly Sales Create a program that allows you to view and edit the sales amounts for each month of the current year. Example COMMAND MENU add - Add sales for specified month view - View sales for specified month edit - Edit sales for specified month totals - View sales summary for year exit - Exit program Command: add Three-letter Month: jan Sales Amount: 10317 Sales amount for Jan is 10,317.00. Command: add Three-letter Month: feb Sales Amount: 15293 Sales amount for Jan is 15,293.00. Command: view Three-letter Month: jan Sales Amount: 14317 Sales amount for Jan is 14,317.00. Command: edit Three-letter Month: jan Sales amount for Jan is 14,317.00. Command: totals Yearly total: 29,610.00 Monthly average: 14,805.00 Command: view Three-letter Month: july Invalid three-letter month. Command: exit Bye! Specifications The program should use a list to store the sales data for each month with the three-letter abbreviation for the month (Jan,…