Database Design - similar records, what to do?
📝 Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign...
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd...
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/
Watch video Database Design - similar records, what to do? online without registration, duration hours minute second in high quality. This video was added by user Database Star 29 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,034 once and liked it 131 people.