A,B, and C

Relational database design. In many business processes, resources and agents have no relationship outside the context of a specific event. For example, a customer has no relationship with an inventory item unless the customer buys the item. A REA model of that scenario appears below However, in some situations, an agent has a relationship with a resource outside the context of a specific event. Consider, for example, the relationship authors have with books: a single book can have many authors, and a single author can have many books, whether the books are sold is another matter. Here is a REA model of that scenario: How many tables would he required m a relational database of the second REA model ' Justify your response. For each table indicated by the second REA model, indicate: its name, its primary key. and at least two additional fields. Update the second REA model by adding the event "revise book." Create appropriate cardinalities. Indicate any additional table(s) that would be required; specify needed primary and foreign keys for any additional tables. Excel application. Consider the data array below (also available in the 3 February 2014 post in my AIS blog)