© George Tillmann 2017

George Tillmann, Usage-Driven Database Design, 10.1007/978-1-4842-2722-0_19

Physical Schema Definition Object Definitions

George Tillmann

(1)Ship Bottom, New Jersey, USA

Software tools for data modeling, database design, and documentation, as well as corporate data dictionaries and the database management system, will all have their own documentation standards. This appendix gives examples of the minimum information about data that needs to be available for database designers, DBAs, database maintenance staff, and application designers and programmers.

Record

  • Record name

  • Record description

  • Logical data model name

  • Type (proper, associative, attributive, S-type)

  • Name of supertype (if any)

  • Name of subtype (if any)

  • Synonyms or aliases ...

Get Usage-Driven Database Design: From Logical Data Modeling through Physical Schema Definition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.