Database Design for Real Estate Company

📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=DeWO891SL5g
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?video=DeWO891SL5g

Real estate companies do a few different things, and a database design for one could get complicated. Listing properties for rent or sale, handling inspections with clients, contracts for sale or rent, employees, and more.

In this video, I'll show you how I would create a database design for a real estate company, taking you step-by-step through 11 different requirements and updating the design as we go.
⏱ TIMESTAMPS:
00:00 - Real estate company
00:25 - Requirement 1, property
03:12 - Requirement 2, sale or rent
04:08 - Requirement 3, price
04:57 - Requirement 4, features
06:00 - Requirement 5, process
07:50 - Requirement 6, employees on a property
09:56 - Requirement 7, employee details
10:27 - Requirement 8, inspections
11:11 - Requirement 9, clients
12:18 - Requirement 10, offers
13:27 - Requirement 11, sale
14:46 - Requirements met

🔗 VIDEO LINKS:
Text used to create the final design: https://github.com/bbrumm/databasestar/blob/main/videos/095_real_estate_db/Real%20Estate%20Design%20Markup.txt
ERD of the final design: https://github.com/bbrumm/databasestar/blob/main/videos/095_real_estate_db/095%20Real%20Estate%20Design.png

🔗 RESOURCES:
I used a tool called DBDiagram for this design: https://dbdiagram.io/

Видео Database Design for Real Estate Company канала Database Star