Database System Concepts, Avi Silberschatz, Henry F. Korth, S. Sudarshan, 2019 (McGraw-Hill) - A foundational textbook offering comprehensive coverage of database systems, including detailed explanations of the benefits and challenges of using a DBMS.
Databases: Relational Databases and SQL, Jennifer Widom, 2011 (Stanford University) - Provides an accessible introduction to database concepts, including the practical benefits of using a DBMS, presented by a leading expert.