Student Reviews
( 5 Of 5 )
1 review
Video of Database Design for Real Estate Company in Database ERD Principles course by Database Star channel, video No. 21 free certified online
Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign95
Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign95
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/