16. The SQL Sequel [toc] 16.1. Table Relationships 16.1.1. Relating Data 16.1.2. One-To-Many Relationships 16.1.3. Table Keys 16.1.3.1. Adding a Primary Key 16.1.3.2. Adding a Foreign Key 16.1.3.3. Keys Wrap-Up 16.1.4. Other Relationships 16.1.5. Check Your Understanding ✅ 16.2. Database Management 16.2.1. Setup 16.2.1.1. writing_supply 16.2.1.2. pencil_drawer 16.2.1.3. pen_drawer 16.2.2. Import Data 16.2.3. Import Troubleshooting 🛠️ 16.2.4. Check Your Understanding ✅ 16.3. Complex Queries 16.3.1. Review Joins 16.3.1.1. Inner Join 16.3.1.2. Left/Right Join 16.3.1.3. Multiple Joins 16.3.2. Subqueries 16.3.2.1. Where Else Can We Add Subqueries? 16.3.2.2. Last Reminders 16.3.3. Check Your Understanding ✅ 16.4. Exercises: The SQL Sequel 🏃 16.4.1. Create a New Schema 16.4.2. Import New Tables 16.4.2.1. The plant Table 16.4.2.2. The seeds Table 16.4.2.3. The garden_bed Table 16.4.3. Try Out Some Joins! 16.4.3.1. Inner Join 16.4.3.2. Left Join 16.4.3.3. Right Join 16.4.3.4. Full Join 16.4.4. Sub-Queries and Complex Queries 16.4.5. Bonus Missions 🚀 16.5. Studio: A Library 🎙️ 16.5.1. Database Setup 16.5.1.1. The book table 16.5.1.2. The author table 16.5.1.3. The patron table 16.5.1.4. The reference_books table 16.5.1.5. The genre table 16.5.1.6. The loan table 16.5.2. Warm-up Queries 16.5.3. Loan Out a Book 16.5.4. Check a Book Back In 16.5.5. Wrap-up Query 16.5.6. Bonus Mission #Java