I Critique a Database Design: My Honest Review

[@DatabaseStar]

Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?

[@longn.8804]

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]

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

[@johnturman2829]

Hi Ben, Looks good! The only other thing I might change is the Movie Crews table having the same column names listed twice.

[@DatabaseStar]

Ah yes good point, thanks!

[@mannycalavera121]

Something about database design that tweaks satisfies my autism

[@DatabaseStar]

Glad to hear you like it

[@triplestrafe]

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]

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

[@triplestrafe]

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

[@Atomic-Blast-]

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]

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

[@dheerajs2838]

is it better to use code ID (int) as a category primary key or uuid as a primary key or text Code as a primary key?

[@DatabaseStar]

Good question. I've got a video coming out soon about this, but generally I prefer INT for a PK instead of UUID or GUID.

[@captainkeyboard1007]

I like your database plans layout. The database application is my favorite application, thanks to Microsoft Access. I just subscribed.🙂

[@DatabaseStar]

Thanks! Glad you like the database videos.

[@maneaabdullah6059]

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

[@DatabaseStar]

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

[@AmirMufid]

what name tools to create ERD db ?

[@DatabaseStar]

Hey, I use a tool called LucidChart.

[@walkingradiance9556]

I would use UUIDs.

[@DatabaseStar]

UUIDs for the primary keys? Yeah that's another option that I've seen and it can work.

[@ahmetalpsamur]

​@@DatabaseStar is it safe to use increasing int id for primary key ?