Question: ( a ) Create an Entity Relationship diagram that captures the information given in Text 1 about a conference management system. Be certain to identify

(a) Create an Entity Relationship diagram that captures the information given in Text 1
about a conference management system. Be certain to identify all entities, attributes,
primary keys, relationships and their cardinality. State any assumptions you make.
EasyConf is a Conference Management System used by several universities in
Mauritius. A conference is organized by a university, and focuses on a particular
research area. A conference often involves several sessions. A conference is
attended by several participants.
A conference is characterized by a conference number and a name. Every research
area is identified by a unique name. A session is characterized by a session
identifier and a name, and focuses on a specific research theme. A university is
characterized by a university code, name and address. A participant is
characterized by a participant number, their name, and the university he/she is
affiliated. A participant is affiliated to a single university only.
The following information should also be taken into consideration: the duration of
the conference and the venue of the conference. Moreover, participants who are
students benefit from a special registration price.
 (a) Create an Entity Relationship diagram that captures the information given

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!