Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. A database will be used by the organisers of a poster exhibition in order to track submission, selection and exhibition phases of posters. These

image text in transcribed

4. A database will be used by the organisers of a poster exhibition in order to track submission, selection and exhibition phases of posters. These phases are as follows: Submission Phase: Graphic designers design and submit posters to the exhibition. Relevant information on designers includes their name and their affiliation (the organisation they work for). Each poster has a title and is assigned an identification number. Posters may be created by several graphic designers; although each individual designer may only be involved with one poster Selection Phase: All posters created for this exhibition are judged by at least three different judges. A judge may vote for more than one poster. Relevant information about each judge includes their name, their affiliation and email. When judging a poster, a judge gives a decision: accept or reject. Presentation Phase. All selected posters are presented in the exhibition by one of their graphic designers. The poster presentation is allocated a stand and an exhibition session. Each exhibition session takes place at a specific date a. Below is an E-R diagram for this database. Provide appropriate names for all entities, relationships and types of relationships

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

Students also viewed these Databases questions