Sweet Bayou Airlines (SBA) flight 494 departs daily from Shreveport for Nashville at 8:47 a.m. The manager of the SBA office in Shreveport must receive a file that combines to contents of the file sba494destination, which contains the confirmation number and final destination for each passenger, and the file sba494class, which contains the confirmation number and class of seat

(first, business, or coach) for each passenger. These combined data must also be searched for duplicate records to ensure no passenger is booked in multiple seats for the flight.

a. Append the appropriate value for the field Destination in the file sba494destination to each record in the file sba494class. Save your results as a file under the name sba494final.xlsx.

b. Search the file sba494final that you created in part (a) for duplicate records. Provide a list of the passenger names, destinations, seat, class, and confirmation for the duplicate records you find.