You must use Microsoft Visio to create most of the ERD, then use OneNote, Paint Word or other applications to add in the Supertype Subtype notations. Part 1. For below PRODUCT data model a. List all of the attributes of a movie. 2. Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why or why not? Part 2. Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. employees, the beginning date and end dates of their contract are stored along with the billing rate for their hours