Using Microsoft Visio. Create an ERD schema based on the following requirements for a simple college database Identify all the entities, relationships and attributes. State the cardinality of the relationship in each you don't think enough information is available to define either of these, state an assumption that makes it clear case. If Problem Statement: A college wants to track its departments, majors, faculty members, and students. The college has many departments. Each department has many faculty members, but each faculty is affiliated with one a only one department. A department has a department name. A faculty member has last name, first name, highest degree earned, title and email Each major has a name and description. A major is managed by only one department. Some departments do not offer any major, but some departments offer multiple majors. Each student needs to declare at least one major at the beginning of the first year. A student has last name, first name, email, and class year. Additionally, each student is advised by a faculty member, but not all faculty members advise students