Answered step by step
Verified Expert Solution
Link Copied!

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 3.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 sec01, sec02, 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.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.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.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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part I Lnai 8724

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448475, 978-3662448472

More Books

Students also viewed these Databases questions

Question

3. What should a contract of employment contain?

Answered: 1 week ago

Question

1. What does the term employment relationship mean?

Answered: 1 week ago