Flower_Distribution_Analysis_ERD

Tables (4)

academic_calendar (Untitled4)

  • graduationDate (Field)
  • entranceDate (Field2)

event (Untitled3)

  • eventName (Field)
  • eventDate (Field2)

flower_price (Untitled)

  • saleDate (Key3) — Primary key — NOT NULL
  • flowerGubn (Field)
  • pumName (Field2)
  • goodName (Field3)
  • lv (Field4)
  • maxAmt (Field5)
  • minAmt (Field6)
  • avgAmt (Field7)
  • totAmt (Field8)
  • totQty (Field9)

weather (Untitled2)

  • measurementDate (Field)
  • temperatures (Field2)
  • humidity (Field3)