How to Design a Database
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Turn your idea into a real database: https://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: https://www.lucidchart.com/pages/
Database modeling tools article: https://www.databasestar.com/data-mod...
Watch video How to Design a Database online without registration, duration hours minute second in high quality. This video was added by user Database Star 24 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 59,905 once and liked it 1.8 thousand people.