How to Create a Database Design From an Idea

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn how to design an effective database and create it using SQL: databasestar.mykajabi.com/edd...
If you’ve got an idea or requirements to create a database, and don’t know how to design it, then this is the video for you.
You can take an idea or some requirements for an application and create a database design.
In this video, I’ll explain step-by-step how you can do this, using an example. We start with a written description of what we want to do, and end up with a database design with a few tables, columns, and primary and foreign keys added.
Timestamps:
00:00 Going from an idea to a database design
00:43 Step 1 - write it down
01:44 Step 2 - find the nouns
02:13 Create tables
02:54 Step 3 - add attributes
06:13 Step 4 - add relationships
08:04 Step 5 - assess and adjust
09:15 Normalisation and next steps
Links:
Lucidchart: www.lucidchart.com/pages/
Database modeling tools article: www.databasestar.com/data-mod...

[@nicholassmith6412]

Videos like this are way more useful than the other bog standard stuff that litters the web - rather than over-explaining 'how to query a, b, c, d and e', your videos cover the more important fundamentals like how to design relational databases properly. The querying can just be googled as you develop, but leaning how to design a database cannot be googled so easily. Thank you

[@DatabaseStar]

Thanks for the feedback and glad you found this useful!

[@ayomideashiru554]

This is one of the best straight-to-the-point videos on designing databases on KZbin!!! Amazing!!!

[@DatabaseStar]

Wow, thanks! Glad you liked the video and found it helpful!

[@user-jz8gl4mb9e]

I like your video. I have been studying databases for some time, and I've come across tutorial project videos on KZbin. This is one of the best videos on designing databases on KZbin!!!

[@DatabaseStar]

Glad it was helpful!

[@yassinebouchoucha]

most under-rated topic for web developer , keep-up the good work.

[@DatabaseStar]

Thanks!

[@yoseees5493]

This video was incredible! Thank you so much!

[@DatabaseStar]

You're so welcome!

[@tech-systemdesign8891]

OMG, finally, your videos are so helpful, I was looking for a while. Thank you so much!!

[@DatabaseStar]

Glad you like them!

[@tech-systemdesign8891]

The best channel to learn db design, thank you so much!

[@DatabaseStar]

Thanks!

[@ravindrawaghela9072]

One of the best video . Very lucid to understand. ! Thank you from bottom of my heart. :)

[@DatabaseStar]

Thanks, I’m glad you liked it!

[@user-iq6cp1jg7s]

This amazing brother. No one is talking about these types of fundamental topics. This video is so helpful. Keep up good work.

[@DatabaseStar]

Thanks, glad you like it!

[@piccell244]

I‘m starting out right now and this video is really helping, thanks a lot

[@DatabaseStar]

No problem, glad to hear this video is helpful!

[@-.-smile]

Ben your videos are amazing!

[@DatabaseStar]

Thanks!

[@Spkntei]

Good teacher ❤

[@DatabaseStar]

Thanks!

[@AnneLopezlovesLife]

This is exactly what i need right now :)

[@DatabaseStar]

Glad it was helpful!

[@czhablog9559]

Wow what an amazing explanation!!!

[@DatabaseStar]

Glad it was helpful!

[@samfreitag729]

Wow! Super helpful video man. I wish I started here first....

[@DatabaseStar]

Glad it was helpful!

[@riccardolacamera]

your video was absolutely helpful compared to class lectures about database management, do you have anything on how to design (even with pen and paper) other kind of relationship between tables? Thanks a lot!

[@DatabaseStar]

Thanks! I've got a couple of videos on my channel about many to many relationships, and one to many relationships. I've also got quite a few examples of designing a database, such as AirBNB or Instagram or school management.

[@simondolapo1567]

Great video...I absolutely loved it... You're doing a great job...

[@DatabaseStar]

Thank you so much!

[@simondolapo1567]

@@DatabaseStar You're welcome...Words can't express how happy I felt when j went through some of your database videos...They were so helpful. Good job sir🙌

[@hafedgabroun3242]

Keep up the good work! 👍

[@DatabaseStar]

Thanks!

[@yahayahudu1745]

You are really amazing, thanks 😊

[@DatabaseStar]

Thanks!

[@abdirahmanali3639]

absolutely amazing, !!!!!

[@DatabaseStar]

Thanks!

[@trishulcurtis1810]

Excellent Video!

[@DatabaseStar]

Thank you very much!

[@srourganoush5941]

You deserve more likes and subscribers

[@DatabaseStar]

Thanks!

[@pawegagorowski4410]

Great video!!

[@DatabaseStar]

Thanks!

[@tejassharma2006]

Thanks man.

[@DatabaseStar]

No problem!

[@SonAyoD]

Great video

[@DatabaseStar]

Thanks!

[@naveenkumarmurugan1962]

Your videos are awesome

[@DatabaseStar]

Thanks!

[@mastermindrational1907]

This was helpful, although I have a massive database I’m planning. Maybe I will need to break it down into small chunks as I go?

[@DatabaseStar]

Thanks! Yeah breaking it down will be helpful

[@appstuff6565]

Hi there, thanks for this! I was wondering how we can do with multiple patients at the same time, perhaps create a separate table of patients and how will we identify other patients from that table list?

[@DatabaseStar]

Glad it helped! Yes, you would have a separate table in between patients and appointments to store the patients for each appointment, as it is now a "many to many" relationship.

[@debrain1647]

Hello, nice tutorial.. what software is this? Would like to learn from you.

[@DatabaseStar]

Thanks! The tool I used is called LucidChart.

[@abdelrahmanmohamedowis7619]

why u don't do generalisation principle

[@DatabaseStar]

What do you mean by "generalisation principle"?

[@rimshawaqar8073]

have you lectures on oracle apex complete series?

[@DatabaseStar]

Unfortunately I don’t, as I don’t have any experience with apex

[@rimshawaqar8073]

If you know someone good at apex, can you recommend (channel, lectures)

[@wesleyong2970]

What software is this?

[@DatabaseStar]

This software is called LucidChart.

[@GenjaOrigins]

I am trying to learn something. Lets say someone gives me some requirements how can i make a DB based on that. Or if have a DB how can i change it if somethng happnes therre must be some rules or theory. Like Pivot tables that connect 2 tables etc

[@DatabaseStar]

This video shows you how to create a database design from an idea or from requirements. I've got a few other examples on how to do this on my channel as well. If you have a database and you need to change something, you would follow the same process. But it may be more complicated as you need to understand what is happening at the moment.

[@GenjaOrigins]

@@DatabaseStar I think i need to Learn about 1-1, 1-N, N-1, N-N and when to use join table "pivot table". I think when 1-1 use foreign keys for everything else pivot table but i don't know how exactly. And i need learn normalization.

[@ThatBibleStudyGuy]

He sounds like the guy from cold fusion. Is he the same guy ???

[@DatabaseStar]

I don’t think so, I’ve never worked with Cold Fusion before! Who is the cold fusion guy?

[@ThatBibleStudyGuy]

You guys sound so similar ! lol@@DatabaseStar www.youtube.com/@ColdFusion

[@hemanthanagoda8955]

max

[@DatabaseStar]

Glad you like it (I think!)

[@smilingcookie1672]

Great video

[@DatabaseStar]

Thanks!