Question

1- Paper evaluation scenario
a) Draw an ERD for the following relational schema:
STUDENT (STD_ID, STD_First_Name, STD_Last_Name, STD_Admit_Semester,
STD_Admit_Year, STD_Enroll_Status)
PAPER (PP_ID, PP_Title, PP_Submit_Date, PP_Accepted, PP_Type)
The two entities are related with the following business rule:
• Each student may write many papers
Explain your choice of minimum and maximum cardinalities.

b) Extend the existing ERD with an EVALUATOR entity. The job of the evaluator is to
grade each paper. The following business rules apply:
• Each paper is evaluated by at least 3 evaluators
Add four attributes of your choice to the EVALUATOR entity and extend the ERD. The
final solution must be an implementation ready ERD, which means you may need to add
additional entities or attributes to your ERD. In case you add additional entities, please
justify your choice of entities, primary keys, relationship types, and cardinalities.

I need this answer in Visual Paradigm please and also a very good reasoning for the cardinalities and extra entities

Answer 1

Fig:-Entity Relationship Diagram(ERD) for Paper evaluation scenario

Relational Scema:-

STUDENT (STD_ID, STD_First_Name, STD_Last_Name, STD_Admit_Semester,
STD_Admit_Year, STD_Enroll_Status)

Extra Field to be added for entity STUDENT;- STD_Email.

Cardinality :-

Maximum: N:N i.e Many Student can write many papers.

Minimum: 1:1 i.e One Student can write one papers .

PAPER (PP_ID, PP_Title, PP_Submit_Date, PP_Accepted, PP_Type)

Cardinality :-

Maximum: N:N i.e Many paper can write many Student.

Minimum: 1:1 i.e One paper can write one Student .

EVALUATOR(EV_ID,EV_First_NameEV_Last_NameEV_Email,EV_Phone)

Primary key:EV_ID

Cardinality :-

Maximum: N:N i.e One Evaluator can check many papers.

Minimum:N:1 i.e Many Evaluator can write one papers.

REVIEWER(REV_ID,REV_First_Nameute,REV_Last_Name,REV_Email,STD_Phone)

Primary key:REV_ID

Cardinality :-

Maximum: N:N i.e Many REVIEWER can reviews many papers .

Minimum: 1:1 i.e One REVIEWER can reviews one papers.