Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started