Fig. 13.2E-R models for an Employee/Qualification problem
(a)Qualification represented as a separate entity table
(b)Annotation denoting absence of Qualification table
(c)QualOfEmp as an entity type. Each occurrence of this entity represents the name-of-a-
qualification-held-by-a-particular-employee, not just the name-of-a-qualification; hence the degree of
the EQ relationship is 1:many. EQ is represented by the pre-posted identifier employeeNo in
QualOfEmp
Question
1.For the Fig. 13.2a model, should the Qualification table contain all the
qualifications recognised by the enterprise, or should it contain only those not present
in the QualOfEmp table?(2 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.