From the course: Databases for Node.js Developers

Unlock the full course today

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

Understand relational databases

Understand relational databases

From the course: Databases for Node.js Developers

Start my 1-month free trial

Understand relational databases

- [Instructor] Some years back, I had the task to create a web application that was focused around hiking, and it became quite challenging from a database point of view because we had to answer questions like, which villages are along some trail? Or, where can I eat when I'm in some village? Or which trails should I take to get to this village? Technically, these are relations, and relational databases like MySQL were made exactly for that. They also have a very clear nomenclature on how relations are expressed. In relational databases, we have schemas and they define tables, a table structure, and also, very important, the relationship between records. Let's look at a few examples. Let's think about a system for a college. So a student usually has one place of birth, and this is a one-to-one relation. A college has many students. This is a so-called one to n relation. And the subject has many students, and the…

Contents