1,262 views
Recording of the webinar of the federal program "Code of the Future" (MIPT) for schoolchildren and students. 00:00 Introduction 04:34 Drawing a diagram in draw.io 07:33 Designing categories and products 10:35 Primary and foreign keys 14:30 Creating tables for categories and products 29:20 Designing customers and orders 35:54 Creating tables for customers and orders 43:25 "Many-to-many" relationship, designing positions in an order 52:56 Filling the database 57:10 Example queries 59:00 About the blog "Learn to learn" 01:02:20 Example queries 01:07:00 Summing up 01:10:49 Answers to questions Alexander Viktorovich will show you which tables are needed to store information about products, orders and customers, and how to properly link them together. You will learn how to create an online store database using postgreSQL, fill it with products, and what technologies to use to create a visual interface for it. Topics covered: Database design Martin notation One-to-one, one-to-many, many-to-many relationships Basic SQL queries #databasedesign #databases #postgreSQL #SQL #onetomany #manytomany ????SUPPORT THE PROJECT: https://www.donationalerts.com/r/lear...