Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 3 (Many-to-Many)

Published: 02 September 2024
on channel: Thomas Blum

This video is part 3 of a demonstration of using VS-Code with the SQLite3 Editor extension to make a quote database (imagining a backend for the Brainy Quote website). This video adds a Topic Entity (table). It also establishes that the Quote-Topic relationship is many-to-many. So in addition to the Entity table, we created a QuoteTopic table which had two foreign keys -- one connecting to Quote and the other connecting to Topic. At the end we wrote a JOIN query that connected three tables: quote, quoteTopic, and topic with two WHERE clauses (a WHERE and an AND). We established that the join was a so-called Inner Join.

Watch video Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 3 (Many-to-Many) online without registration, duration hours minute second in high quality. This video was added by user Thomas Blum 02 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 36 once and liked it 0 people.