How to Create a Database Design From an Idea

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

/// RESOURCES
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-road...
✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd
🎓 Improve your SQL and database skills with Database Star Academy: https://www.databasestar.com/dsa/
📧 Contact me here: https://www.databasestar.com/contact/

📝 Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi
📝 SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk
📝 SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny
📝 Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau

Links:
Lucidchart: https://www.lucidchart.com/pages/
Database modeling tools article: https://www.databasestar.com/data-mod...
Database Star Academy: https://www.databasestar.com/dsa/