Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann

تمرين 4

Richards Company's accounting system uses a relational database management system. The system includes a customer master file. If a customer has not made a purchase in over 18 months, the customer's record is moved from the active customer master file to the inactive master file. The tables on the next page are for the customer master files.
Active Customer Master File

Inactive Customer Master File

Required:
Suppose that next week you are going to be in London, England, and want to call on all your company's customers, whether active or inactive, who are located there. What database operations would you perform on the two tables to produce one table with the names of the customers who are located in London? Draw your new table.