Acting on Outside Requests
Up until now databases have been designed with business goals in mind. But what happens if a request comes in from an external source with someone else’s goal as its focus? How can you extract the appropriate data from the database?
The last chapter looked at making permanent changes to your database in response to results of reports and changes in business strategy. This chapter considers answering queries without making permanent changes. Responding to outside requests involves using tools that are familiar to you in as creative a way as possible, including:
You also need to be able to identify when you are unable to answer a query with your existing data. For example, suppose ...