Database System Concepts, Abraham Silberschatz, Henry F. Korth, S. Sudarshan, 2019 (McGraw-Hill Education) - An authoritative textbook that thoroughly explains the relational model, data organization, keys, and the principles of linking tables to avoid data redundancy.
Fundamentals of Database Systems, Ramez Elmasri, Shamkant B. Navathe, 2017 (Pearson) - This textbook provides a comprehensive treatment of database system principles, including the relational data model, ER diagrams, and relational database design, which are foundational for understanding table relationships.
The Relational Data Model (Lecture 2), Prof. Samuel Madden, Prof. Robert Morris, Prof. Michael Stonebraker, Dr. Carlo Curino, 2010 (Massachusetts Institute of Technology: MIT OpenCourseWare) - Part of a comprehensive university course on database systems, this lecture specifically covers the relational data model, including how tables relate to each other through shared attributes and the concept of keys.