Extend and modify the E$-$R data model you created in part B to allow more data to be

recorded in the MPIS system. Use the IE Crow$$s Foot E$-$R model for your E$-$R diagrams.

Justify the decisions you make regarding minimum and maximum cardinalities. The

MPIS needs to record:

$$ The date a student enrolled at Highline University, the date the student

graduated, and the degree the student received.

$$ The date an adviser was assigned to a student and the date the assignment

ended.

$$ The date an adviser was assigned to work with a mentor and the date the

assignment ended.

$$ The date a mentor was assigned to a student and the date the assignment

ended.

D$.$ Write a short discussion of the difference between the three data models you have

created. How does data model B differ from data model A$,$ and how does data model C

differ from data model B$?$ What additional features of the E$-$R data model were

introduced when you created data models B and C$?$

For Part A$,$ B$,$ and C you can use MS Visio or ERD Plus tool. You are required to submit ERDs for

each section. I can only provide full grade if all answers$/$diagram are labelled precisely.

Part A Section $1$ you need to have individual entity

Part A Section $2$ you need to join all individuals entities based on relationships defined

Part B $$ You need to provide revision to Part A$-$ Section $2$ based on criteria defined in the

question.

Part C$$ You need to provide revision to Part B based on criteria defined in the question.