You are tasked with designing storage solutions for two relational tables within a 10-terabyte database hosted on Google Cloud. Your primary objectives include supporting horizontally scalable transactions and optimizing data accessibility for range queries on non-key columns. What approach should you take to accomplish these goals?