课程: Databases for Node.js Developers
免费学习该课程!
今天就开通帐号,24,700 门业界名师课程任您挑!
Understanding relational databases
- [Instructor] When I first started using databases professionally, relational databases were the standard. Back then, MySQL and Postgres dominated the space and they're still widely used today. A relational database is great when data has clear relationships. Imagine building a hiking app that answers questions like which villages are along a trail? Where can a eat in a village? Which trail leads to a specific village? These questions involve relations between data, and that's exactly what relational databases are designed for. Relational databases follow a strict schema, which defines tables, structured storage for data, columns, which define what each record holds, and relationships, how records are linked. Let's look at the few relationship types. We have one-to-one. For instance, a student has one place of birth. We have one-to-many relationships, which would be a college has many students, and we have many-to-many relationships, a subject has many students and the student has…