Upon completion of this lesson, you will be able to:
This lessons introduces a set of patterns for mapping conceptual models to relational schemas.
n this video tutorial, Khoury Boston’s Prof. Schedlbauer explains how to map various associations, aggregations, multi-valued attributes, and generalizations to a relational schema. Generalization defines a specialization hierarchy of classes in a conceptual model. While some databases support generalization or type hierarchies, relational database do not. Nevertheless, there are ways to implement generalization in a relational model.
Slide Deck: Patterns for Mapping Conceptual Models to Relational Schemas
In summary, patterns simplify the process of mapping conceptuals models to table designs.
None collected yet. Let us know.