Description Of The Project From The List

Project Description:Emerald Realty group is a real estate company which actually deals in selling, renting and buying of real estate properties, they may be the owner of property or may not be, but for sure they might be included in the deal, they will get the royalties. This business is actually maintained on papers first and they now wants to introduce some automated way of handling such transaction. So, they selected database which will help them in maintaining their records. The complete E-R model in an E-R diagramAny assumptions that you makeFor creating the database there are several assumption needs to be make, which will help us in providing 3NF database, here in the database ER diagram picture it is almost clear, we have a separate table for owner of property which name is PropertyOwnerDetails and then for every property transaction we have created a new table which name is PropertyTransactionDetails. These both tables are actually storing the data which are for the property users and transaction specific. Anything else that you think helps explain, clarify and validate your E-R model.In this ER model we have assumed the system with referential integrity which helps us in maintain good relations between