Bachman diagram

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Illustration of set type using a Bachman diagram.

Bachman diagrams are diagrams which are used to design the data using a network or relational "logical" model, separating the data model from the way the data is stored in the system. The model is named after database pioneer Charles Bachman, and mostly used in computer software design. A Bachman diagram is another name for a data structure diagram.[1]

In a relational model a relation is the cohesion of attributes that are fully and not transitive functional dependent of every key in that relation. The coupling between the relations is based on accordant attributes. For every relation a rectangle has to be drawn and every coupling is illustrated by a line that connects the relations. On the edge of each line arrows indicate the cardinality. We have 1-to-n, 1-to-1 and n-to-n. The latter has to be avoided and must be replaced by two 1-to-n couplings.

[edit] See also

[edit] References

  1. ^ IRS Resources. Part 2. Information Technology, Chapter 5. Systems Development, Section 13. Database Design Techniques and Deliverables. Retrieved 02 July 2009.
Personal tools
Namespaces
Variants
Actions
Navigation
Interaction
Toolbox
Print/export
Languages