Activity $3\mathrm{.}1$: Fix the extended ERD

Instructions:

You are required to fix $($draw and make changes$)$ the ERD given below by 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 sec$01,$ 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 TotalPay 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.

Fuerv PostGrad in the datahase muct annear pither as Tutor or TA

You can use

draw.io to create your diagram.

Activity $3\mathrm{.}2$: Translate Relational Schemas

Instructions:

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,$-)$

Student$\_$Phone $(\_\_,)$

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

UnderGrad $(dots,$dots,dots,dots,dots,dots,dots$)$

Tutor $(dots,$dots,dots,dots,dots$)$

TA $(dots,$dots,dots,dots,dots,dots,dots$)$

Enter text here