Your question is Data Model for Online Store. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Build a simple data model to track information about an online store. In this store, customers may purchase items at any time. Also, they can pay their total order amount in multiple payments up to their discretion. (Example: John purchases $100 on Jan 1st: 10 Harry Potter books at $6 and 20 chocolates at $2; pays $40 on Jan 1st and $60 on April 2nd.)
Asked in the data modeling interview stage. Senior Data Engineer, Walt Disney | Hulu. Reported follow-up: Write SQL for the top 5 customers by amount owed.