// Each time a salesperson sells a car at the // Pardeeville New and Used Auto Dealership, // a record is created containing the salesperson’s // name and the amount of the sale. // Sales of new and used cars are kept in separate files, // sorted by salesperson ID number. // Management has requested a merged file so that // all of a salesperson’s sales (both new and used cars) // are displayed together. The following code is intended // to merge the files. start    Declarations       string newSalesperson       num newAmount       string usedSalesperson       num usedAmount       string bothAtEof = "N"       string HIGH_NAME = "ZZZZZ"       InputFile newSales       InputFile usedSales       OutputFile allsales    getReady()    while bothAtEof = "Y"       detailLoop()    endwhile    finish() stop   getReady()    open newSales "NewSales.dat"    open usedSales "UsedSales.dat"    open allSales "AllSales.dat"      input newSalesperson, newAmount from newSales    if eof then       usedSalesperson = HIGH_NAME    endif      input usedSalesperson, usedAmount from usedSales    if eof then       usedsalesPerson = HIGH_NAME    endif      if newSalesperson = HIGH_NAME AND usedSalesperson = HIGH_NAME then       bothAtEof = "Y"    endif return   detailLoop()    if newSalesperson > usedSalesperson then       output usedSalesperson, usedAmount to allSales       input newSalesperson, newAmount from newSales       if eof then          usedSalesperson = HIGH_NAME       endif    else       output newSalesperson, newAmount to allSales       input usedSalesperson, usedAmount from usedSales       if eof then          newSalesperson = HIGH_NAME       endif    endif    if newSalesperson = HIGH_NAME AND usedSalesperson = HIGH_NAME then       bothAtEof = "Y"    endif return   finish()    close newSales    close usedSales    close allSales return

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
icon
Related questions
Question

// Each time a salesperson sells a car at the

// Pardeeville New and Used Auto Dealership,

// a record is created containing the salesperson’s

// name and the amount of the sale.

// Sales of new and used cars are kept in separate files,

// sorted by salesperson ID number.

// Management has requested a merged file so that

// all of a salesperson’s sales (both new and used cars)

// are displayed together. The following code is intended

// to merge the files.

start

   Declarations

      string newSalesperson

      num newAmount

      string usedSalesperson

      num usedAmount

      string bothAtEof = "N"

      string HIGH_NAME = "ZZZZZ"

      InputFile newSales

      InputFile usedSales

      OutputFile allsales

   getReady()

   while bothAtEof = "Y"

      detailLoop()

   endwhile

   finish()

stop

 

getReady()

   open newSales "NewSales.dat"

   open usedSales "UsedSales.dat"

   open allSales "AllSales.dat"

 

   input newSalesperson, newAmount from newSales

   if eof then

      usedSalesperson = HIGH_NAME

   endif

 

   input usedSalesperson, usedAmount from usedSales

   if eof then

      usedsalesPerson = HIGH_NAME

   endif

 

   if newSalesperson = HIGH_NAME AND usedSalesperson = HIGH_NAME then

      bothAtEof = "Y"

   endif

return

 

detailLoop()

   if newSalesperson > usedSalesperson then

      output usedSalesperson, usedAmount to allSales

      input newSalesperson, newAmount from newSales

      if eof then

         usedSalesperson = HIGH_NAME

      endif

   else

      output newSalesperson, newAmount to allSales

      input usedSalesperson, usedAmount from usedSales

      if eof then

         newSalesperson = HIGH_NAME

      endif

   endif

   if newSalesperson = HIGH_NAME AND usedSalesperson = HIGH_NAME then

      bothAtEof = "Y"

   endif

return

 

finish()

   close newSales

   close usedSales

   close allSales

return

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
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
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education