First page Back Continue Last page Image

ERD – Entity Relationship Diagram

  • Sales
  • Key
  • Field
  • Type
  • PK
  • TID
  • TDate
  • TAmt
  • TClrk
  • FK
  • CNumb
  • FK
  • PNumb
  • Product
  • Key
  • Field
  • Type
  • PK
  • PNumb
  • PName
  • PInvt
  • PCost
  • Customer
  • Key
  • Field
  • Type
  • PK
  • CNumb
  • CName

Databases can be designed by using an ERD in much the same way that airplanes are designed using a CAD System

MySQL Workbench calls their ERD an EER Diagram ( Enhanced ERD)