From the course: Relational Databases Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Relations, tuples, tables, and records

Relations, tuples, tables, and records

From the course: Relational Databases Essential Training

Start my 1-month free trial

Relations, tuples, tables, and records

- [Instructor] E.F. Codd's Relational Model has its roots in mathematics and set theory, and this means that there's a number of technical terms that you're likely to come across as you delve into the world of relational databases. With that said, practical database use over the past 50 years has softened or simplified some of the major concepts. And it's no longer necessary to adhere to a strict mathematical definition, especially when you're just starting out. In the original paper a, relational model of data for large share data-banks, Codd refers to relations, domains, and tuples as being the core components of a relational database. The definition of what exactly these are can be useful to professional database developers and data scientists, but for you and I in this introductory course, we're going to call them by their common names. Tables, columns and records. These common language substitutes are not as strict…

Contents