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 FASTNational 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 EntityRelationship 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:
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
