
Ultimate access to all questions.
Your organization manages an ecommerce website currently serving one region but planning global expansion. You need to choose a scalable SQL database and design a schema. How would you create a table to store customer transactions while ensuring uniqueness for both CustomerId and TransactionId?