Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Activity 3 . 1 : Fix the extended ERD Instructions: You are required to fix ( draw and make changes ) the ERD given below
Activity : 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 ER
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 sec and sec
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 : Translate Relational Schemas
Instructions:
Translate relation schemas of an extended ER diagram.
For this activity, use the Extended ER diagram drawn for Activity
Translate the EERD 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
Fill in the blanks
Student dots,
StudentPhone
PostGrad dots,dots,dots
UnderGrad dots,dots,dots,dots,dots,dots
Tutor dots,dots,dots,dots
TA dots,dots,dots,dots,dots,dots
Enter text here
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started