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. Apply all 4 ERD rules. 1. Students may pledge a single house. A house may have many student's pledge. For each student we want their name, age, email, and phone. For the house, we want the house name, address, all amenities, and year the house was founded. (15 points) 2. A student can declare a single major. A major may have many students. We would like to know the students name and address. We would like to know the major name, and college name. ( 15 points) 3. A student may be part of many organizations and an organization may have many students. We want to capture the students name, address, age, and all email addresses. We want to know the organization name, address, and description. We also want to know the year and the semester a student is part of an organization. (20 points)