30:
85:
140:
119:
are specified inside the entity boxes rather than outside of them, while relationships are drawn as boxes composed of attributes which specify the constraints that bind entities together. DSDs differ from the E–R model in that the E–R model focuses on the relationships between different entities,
173:
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:
282:
440:
264:. Part 2. Information Technology, Chapter 5. Systems Development, Section 13. Database Design Techniques and Deliverables. Retrieved 2 July 2009.
76:
which represent entities. Arrow symbols represent relationships. Data structure diagrams are most useful for documenting complex data entities.
323:
351:
319:
301:
548:
569:
436:
112:
66:
245:
123:
There are several styles for representing data structure diagrams, with the notable difference in the manner of defining
523:
574:
218:
124:
518:
497:
223:
208:
186:
128:
492:
344:
175:
182:
116:
62:
528:
29:
456:
337:
451:
405:
277:
105:
482:
477:
461:
400:
374:
315:
297:
213:
50:
538:
446:
58:
513:
410:
249:
160:
156:
101:
155:
from the way the data is stored in the system. The model is named after database pioneer
147:
A Bachman diagram is a certain type of data structure diagram, and is used to design the
533:
426:
384:
307:
168:
166:
In a relational model, a relation is the cohesion of attributes that are fully and not
84:
563:
379:
261:
487:
289:
242:
17:
543:
360:
152:
139:
120:
whereas DSDs focus on the relationships of the elements within an entity.
195:. The latter has to be avoided and must be replaced by 2 (or more) 1-to-
54:
93:
46:
83:
148:
97:
333:
104:. The data structure diagram is a graphical alternative to the
73:
329:
151:
with a network or relational "logical" model, separating the
127:. The choices are between arrow heads, inverted arrow heads (
65:
that are placed on them. It is an older alternative to the
322:. Prentice Hall. 1 August 1988; now available as the
111:
The data structure diagrams is a predecessor of the
108:
specifications within such data dictionary entries.
506:
470:
419:
393:
367:
131:), or numerical representation of the cardinality.
252:, U.S. Department of Transportation, August 2001.
143:Illustration of set type using a Bachman diagram
72:The basic graphic notation elements of DSDs are
345:
96:type that is used to depict the structure of
8:
294:Structured Analysis and System Specification
88:Data structure diagram and a data dictionary
352:
338:
330:
138:
28:
235:
7:
33:Example of a data structure diagram
25:
549:Data Format Description Language
159:, and mostly used in computer
92:A data structure diagram is a
1:
304:. Prentice Hall. 11 May 1979.
286:. Data Base, 1969, 1(2):4–10.
524:Core architecture data model
219:Entity-relationship diagram
591:
312:Modern Structured Analysis
519:Business process modeling
498:Unified Modeling Language
437:Entity–relationship model
248:24 September 2016 at the
243:Data Integration Glossary
224:Unified Modeling Language
209:Control structure diagram
113:entity–relationship model
67:entity–relationship model
324:Structured Analysis Wiki
283:Data structure diagrams
570:Data modeling diagrams
432:Data structure diagram
144:
115:(E–R model). In DSDs,
89:
39:data structure diagram
34:
142:
87:
49:of a certain kind of
47:visual representation
32:
529:Enterprise modelling
493:Object–role modeling
171:functional dependent
575:Modeling languages
278:Charles W. Bachman
145:
90:
35:
557:
556:
483:Information model
478:Data-flow diagram
214:Data flow diagram
16:(Redirected from
582:
539:Process modeling
354:
347:
340:
331:
265:
259:
253:
240:
172:
100:elements in the
21:
590:
589:
585:
584:
583:
581:
580:
579:
560:
559:
558:
553:
514:Database design
502:
466:
415:
389:
363:
358:
274:
272:Further reading
269:
268:
260:
256:
250:Wayback Machine
241:
237:
232:
205:
167:
161:software design
157:Charles Bachman
137:
135:Bachman diagram
102:data dictionary
82:
23:
22:
18:Bachman diagram
15:
12:
11:
5:
588:
586:
578:
577:
572:
562:
561:
555:
554:
552:
551:
546:
541:
536:
534:Function model
531:
526:
521:
516:
510:
508:
504:
503:
501:
500:
495:
490:
485:
480:
474:
472:
471:Related models
468:
467:
465:
464:
459:
454:
449:
444:
434:
429:
423:
421:
417:
416:
414:
413:
408:
403:
397:
395:
391:
390:
388:
387:
382:
377:
371:
369:
365:
364:
359:
357:
356:
349:
342:
334:
328:
327:
308:Edward Yourdon
305:
287:
273:
270:
267:
266:
254:
234:
233:
231:
228:
227:
226:
221:
216:
211:
204:
201:
136:
133:
81:
78:
53:that contains
24:
14:
13:
10:
9:
6:
4:
3:
2:
587:
576:
573:
571:
568:
567:
565:
550:
547:
545:
542:
540:
537:
535:
532:
530:
527:
525:
522:
520:
517:
515:
512:
511:
509:
505:
499:
496:
494:
491:
489:
486:
484:
481:
479:
476:
475:
473:
469:
463:
460:
458:
455:
453:
450:
448:
445:
442:
438:
435:
433:
430:
428:
425:
424:
422:
418:
412:
409:
407:
404:
402:
399:
398:
396:
392:
386:
383:
381:
378:
376:
373:
372:
370:
366:
362:
355:
350:
348:
343:
341:
336:
335:
332:
325:
321:
320:0-13-598624-9
317:
313:
309:
306:
303:
302:0-13-854380-1
299:
295:
291:
288:
285:
284:
279:
276:
275:
271:
263:
262:IRS Resources
258:
255:
251:
247:
244:
239:
236:
229:
225:
222:
220:
217:
215:
212:
210:
207:
206:
202:
200:
198:
194:
193:
189:
184:
180:
179:
170:
164:
162:
158:
154:
150:
141:
134:
132:
130:
126:
121:
118:
114:
109:
107:
103:
99:
95:
86:
79:
77:
75:
70:
68:
64:
60:
59:relationships
56:
52:
48:
44:
40:
31:
27:
19:
488:Object model
431:
375:Architecture
311:
293:
281:
257:
238:
196:
191:
187:
177:
165:
146:
122:
110:
91:
71:
42:
38:
36:
26:
401:Conceptual
290:Tom DeMarco
199:couplings.
129:crow's feet
125:cardinality
106:composition
63:constraints
564:Categories
544:XML schema
447:Geographic
361:Data model
230:References
169:transitive
153:data model
117:attributes
61:, and the
51:data model
385:Structure
45:) is the
507:See also
457:Semantic
441:enhanced
427:Database
411:Physical
380:Modeling
246:Archived
203:See also
80:Overview
57:, their
55:entities
452:Generic
406:Logical
394:Schemas
94:diagram
462:Common
318:
300:
183:1-to-1
420:Types
176:1-to-
74:boxes
368:Main
316:ISBN
298:ISBN
190:-to-
185:and
149:data
98:data
43:DSD
566::
314:.
310:.
296:.
292:.
280:.
181:,
163:.
69:.
37:A
443:)
439:(
353:e
346:t
339:v
326:.
197:n
192:n
188:n
178:n
41:(
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.