In: Computer Science
Create an ER diagram, a Relational Schema, and tables with Data, based on the following requirements:
The database will keep track of students and campus organizations.
- For each student, we will keep track of his or her unique student ID, and his or her name and gender.
- For each organization, we will keep track of its unique organization ID and the location.
- Each student in the database belongs to at least one organization and can belong to multiple organizations.
- Each organization in the database has at least one student belonging to it and can have multiple students.
- For every instance of a student belonging to an organization, we will record the student's function in the organization (e.g., president, vice president, treasurer, member, etc.).