DATA

MODELING MADE SIMPLE

With Embarcadero ER/Studio®

Data Architect

first edition

DATA

MODELING MADE SIMPLE

With Embarcadero ER/Studio®

Data Architect

first edition

Steve Hoberman

All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording or by any information storage and retrieval system, without written permission from the publisher, except for the inclusion of brief quotations in a review.

The author and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

Embarcadero®, the Embarcadero Technologies logos, and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners and should be treated as such.

This book is printed on recycled acid-free paper.

Copyright © 2013 by Technics Publications, LLC             

ISBN, print ed.                             978-1-9355044-8-1

First Printing 2011

Printed in the United States of America

Library of Congress Control Number: 2012955759

Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance and accelerate innovation. The company’s flagship tools include: Embarcadero® Change Manager™, CodeGear™ RAD Studio, DBArtisan®, Delphi®, ER/Studio®, JBuilder® and Rapid SQL®. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. Embarcadero is online at www.embarcadero.com.

Contents at a Glance

Read me first!              1

SECTION I: Overview              7

CHAPTER 1: Data Model Overview              9

CHAPTER 2: ER/Studio Functionality              19

CHAPTER 3: ER/Studio Landscape              25

SECTION II: Data Model Objects              41

CHAPTER 4: Entities              43

CHAPTER 5: Submodels              59

CHAPTER 6: Attributes and Domains              67

CHAPTER 7: Relationships              89

SECTION III: Conceptual, Logical, and Physical Data Models              111

CHAPTER 8: Conceptual Data Models              113

CHAPTER 9: Logical Data Models              125

CHAPTER 10: Physical Data Models              143

SECTION IV: Additional ER/Studio Features              175

CHAPTER 11: Data Dictionary              177

CHAPTER 12: Data Lineage              191

CHAPTER 13: Macros              205

CHAPTER 14: Importing, Exporting, Printing, and Reporting              209

CHAPTER 15: Naming Standards              225

CHAPTER 16: Compare/Merge Utility              231

APPENDIX A: References              237

APPENDIX B: Answers to Exercises              239

APPENDIX C: Glossary              245

APPENDIX D: ERStudio Commands Quick Reference              255

Index              265