You are required to fix $($draw and make changes$)$ the ERD given belowy taking into consideration of the following extended E$-$R

features:

PostGrad ISA Student with Advisor and YearStarted as attributes, where as UnderGrad ISA Student with Major, Section, and

Level attributes. Section is a composite attribute with $sec01,$ sec$02,$ and sec$03.$

A student is either a PostGrad or UnderGrad, but not both, at any moment.

Tutor ISA PostGrad with PayPerHr, Hours, and Total Pay as attributes. Note that Total Pay is derived from Hrs worked and

PayPerHr for each specific tutor.

TA ISA PostGrad with Course, Topic, and Date attributes. PostGrad can be both Tutor and TA at anytime.

A student has StudentNo, Name, Faculty, and Phone as attributes. Phone attribute in student entity allows more than one

phone numbers to be entered in the database.

Translate relation schemas of an extended E$-$R diagram.

For this activity, use the Extended E$-$R diagram drawn for Activity $3\mathrm{.}1.$

Translate the E$-$ERD into relation schemas, and make sure to indicate primary keys, foreign keys, and any other modeling

constraints that might be represented in the list of rules provided in Activity $3\mathrm{.}1.$

Fill in the blanks

Student $,$dots,dots $)$

Student$\_$Phone

PostGrad $(dots,$dots,dots,dots,dots,dots$)$

Tutor $(\{$:${?}_{,}$dots,dots,dots,dots,dots$)$

$TA{(}_{{?}_{?}},,,,,,$dots,dots,dots,dots,dots,dots$)$