HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Design database for real estate property management?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
realdesigndatabaseestatepropertyformanagement

Problem

I have design this database diagram to real estate property management just I want to see if I get it right especially the relation between properties and finances because I made it one(property) to many(finances"bank loans")?

Solution

Properties can be resold multiple times, refinanced multiple times, have multiple loans/cash financing options per, be sublet/subdivided, have to follow government reporting requirements for all of that, etc. You need a thorough understanding of the business and proper specifications; the fact that you asked the question you have asked suggests to me that either you don't, and/or that you lack experience in the biz. Also, "property" is the singular of "properties", so, "propertyID".

Context

StackExchange Database Administrators Q#56858, answer score: 3

Revisions (0)

No revisions yet.