a. Which systems documentation technique would you use if your goal was to construct the relational database that supports the narrative? Why?

b. Regardless of your answer to (a), construct a complete REA model of the process.

c. Based on your REA model, identify four tables you would need in the relational database—one each for a resource, an event, an agent and a junction table. What would be each table’s primary key?

d. Based on the tables you created, suggest two queries the airline might create. For each query, indicate its name, its purpose and the fields involved.