1. [8 points} identify the tables from the given scenario. Book.com is an online virtual store on the Internet where customers can browse the catalog and select products of interest. ANSWER: Everyr book has a title, ISBN, vear and price. The store also keeps the author and publisher for am.r book. For authors, the database keeps the name, address and the URL of their homepage. For publishers, the database keeps the name, address, phone number and the URL of their website. The store has several warehouses, each of which has a code, address and phone number. The warehouse stocks several books. A book mailr be stocked at multiple warehouses. The database records the number of copies of a book stocked at various warehouses. The bookstore keeps the name, address, email-id, and phone number of its customers. A customer owns several shopping carts. A shop ping cart is identied bv a Shopping_{3ar't_ll]I and contains several books. Some shopping carts may,r contain more than one cop}.r of same book. The database records the number of copies of each book in anv shopping cart. At that time, more information will be needed to complete the transacti on. Usuallv, the customer will be asked to ll or select a billing address, a shipping address, a shipping option, and pavment information such as credit card number. An email notication is sent to the customer as soon as the order is placed