ppt

Tables (4)

CrimeMajor (Untitled)

  • major_id (PK) — INT — Primary key — NOT NULL
  • major_name (Field) — VARCHAR

CrimeMinor (-\)

  • minor_id (PK) — INT — Primary key — NOT NULL
  • major_id (FK) — INT
  • minor_name (-) — VARCHAR

CrimeOccurrence (.)

  • occ_id (PK) — INT — Primary key — NOT NULL
  • minor_id (FK) — INT
  • region_id (Field)

Region (-)

  • region_id (PK) — INT — Primary key — NOT NULL
  • name (-) — VARCHAR