Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

3.10 Generalization and Specialization

The process of generalization and its inverse, specialization, are two abstractions that are used to incorporate more meaning in EER diagrams.

3.10.1 Specialization

Often an entity set contains one or more subsets that have special attributes or that participate in relationships that other members of the same entity set do not have. For instance, in the University example whose ER diagram is shown in Figure 3.13, the Faculty entity set can be broken up into subsets, AdjunctFac and FullTimeFac. Adjunct faculty members teach part-time and are usually appointed on a temporary basis, while full-time faculty are regular employees who work on a continuing basis. Adjunct faculty members are paid per course, while ...

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.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595