Mathematica interview question

Describe the cardinality between SQL tables given a scenario, and make schemas