Question: Create the Schema (NOT ER Diagram) for a database that will keep track of students and campus organizations. For each student, we will keep track

Create the Schema (NOT ER Diagram) for a database that 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.).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!