No video
I Critique a Database Design: My Honest Review
Рет қаралды 2,244
Күн бұрын📝 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...
@longn.8804 7 ай бұрын
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 7 ай бұрын
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 7 ай бұрын
That's a good idea! However, I don't have any experience with Airtable so I don't think I can show it.
@triplestrafe 7 ай бұрын
or like a basic example in excel or DB?@@DatabaseStar
@Atomic-Blast- 6 ай бұрын
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 6 ай бұрын
Thanks, I'm glad you like the video! The software I use is called LucidChart.
@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
@dheerajs2838 7 ай бұрын
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 7 ай бұрын
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.
@walkingradiance9556 11 күн бұрын
I would use UUIDs.
@DatabaseStar 10 күн бұрын
UUIDs for the primary keys? Yeah that's another option that I've seen and it can work.
@AmirMufid 3 ай бұрын
what name tools to create ERD db ?
@DatabaseStar 3 ай бұрын
Hey, I use a tool called LucidChart.
Anton Putra
Рет қаралды 35 М.
Jordan has no life
Рет қаралды 8 М.
Decomplexify
Рет қаралды 142 М.
NDC Conferences
Рет қаралды 15 М.