What considerations would you take into account when designing a database schema for a new application?