O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Entity Relationship Diagram Concepts

Entity relationship diagrams (ERDs) are the second major document (the first is the data f low diagram) that is developed when using the traditional approach to system analysis and design. When designing a new system, the systems analyst first identifies all of the processes and data needed within a system. The system processes, the f low of data between the processes, the data stores, and the external entities are captured in a data flow diagram (DFD).

Data moving through a system is depicted on a DFD by data flows. Each data f low contains a variety of data items. These are the bits of data that are the inputs to a process and the outputs from a process. When these bits of data are at rest, they are contained ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required