Based on the description below, develop an EER diagram using draw.io. Don’t forget to denote…
Based on the description below, develop an EER diagram using draw.io. Don’t forget to denote entities (including supertypes and subtypes), attributes, relationships, and completeness/disjointness constraints. Howard University is putting together a student information database. Most people in the 1 database are undergraduate, graduate, or professional students, though there are some non-degree seeking students (i.e., students that are not formally enrolled in any college or program of study). Students can have only one classification/status at a time. For all students, they store an ID and name. Assume that students may have a first name, middle name, last name, and suffix (e.g. Edward William Brooke III) but some students go by just a first and last name (e.g., Chadwick Boseman). For undergraduates, they also record their major(s). Some undergraduates may not have a major. For graduate students (e.g., master’s, PhD), they store their program. Graduate students must be enrolled in a program, but can be dual-enrolled in multiple programs. For professional students (e.g., law, medicine), they track their program. Professional students must be enrolled in a single program.