assignment

Tables (9)

Campaign

  • Campaign_ID — INT — Primary key — NOT NULL
  • Campaign_Name
  • Campaign_Type
  • Target_Age_Group
  • Target_Segment
  • Start_Date — DATE
  • End_Date — DATE
  • Objective

Coupon

  • Coupon_ID — INT — Primary key — NOT NULL
  • Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
  • Coupon_Code
  • Discount_Precentage — INT
  • Expiration_Date — DATE
  • Redemption_Rate — FLOAT

Customer

  • Customer_ID — INT — Primary key — NOT NULL
  • Name
  • Age — INT
  • Gender
  • Tel
  • Purchase_History
  • Membership_status
  • Preferred_Channel

Customer_Segement

  • Customer_ID — INT — Foreign key → Customer.Customer_ID — NOT NULL
  • Segment_ID — INT — Foreign key → Segment.Segment_ID — NOT NULL

POS_Transaction (Pos_Transaction)

  • Transaction_ID — INT — Primary key — NOT NULL
  • Purchase_ID — INT — Foreign key → Purchase.Purchase_ID — NOT NULL
  • Customer_ID — INT — Foreign key → Purchase.Customer_ID — NOT NULL
  • Store_ID — INT — Foreign key → Purchase.Store_ID — NOT NULL
  • Campaign_ID — INT — Foreign key → Purchase.Campaign_ID — NOT NULL
  • Transaction_Date — DATE
  • Total_Amount

Promotion

  • Promotion_ID — INT — Primary key — NOT NULL
  • Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
  • Promotion_Type
  • Discount_Details
  • Start_Date — DATE
  • End_Date — DATE

Purchase

  • Purchase_ID — INT — Primary key — NOT NULL
  • Customer_ID — INT — Foreign key → Customer.Customer_ID — NOT NULL
  • Store_ID — INT — Foreign key → Store.Store_ID — NOT NULL
  • Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
  • Purchase_Date — DATE
  • Amount
  • Product_Category
  • Channel

Segment (Segement)

  • Segment_ID — INT — Primary key — NOT NULL
  • Segment_Name
  • Criteria

Store

  • Store_ID — INT — Primary key — NOT NULL
  • Store_Location
  • Store_Type