Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you figure out by considering an erd for a university that has a superclass of EMPLOYEE with two subclasses, FACULTY and STAFF. The entity

Can you figure out by considering an erd for a university that has a superclass of EMPLOYEE with two subclasses, FACULTY and STAFF. The entity class EMPLOYEE has an attribute of type. The attribute type serves as the only constraint that determines whether or not a record is FACULTY or STAFF. Choose the most appropriate description for the relationship between the subclasses and the superclass. Find out which right: a. Subclasses are representative as attribute defined specialization b.Subclasses are representative of a user defined specialization. c.Subclasses are not classified as a specialization

Please figure out by Considering an ERD for a university that keeps track of a superclass of STUDENTS that has two subclasses: GRADUATE and UNDERGRADUATE. The GRADUATE subclass has two of its own subclasses: TEACHING_ASSISTANT and RESEARCH_ASSISTANT. The graduate students at this university are expected to serve as either a TA or an RA, but cannot serve as both at the same time. Select the terms that best describe this specialization. Can you guess which is right? a.Total and disjoint. b. Partial & overlapping c. Total & overlapping. Get the correct response.

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_2

Step: 3

blur-text-image_3

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

Building The Data Lakehouse

Authors: Bill Inmon ,Mary Levins ,Ranjeet Srivastava

1st Edition

1634629663, 978-1634629669

More Books

Students also viewed these Databases questions