Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 3 (Many-to-Many)
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.
More Database Introduction: Database Categories and Codd's Rules for Relational Databases
Finding More Patterns in the Perfect-Shuffle (Riffle) Integer Sequence with Wolfram-Cloud