EECS3421-B-Project 1 Solved

In this project, you are to develop an entity-relationship schema / diagram for the Canadian International Photography Award domain described below. Draw an E/R diagram, clearly identifying the

•       entity sets,

•       relationship sets,

•       multiplicity (e.g., many-one's & many-many's),

•       attributes,

•       keys, and

•       additional constraints

In this project, we use the notations and diagramming rules — the Stanford dialect of E/R — as described in the textbook and in class.

E/R Dialects (Warning!) 
The textbook and our examples in the lectures use the Stanford style of E/R modelling. Note that there are many dialects of E/R, however. For consistency, for this project, you must adhere to the Stanford (the textbook's) dialect.

Canadian International Photography Award (CIPA) 
The Canadian International Photography Award is an annual photography competition. The Canadian International Photography contest is held by Canadian Photographer Academy each year. CIPA celebrates outstanding standalone photos and images from around the world. The annual contest provides an opportunity for Canadian and international photographers and artists to enrich their career, and propelling them to an ever higher level of image-making profession. Each year, the CIPA contest is supported by various sponsors. Different sponsors from around the word support one or more CIPA annual contests. Each sponsor chooses a level of sponsorship for the year of contest that they want to participate.   

 
Photo Submissions: 

Each year, Canadian and international photographers can submit their photos to the CIPA contest. Each photographer can submit multiple submissions to different photo categories. A submission may assigned to multiple categories.    

To submit photos, a photographer needs to register once and provide the following information: 

•      Name 

•      Date of birth 

•      Country 

•      phone 

•      email 

 

When registration is completed, a unique registration ID will be issued for each photographer. The registration ID can be used for future submissions and future CIPA contests. A photographer that has registered before does not need to register again.   

 

The following information is required for a submission (photo/image): 

•      Caption 

•      Size 

•      Format 

•      Description 

Each submission can fall into one or more of the following photography categories: 

•      Landscape 

•      Wildlife 

•      Sports/Action 

•      Portrait 

•      Architectural 

•      Fashion 

In the submission process, a photographer chooses a submission to the Featured Exhibition submission or the Open Call Exhibition submission.

Featured Exhibition Submissions 

The Featured Exhibition submissions will be in a competition to win the CIPA Annual Awards.  

 

Open Call Exhibitions Submissions 
Some of the Open Call Exhibition submissions may be published in the Canadian Photo magazine for the year of the CIPA contest. The Photo magazine is published once a year. Each magazine has a title, the name of the Editor-in-chief, and an URL (the link to the magazine website for that year).   

CIPA Photography Award Members
CIPA invites experts in the fields of art to join CIPA as members. The first time an expert becomes a member, a unique member ID is assigned to them.

A member of the CIPA may participate in CIPA contest over different years. A member can be either a silver or a golden nominator. CIPA stores the member information such as name, email, address, and the area of expertise.  

CIPA Silver Nominators 
Silver nominators are CIPA members. They nominate submissions submitted as Featured 

Exhibition submissions. Each silver nominator nominates a single submission to be added to the Silver list. The silver nominator adds her/his comments and a score for her/his nominated submission to be in the Silver list (nominees). These nominees will be later selected by golden nominators to be added to the Golden list as candidates of the CIPA awards.  

CIPA Golden Nominators 
The golden nominators are also CIPA members consist of national and international experts working in the field of art and photography. Golden nominators select the final nominees from the Silver list to be added to the Golden list for the final competition. They add comments about the selected Golden nominees to highlight the excellent technical, creative skills, and exceptional qualities of each nominee. Each golden nominator selects one nominee from the Silver list to be added to the Golden list. The final award winners of the year of contest are selected from the Golden list.

CIPA Photography Award Nominees 
First, the Featured Exhibition submission are nominated by the silver nominators and will be added to a list named the Silver list. Later, the nominees in the Silver list will be selected for the final evaluation by the golden nominators be added to the Golden list.  

 

CIPA Photography Awards 

          Award Name                  Prize 
•      Diamond Image Award          $100,000

•      Golden Image Award             $70,000

•      Royal Image Award    $40,000

CIPA award winners are selected from the nominees in the Golden list. The prize of each award could be different in every year contest. A nominee from the Golden list can win multiple awards in the year of the competition. An award, however, can be won by exactly one nominee from the Golden list for that year.  

Design Considerations 
This design exercise is meant to simulate a real life system-analysis situation; hence, the domain description above is unstructured, and sometimes fuzzy. It is your responsibility as an analyst / designer to translate what you read into a proper E/R diagram that models the domain correctly. Keep the following things in mind for your design.

1.      In real life, many more data elements than described in the “requirements” above would be needed to build a useful database. We do not, however, want to turn this project into something huge. So keep in mind that this is a highly simplified case.

2.      As a general approach, if a particular constraint is not explicitly given, then assume the least restricted situation. For example, “many” in the E/R Model is less restricted than “at most one”.

3.      You are not required to specify the domains of the attributes here in your diagram.

4.      Make certain that you clearly indicate any constraints in your design that are additional to those captured in the logic of your E/R diagram.

That is, state any constraints that are indicated by the requirements, but that you know are not enforced by your design in brief documentation attached with your design. For each such case, explain whether the unenforced constraint is

o    beyond the scope of E/R, o        seems to be beyond the scope (but you do not know for certain), o             would greatly complicate the design beyond value, or o    is simply not accommodated in your design.