Student Reviews
( 5 Of 5 )
1 review
Video of Database Design for Chat Application in Database ERD Principles course by Database Star channel, video No. 8 free certified online
Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign39
Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign39
Designing a database for an application is a good way to learn and practice your database design skills.
In this video, we have a fictional “chat application”, similar to WhatsApp or Messenger. We have a few requirements and we want to design a database that could store the required information.
This video shows you how to design a database for this chat application from scratch, starting with the first table, adding more tables and fields, and making adjustments along the way.
It includes the concept of a many-to-many relationship, which I have a video about here:
So if you’re interested in a database design for a chat application, either as a project or just to learn, this video will be useful to you.
Timestamps:
00:00 Introduction
00:48 Requirements
02:16 Message table
03:14 Contact table
04:56 Group messages
05:34 Members joining groups
06:57 Refactoring the design
08:46 Enhancements and conclusion