▲ 3 r/SQL
ERD advice for an online department store
Hi guys! The client requires a database system for the online shopping experience of their department store. In addition to the core day-to-day functions, they are developing strategies to promote the end-of-financial-year sale through social media channels so they want to capture user interactions, track engagement across social media platforms, and support analytical insights into customer behavior and marketing effectiveness. A key performance metric they consider is the click-through conversion rate. I have outlined an ERD (some attributes are missing because I'm still working on it) and would like some advice to make it a better fit for the client (e.g., Are these entities enough?). Thank you for reading and hope you have a great day!
u/Objective_Baby1678 — 3 days ago