Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

Students also viewed these Databases questions