Optimove interview question

How would you test example feature? How would you create this database?