Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( 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.
image text in transcribed

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

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

Students also viewed these Databases questions

Question

Discuss the key people management challenges that Dorian faced.

Answered: 1 week ago

Question

How fast should bidder managers move into the target?

Answered: 1 week ago