How would you design SQL schemas for a system with complex relationships and high read/write performance needs?
