I Critique a Database Design: My Honest Review

Подписаться 54 тыс.

Просмотров 2,1 тыс.

50% 1

📝 Get my Database Design Guides to many different sample databases: www.databasestar.com/dbdesign...
🎓 Learn how to design an effective database and create it using SQL: databasestar.mykajabi.com/edd...
In this video, I review a database design from a question on a StackExchange post, offering some suggestions of things to improve and some points on what has been done well.
⏱ TIMESTAMPS:
00:00 - The design
00:39 - Improvements
03:19 - Status fields
04:30 - Movies table
07:31 - Users table
08:49 - Persons table
09:51 - Updated design
🔗 VIDEO LINKS:
Original design on StackExchange: dba.stackexchange.com/questio...

Наука

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@longn.8804 6 месяцев назад

Just 1 minute in and I had to hit the LIKE button right away. Love how you broke down the issues and gave suggestions to improve them. Please make more of these videos!!! Thank you.

@DatabaseStar 6 месяцев назад

Awesome! Glad you like this video. This is the first type of this video I’ve done so I am do more of them.

@triplestrafe 7 месяцев назад

Can you show an example of how to connect these together in Airtable? I understand the concepts of connecting databases in a diagram, but actually doing it is a different story and would be nice if you could show how we connect all of these together from the different primary keys to the secondary keys in Airtable

@DatabaseStar 6 месяцев назад

That's a good idea! However, I don't have any experience with Airtable so I don't think I can show it.

@triplestrafe 6 месяцев назад

or like a basic example in excel or DB?@@DatabaseStar

@maneaabdullah6059 7 месяцев назад

Could you make a farm or agriculture system database as it is rare to found good example in the internet ;)

@DatabaseStar 7 месяцев назад

Good idea, though I don't know a lot about farming or agriculture to be able to design one.

@mannycalavera121 7 месяцев назад

Something about database design that tweaks satisfies my autism

@DatabaseStar 7 месяцев назад

Glad to hear you like it

@Atomic-Blast- 5 месяцев назад

Just stumbled randomly on this video, and I just love it! I am a student taking a system analysis and design course, in which we have to create databases alongside other things. Your videos are helping me so much, and honestly your voice is to die on. It is soothing, relaxing and crystal clear: thank you for the articulation. Mind if I ask you what software are you using to draw these tables ? Thanks for the video, always appreciate seeing a master at his work, so keep them coming :)

@DatabaseStar 5 месяцев назад

Thanks, I'm glad you like the video! The software I use is called LucidChart.