Skip to Content
Information Modeling and Relational Databases, 2nd Edition
book

Information Modeling and Relational Databases, 2nd Edition

by Terry Halpin, Tony Morgan
July 2010
Intermediate to advanced content levelIntermediate to advanced
976 pages
30h 19m
English
Morgan Kaufmann
Content preview from Information Modeling and Relational Databases, 2nd Edition

11. Relational Mapping

11.1Implementing a Conceptual Schema
  • Overview of main steps

11.2Relational Schemas
  • Horizontal and vertical notations

  • Optionality

  • Key constraints

  • Other rules

11.3Relational Mapping Procedure
  • Avoiding redundancy

  • Mapping 1:1 associations

  • Mapping external uniqueness constraints

  • Mapping objectified associations

  • Mapping subtypes

11.4Advanced Mapping Aspects
  • Refinements to the Rmap procedure

11.5Summary
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

Information Modeling and Relational Databases, 3rd Edition

Information Modeling and Relational Databases, 3rd Edition

Terry Halpin, Tony Morgan
Database Modeling and Design, 5th Edition

Database Modeling and Design, 5th Edition

Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

Publisher Resources

ISBN: 9780123735683