Background: Your best friend Sally Thierman started an online bookstore in 2020. She needs a database to track the information on books, authors, customers, and sales. You suggested Sally develop the database in Microsoft Access since its simple and free. Sally has no background in Access or information systems. You promised to help her and made a plan below.

Step 1. Following the UML class diagram, draw an REA model for the business process. Information: Each author may write many books. Each book may have multiple authors. Each customer can purchase many books in a single transaction. Copies of the same book can be sold to different customers. Once an order is processed, the books are shipped right away. Required: (1) Given this information, you decide to use four classes for this model: Book, Sale, Customer, and Author. The model should include multiplicities.

(2) Determine how many tables you need and name each table. Note: For a many-to-many relationship, you need to create a new table.

(3) Identify the primary key for each table. Identify foreign keys for each association.