i need help with this assignment

MGMT 3343 Assignment 3 Instructor: Dr. St. John ANGELO STATE UNIVERSITY MENTOR PROGRAM CASE QUESTIONS ANGELO STATE University is a four-year university located in the Big Country region of Texas. Drow an E-R data model for the Angelo State University Mentor Program Information System (this particular program is not a real program). Use the IE Crow's Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinalities. Your model should track students, advisers, and mentors. Additionally, Angelo State University needs to track alumni because the program odministrators view alumni as potential mentors. 1. Create separate entities for students, alumni, faculfy advisers, and mentors using the information below. Use proper ERD format (each entity as a box, name of entity at the top followed by attributes below). At Angelo State University, all students are required to live on campus and are assigned Angelo State University ID numbers and email accounts in the format FirstName.LastName@students.angelo.edu. The student entity should track student. last name, student first name, student University ID number, student email address, dorm name, dorm room number, and dorm phone number. Assignment 3 Ntached Files: 9 ASU MENTOR PROCRAM CASE PROELEM doo At (16.372 KB) MGMT 3343 Manngement Information Systems Fall 2022 Assignment 3 Individual Assignment Instructor: Dr. St. John Assignment: Please download attached assignment 3 (Word document). Complete the assignment and turn it in here on Blackboard. Required: 1. Using proper ERD techniques create the four separate entities and their attributes. 2. One ERD showing relationships and cardinality. 3. Turn in to Blackboard as a Word document. Due by midnight on Sunday. September 18,2022