Discuss the trade-offs between using a relational database management system (RDBMS) and a NoSQL database (e.g., document store, key-value store, graph database) for storing time-series data. Consider factors such as data modeling, query performance, scalability, schema flexibility, and data consistency.