Design a Train Booking Database (Free ERD + SQL)
The full Entity Relationship Diagram, a plain-English description of all 10 tables, and a script to build it.
From the Database Star YouTube channel - 100k+ subscribers
- The complete ERD: see the whole database at a glance
- Every table and column explained, with sample data
- An SQL script that creates all tables, ready to copy and paste
Free PDF. Instant delivery. No spam, unsubscribe anytime.
What's Inside the PDF
Full ERD
The actual full ERD (Entity Relationship Diagram) from the video, for a Train Booking System
Table and Column Explanation
An explanation of the purpose of each table and column, with example values
SQL Scripts
SQL scripts to create the sample tables in your own database
Hi, I'm Ben.
I’ve been teaching SQL and database design on Database Star since 2016, and on YouTube I help over 100,000 people learn it. I’m an Oracle SQL Certified Expert with 20+ years of working with databases. This guide is the companion to my train booking video: the same design, written down in full so you can build it yourself.
Ready to design your own train booking database?
Get the full ERD, every table explained, and the SQL to build it. Free, straight to your inbox.
Free PDF. Instant delivery. No spam, unsubscribe anytime.
Here's what others say...
"I’ve watched a few of your videos now. Pure gold! And your PDF’s from your website are very useful. Thank you for taking the time and effort to create these."
Adrian Tregoning
"Your videos and website are a great resource for the database developer community."
@sdmagic
"They were really great resources for me to learn/review key concepts during my job search, which I was fortunate enough to land!"
@Kevin-kh7xv
