Question: Make a ER diagram for the below scenario: The FAST - National University of Computer and Emerging Sciences has five different campuses, each of which

Make a ER diagram for the below scenario:
The FAST-National University of Computer and Emerging Sciences has five different campuses, each of which organizes various extracurricular activities by creating societies for the students. You are tasked with designing an Entity-Relationship Diagram (ERD) along with structural constraints for a university society management system. This system is intended to manage various university societies, and track student memberships, roles within societies, and society events. Following is the detailed information of entities, attributes, and relationships: 1
Each university campus has a name, single location, and unique ID and can host multiple societies. Each society has a unique name, unique ID, type, founded year and is associated with one campus. Students can be members of multiple societies, and each society can have multiple enrolled students. The students can be represented with unique student ID, first name, last name, email, date of birth, major, and year of study and can hold various roles within differnt societies. Each role can be assigned to multiple students with unique role ID, and name. Societies can organize multiple events, and each event is organized by one society and represented with unique event ID, name, date,location, and description.

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!