Chat with AI
Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Edition 7ISBN: 978-1111219512Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Edition 7ISBN: 978-1111219512 Exercise 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.
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.
Explanation
Verified
Verified
Intersection operation of the database w...
Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
