Answered step by step
Verified Expert Solution
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
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
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