How to Design a Database

📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=5RpUmDEsn1k

🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=5RpUmDEsn1k

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: https://www.lucidchart.com/pages/

Database modeling tools article: https://www.databasestar.com/data-modeling-tools/