Student Reviews
( 5 Of 5 )
1 review
Video of Database Design - similar records, what to do? in Database ERD Principles course by Database Star channel, video No. 23 free certified online
Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign97
Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign97
Do you have different types of records in your database that are similar to each other?
There are a couple of ways you can store them - either in separate tables (one for each type of record), or all in a single table.
In this video, you'll learn more about these two approaches, see a sample design, and learn a couple of things you should consider about your record types before you decide which approach to use.
TIMESTAMPS:
00:00 - The problem
00:40 - Option 1 - single table
04:20 - Option 2 - separate tables
06:17 - Considerations
VIDEO LINKS:
LucidChart: https://lucidchart.com/