Database Design and Development: A Visual Approach by Raymond Frost
For the intro database course where you want students to learn how to design rather than just manipulate relational databases.
The text that balances database theory, business problem solving, and hands-on-practice. This book prepares student for the workplace without sacrificing rigorous academic theory.