MIS 2113 HW#2 AO: Name OUID Create the following ERDs. Please print this page and draw your ERD's on it and turn it in AT THE BEGINNING of the class, also scan or take a picture to submit it on Canvas Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Draw the diagram under the questions. Apply all 4 ERD rules. 1. Movies have many actors. An actor may only act in one movie. Actors have a first name, last name and age. A movie has a duration and a director. (10 points) 2. A car can have several passengers. But a passenger can only ride in one car. A car has a vin number, model, and year. A passenger has a first name and last name. (10 points) 3. A user can own several computers. A computer may be owned by users. A user will have a username and password. A computer will have a brand and model. (15 points) HW#2 AO: MIS 2113 4. Ateacher may teach many students at a school. A student may see many different teachers at a school. A teacher has a first name and last name. Student has first name, last name and age. (15 points) 5. A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a city, state, and phone number. Organizations have number of volunteers, an organization name and a founder. (15 points) 6. A new grocery store is opening that specializes in fruit. The owner wants to create her own database to track all the fruit she sells. Currently, she doesn't plan to sell anything other than fruit. For now, the owner only needs to keep track of each fruit's weight, size, and price. She only keeps track of the customer's first name, last name, and email address. She only keeps track of an order's sale date. Create the entity-relationship diagram (ERD) that represents fruit, customers, and orders. (35 points - partial credit given)