ACCESS Relationship Diagrams

• ACCESS automatically draws an internal model level ER diagram

• Each table is shown as an entity box

  • table attributes are automatically listed inside the box
  • key fields are shown in boldface

• You draw the connecting lines between related tables (entities)

  • ACCESS does not require you to draw relationship triangles between entities
  • Draw the lines so that related keys are connected

• You specify the connectivity of the relationship using either a 1 or an ? (to represent “many”)

Previous slide

Next slide

Back to first slide

View graphic version