This segment of an ERD displays a specialization hierarchy with subtype/supertype relationships. Choose all business rules that are represented by this diagram.

This problem is scored right minus wrong answers, so it is not a good idea to guess.

I have given you a hardcopy of this ERD also in case you might find that easier to read.

Question 37 options:

a)	TRAINING is a subtype of MECHTRN.
b)	MECHTRN is a bridge table that was used to remove the many-to-many relationship between MECHANICS and TRAINING.
c)	All mechanics are specialized in avionics (AV) maintenance.
d)	Some mechanics can specialize in engine (EN) maintenance.
e)	Mechanics can only specialize in one area of maintenance.
f)	All mechanics are employees.
g)	DATE_HIRED is an attribute of MECHANICS.
h)	Some mechanics specialize in both EN and AF.
i)	MECHTRN has a strong relationship with TRAINING.
j)	All mechanics have to have at least one area of specialization.
k)	MECH_TYPE is the subtype discriminator for the MECHANICS to EN/AF/AV subtype relationship.
l)	There are 4 subtypes of MECHANICS.
m)	All employees are mechanics.
n)	Some mechanics can specialize in airframe (AF) maintenance.
o)	MECHANICS are not required to have MECHTRN (mechanical training).
p)	Some employees may just be regular employees rather than having to be mechanics.

Question 38 (2 points)

Referring to the Employee database above, is the JOBHIST table a weak entity or a strong entity?

Question 38 options:

a)	weak entity
b)	strong entity