Database Design for Facebook: A Social Network Database Example

📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=sougyTO_Wjw 🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?video=sougyTO_Wjw Are you interested in designing a database for a social network, like Facebook? Facebook is a popular website and designing a database for a site like Facebook is a common exercise, whether you're in a database course at college or want to practice your skills. In this video, you'll start with a series of basic features of the system, and one-by-one we'll create a database design, adding to the design at each step. The final design will meet the requirements of the features we have identified. You can then expand on the design, and of course modify it if you want different requirements. A couple of links mentioned in this video: - Falsehoods Programmers Believe About Names: https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/ - Image of final database design: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/database_design_fb.png Timestamps: 00:00 Start 00:52 Features 01:39 Feature 1 - create profile 04:08 Feature 2 - add other profiles 05:41 Feature 3 - add posts 07:09 Feature 4 - see posts 07:31 Feature 5 - likes and comments on posts 08:49 Final design 09:51 Sample queries