Model the tables, write the SQL queries and defend your schema while the interviewer asks about keys, normalization and indexes.