Skip to Content
The Data Model Resource Book, Volume 1
book

The Data Model Resource Book, Volume 1

by Len Silverston, Graeme Simsion
March 2001
Beginner to intermediate
560 pages
13h 22m
English
Wiley
Content preview from The Data Model Resource Book, Volume 1

APPENDIXALogical Data Model Entities and Attributes

This appendix lists the entities and attributes from the models found in Chapters 2 through 9. This listing includes the entity names, attribute names, primary key indicators, foreign key indicators, and the domain for each attribute.

The domain indicates a standard set of characteristics that can be applied to attributes, including its datatype and length. Table A.1 defines the nature of each domain. When applying the domains to the attributes listed in these appendices, refer to Table A.1 for recommendations for what datatype and length to use when implementing these models. Of course, the datatype and length of each attribute should be adjusted as appropriate to meet the specific needs of the enterprise.

The domain definitions as they are applied to the attributes in the appendices are used for the SQL code that is contained on the full-blown CD-ROM (sold separately).

Table A.1 Appendices Domain Definitions

appa.1

Logical Data Model Entities and Attributes Listing

appa.2 appa.3 appa.4
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

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

Len Silverston

Publisher Resources

ISBN: 9780471380238Purchase book