As part of a pilot project at MediCore Clinics , you designed a database to manage patient records for a few hundred individuals across three healthcare centers. The design used a single table to track both patient details and visit history, with self-joins used to generate analytical reports. Initially, the system used around 50% of available server resources. Now, the project has grown, and the database must support 100 times more patient data. Reports that previously worked now either take too long or fail due to compute limitations. What should you do to improve the database design and ensure scalability?