Many to Many Relationships (the 3 tables approach) | Backendless Database Training Course (pt. 40)
In this video, we continue the discussion of many-to-many relations in databases that we started in the previous video. We picks up from where we left off and review the database design that we had previously discussed. We introduce an approach where three tables are used, consisting of a table for courses, a table for students, and an intermediate table that describes the actual relationship between them. We explain how this design allows additional data about the relationships, such as grades or enrollment dates, to be captured. We also provide a demonstration of what the students and courses table would look like in Backendless Console, and how to populate it with data. Lastly, we review previously discussed use cases with this new design.
Have questions? Post them in the comments below or get in touch at:
Support forum: https://support.backendless.com/
Slack channel: https://backendless.slack.com/
Telegram channel: https://t.me/backendless_chat
Start with Backendless for free today to follow along with this course: https://develop.backendless.com/regis...
Happy Coding!
#database #relationaldatabase