Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Question
-
The fields below repeat for each customer:
o Customer name (String)
o Customer ID (numeric integer) o Bill balance (numeric)
o EmailAddress (String)
o Tax liability (numeric or String)
The customers served by the office supply store are of two types: tax-exempt or non-tax- exempt. For a tax-exempt customer, the tax liability field on the file is the reason for the tax exemptions: education, non-profit, government, other (String). For a non-tax exempt customer, the tax liability field is the percent of tax that the customer will pay (numeric) based on the state where the customer’s business resides.
Program requirements:
From the information provided, write a solution that includes the following:
-
A suitable inheritance hierarchy which represents the customers serviced by the office supply company. It is up to you how to design the inheritance hierarchy. I suggest a Customer class and appropriate subclasses..
-
For all classes include the following:
o Instance variables o Constructors
o Accessor and mutator methods o Suitable toString() methods
o Any other appropriate methods
Write a class xxxx_program5 which utilizes the following:
o An Array of Customer objects
o A method which reads the input file provided and stores the objects in the array of Customers.
o A method which sorts the array of Customers in ascending order by the customer ID.
o A method that formats and prints the output report. The report should include the following requirements:
-
Report header at the start of each page showing the name of the company, report and page number.
-
Report headers for each column of information.
-
One Customer per line.
-
At most 45 Customers per page.
-
All money amounts and percentages should be displayed with 2
decimal places and commas after each thousand.
o A sample report is shown at the end of the assignment. The report produced does not have to exactly match the sample output provided but must contain all required components listed above.
Theres no way for me to upload the txt file
Transcribed Image Text:100
900 Amazon purchasing@amazon.com 20000. 0
210 Nordstrom purchasing@nordstrom.com 50000.0
10 Rutgers purchasing@rutgers.edu 32000.0
520 Alamo purchasing@alamo.com 23000.0
1 Kean purchasing@kean.edu 158000.5
100 Allied purchasing@allied.com 85300.0
950 JoesInc purchasing@joesinc.com 999999.0
697 BostonU purchasing@tufts.edu 340020.23
310 TruckersInc purchasing@truckersinc.com 55000.0
820 Clothiers purchasing@clothiers.com 20044.0
849 RedCross purchasing@redcross.org 48900.2
125 ChocolateRus purchasing@chocolate.com 3000.5
535 CareBear purchasing@carebear.com 6000.0
331 BalloonInc purchasing@balloon.com 5100.5
345 TiresInc purchasing@tires.com
211 JeweleryInc purchasing@jewelery.com 52000.0
2 Vassar purchasing@vassar.edu 53000.0
521 Hertz purchasing@hertz.com 22200.0
9 JCU purchasing@jcu.edu 135678.5
120 Enterprise purchasing@enterprise.com 75300.0
958 Avis purchasing@avis.com 89999.0
699 Tufts purchasing@tufts.edu 340020.23
910 Truckers2Corp purchasing@truckers2corp.com 55000.0
825 LandsEnd purchasing@landsend.com 20054.0
853 TheFutureProject purchasing@tfp.org 48920.2
225 Bromilows purchasing@bromilows.com 3300.5
539 Thrifty purchasing@thrify.com 6600.0
339 FlowersRus purchasing@flowers.com 59300.5
660 Prudential purchasing@prudential.com 28900.0
567 MassMutual purchasing@massmutual.com 5890.0
111 Montclair purchasing@montclair.edu 39800.0
578 SaveTheChildren purchasing@savechildren.com 28760.0
154 NJDOE purchasing@njdoe.gov 158000.5
333 ShopRite purchasing@shoprite.com 82100.0
943 Turtles purchasing@turtles.com 88888.0
901 Brandeis purchasing@brandeis.edu 340020.23
610 TruckersRus purchasing@truckersrus.com 54000.0
821 Clothier&Son purchasing@clothiersson.com 20044.0
823 MLH purchasing@mlh.org 900.2
725 Calandras purchasing@calandra.com 43000.5
536 PinkElephant purchasing@pinkelephant.com 600.0
338 Essie purchasing@essie.com 5000.5
348 Uber purchasing@uber.com 1500.0
157 NYDOE purchasing@nydoe.gov 12000.5
213 Zales purchasing@zales.com 54300.0 0.07
322 Columbia purchasing@columbia.edu 54500.0
555 CheapCars purchasing@cheapcars.com 23210.0
99 NJIT purchasing@NJIT.edu 13978.5
0.08
0.07
education
0.05
education
0.06
0.03
education
0.10
0.05
non-profit
0.1
0.08
0.06
0.0
0.07
0.08
education
0.07
education
0.06
0.03
education
0.10
0.04
other
0.5
0.07
0.08
0.07
0.08
education
non-profit
other
0.07
0.08
education
0.08
0.05
other
0.7
0.05
0.07
0.05
other
education
0.09
education
Transcribed Image Text:358 DAV purchasing@dav.org 4860.2
852 LLBean purchasing@llbean.com 2234.0
238 ArthritisREU purchasing@arthritisreu.org 4890.2
902 Etsy purchasing@etsy.com 20400.0
212 BedBath purchasing@Bedbath.com 55000.0
11 UPenn purchasing@upenn.edu 350000.0
522 EnginesRus purchasing@enginesrus.com 23500.0
8 SetonHall purchasing@setonhall.edu 158090.5
108 TiresToGo purchasing@tirestogo.com 8300. 0
956 Billshop purchasing@billshop.com 9999.0
798 NorthEastern purchasing@northeastern.edu 40020.23
318 Chocolatiers purchasing@chocolatiers.com 59000.0
819 DunkinDonuts purchasing@dunkingdonuts.com 2044.0
850 DiabetesOrg purchasing@diabetes.org 4900.2
126 Beans purchasing@beans.com 1000.5
538 BabyGap purchasing@babygap.com 6100.0
334 PartyStore purchasing@partystore.com 500.5
349 Threads purchasing@threads.com 29000.0
218 ColorsInc purchasing@colorsinc.com 2000.0
12 CountyCollegel purchasing@ccl.edu 5000.0
531 BusinessRUs purchasing@businessrus.com 1200.0
109 CountyCollege2 purchasing@cc2.edu 1678.5
128 Business2 purchasing@business2.com 5300.0
959 Oleander purchasing@oleander.com 2999.0
698 Harvard purchasing@harvard.edu 34020.23
914 TaxisInc purchasing@taxisinc.com 5000.0
829 Jjill purchasing@jjill.com 2054.0
859 CSTA purchasing@csta.org 4820.2
229 Godiva purchasing@godiva.com 3100.5
540 DryCleaners purchasing@drycleaners.com 6800.0
332 Macys purchasing@macys.com 58200.5
669 CADOE purchasing@cadoe.gov.com 2900.0
561 Prudential purchasing@prudential.com 58290.0
112 Linden purchasing@linden.gov 3800.0
579 FoodPantry purchasingefoodpantry.org 25760.0
159 WADOE purchasing@wadoe.gov 18000.5
377 StopandShop purchasing@stopandshop.com 8100.0
953 WholeFoods purchasing@wholefoods.com 8888.0
907 FIT purchasing@fit.edu 30020.23
690 CarRentall purchasing@carrentall.com 5400.0
851 Officel purchasing@officel..com 2044.0
822 CodeHS purchasing@codehs.org 1000.2
727 Bakeryl purchasing@bakery1.com 4000.5
539 BabyToys purchasing@babytoys.com 6000.0
3 Google purchasing@google.com 500.5
19 NYYankees purchasing@nyyankees.com 15500.0
155 Census purchasing@census.gov 102000.5
110 Fridays purchasing@fridays.com 5300.0
328 CUNY purchasing@cuny.edu 5500.0
non-profit
0.03
other
0.03
0.05
education
0.06
education
0.06
0.08
education
0.03
0.06
non-profit
0.03
0.07
0.03
0.05
0.06
education
0.08
education
0.02
0.04
education
0.09
0.05
other
0.06
0.05
0.07
other
0.07
other
non-profit
other
0.06
0.06
education
0.04
0.05
other
0.07
0.04
0.01
0.07
other
0.06
education
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- most_frequent_word() takes a string as the input parameter and returns two values; the word that appears most frequently in that string and the total number of times that word appears in that string. In case of a tie, return the first word that appears in the string. Hint: you can use the unique_words function that you wrote in (4). Sample outputs:>>> data = “chapter one hottest day summer so far drawing close drowsy silence lay over large square houses privet drive cars usually gleaming stood dusty drives lawns once emerald green lay parched yellowing”>>> word = most_frequent_word(data)>>> print(word)('lay', 2)>>> data_2 = "a cat in a hat and a big black bear on a big black rug">>> word = most_frequent_word(data_2)>>> print(word)('a', 4)arrow_forwardCmplt. Complete.arrow_forwardLanguage in C# using Visual Studio in Windows Form app please. For the name files, just create a text file that has a few names for your time sake.arrow_forward
- In order for a player to navigate your game, you will need to develop a function or functions using Python script. Your function or functions should do the following: Show the player the different commands they can enter (such as “go North”, “go West”, and “get [item Name]”). Show the player’s status by identifying the room they are currently in, showing a list of their inventory of items, and displaying the item in their current room. You could make these separate functions or part of a single function, depending on how you prefer to organize your code. #Sample function showing the goal of the game and move commands def show_instructions(): #print a main menu and the commands print("Dragon Text Adventure Game") print("Collect 6 items to win the game, or be eaten by the dragon.") print("Move commands: go South, go North, go East, go West") print("Add to Inventory: get 'item name'") #In this solution, the player’s status would be shown in a separate function. #You may organize your…arrow_forwardINSERT INTO "students" ("courseId", "studentName", "studentEmail", "studentPhone") VALUES (1, 'X', 'Y', 555), (1, 'A', 'B', 8675309), ... ; ===================================================================================== We said you have to supply values for all of the columns. Why do you think that our insertion into the courses table was able to proceed without getting two values, given that it has two columns? Hint: it has to do with how we created the table and what the other column is.arrow_forward1. Creating Employee Data ( Page 625)Create an application that allows the user to enter the following employee data: First Name, Middle Name, Last Name, Employee Number, Department, Telephone Number, Telephone Extension, and E-mail Address. The valid values for department are Accounting, Administration, Marketing, MIS, and Sales. Once the data is entered, the user should be able to save it to a file. Figure 9-30 shows an example of the application’s form. The form shown in Figure 9-30 has a combo box for selecting the department; a Save Record button, which writes the record to a file; a Clear button, which clears the text boxes; and an Exit button. Write code in the Form_Load event handler that allows the user to enter the name of the file. If the file does not exist, a new one will be created. If the file already exists, the input data will be appended to the file. ******** Make sure to test your project by entering a new text file name, and then to confirm you are appending data to…arrow_forward
- Write a regular expression that matches the day of year such as "1-1-2018" or "7/4/1776". Dates like "9-31-1955", "3/29-2018", and"5-28/1956" should not be matched. You do not have to worry about leap years (i.e. assume February has 28 days every time). Edit View Insert Format Tools Table 12pt v Paragraph v A To 田 画 D O wordsarrow_forward>> classicVinyls.cpp For the following program, you will use the text file called “vinyls.txt” attached to this assignment. The file stores information about a collection of classic vinyls. The records in the file are like the ones on the following sample: Led_Zeppelin Led_Zeppelin 1969 1000.00 The_Prettiest_Star David_Bowie 1973 2000.00 Speedway Elvis_Presley 1968 5000.00 Spirit_in_the_Night Bruce_Springsteen 1973 5000.00 … Write a declaration for a structure named vinylRec that is to be used to store the records for the classic collection system. The fields in the record should include a title (string), an artist (string), the yearReleased (int), and an estimatedPrice(double). Create the following…arrow_forwardPLEASE COMMENT CODE In a python program, create a new file and call it “ tracking”. Write to it four lines each contains information about an order like this: 1-00654-021 Dell charger Toronto-WEST 99-49-ZAD011-76540-022 ASUS battery Milton-EAST 34-56-CBH561-09239-026 HP HD Scarborough-NORTH 12-98-AZC451-12349-029 Mac FD North York-LAWRENCE 34-49-ZWL01Add the file two more lines: 1-34567-055 Lenovo SSD Milton-ON 34-09-MT04 1-90432-091 Lenovo battery Oakville-ON 78-KL98 Define a function that searches for a brand (e.g. Dell, ASUS, etc.). Test the function in your program.arrow_forward
- Write a stored procedure named displayNumberOfFilmRatings(). The displayNumberOfFilmRatings () procedure should find number of films for each film rating and then display the film rating and the number for films having that type of rating. Note: The displayNumberOfFilmRatings() procedure does not need to declare any variables. Hint: The output should have two columns only. Hint: There is no need to use cursor processing for this stored procedure.arrow_forwardAssignment Submission Instructions:This is an individual assignment – no group submissions are allowed. Submit a script file that contains the SELECT statements by assigned date. The outline of the script file lists as follows:/* ******************************************************************************** * Name: YourNameGoesHere * * Class: CST 235 * * Section: * * Date: * * I have not received or given help on this assignment: YourName * ***********************************************************************************/USE RetailDB;####### Tasks: Write SQL Queries ######### -- Task 1 (Customer Information):-- List your SELECT statement below. Make sure the SQL script file can be run successfully in MySQL and show the outcome of the code on MySQLarrow_forwardInheritance and Polymorphism This assignment starts with the Account class from Labs 4 and 5. Our new and improved bank has two kinds of accounts, savings, and checking. In addition to an ID and a balance, savings accounts have an annual interest rate and a minimum balance. Checking accounts have a minimum balance and a monthly fee. Withdrawals and deposits can be made to both kinds of accounts. At the end of each month, savings accounts pay interest, but only if the account's balance is above the minimum. Also at the end of each month, a fee is deducted from each checking account, but the fee is waived if the account's balance is over the minimum. Tasks 1. Create a complete UML diagram which shows the relationships between the three classes, Account, Savings, and Checking and all of the fields and methods in each. The only modifications required to the Account class is the addition of two abstract methods called closeMonth and accountString. 2. The closeMonth function performs the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education