APAN5310checkpoint1Group8

SelectedScenario:“DreamHomesNYC”

Wechosethe"DreamHomesNYC"scenarioduetoitscomplexityandthediversedatait

requiresmanaging.Mostofthemembersareinterestedinorhadexperienceintherealestate

industry.Thisrealestateagencyscenarioinvolvesrich,multifaceteddatacategorieslikehomes,

clients,transactions,andevents.

Ourdatabasedesigninvolves:

CorporateData:Offices,Employees,EmployeeRoles,ExpensesandProfits

PropertyListings:Homes,HomeFeatures

ClientData:Clients,ClientPreferences

Transactions:Transactions,TransactionTypes,PaymentMethods,TransactionPayments

Events:OpenHouses,Appointments

Marketing:MarketingCampaigns,CampaignResults,DocumentStorage

Thedatabaseisdesignedwithnormalizationinmindtoensuredataintegrityandeliminate

redundancy.EachtableisstructuredtooperateintheThirdNormalForm(3NF).

Wereviewedexistingrealestatedatabasemodelsandindustrycasestudiestounderstand

commonchallengesandbestpractices.Thisresearchhighlightedtheimportanceofdata

accuracy,handlinglargevolumesofdata,andprovidingtimelyinsights.

Ourinitialplaninvolvesthoroughrequirementsgathering,followedbyiterativedesignand

testingphasestoensurethedatabasemeetsallclientneedsandsupportstheirbusiness

objectiveseffectively.

BenefitstotheClient:

1.EnhancedDecision-Making:Real-timeaccesstocomprehensivedataandadvancedqueries

willenablequicker,moreinformeddecisions.

2.OperationalEfficiency:Automatingdataprocesseswillreduceerrorsandincreasestaff

productivity,allowingthemtofocusonclientservices.

3.ImprovedClientExperience:Streamlineddatamanagementwillsimplifythehomebuying,

selling,andrentingprocesses,enhancingclientsatisfaction.

4.Scalability:AscalabledatabasedesignwillsupportDreamHomesNYC’sgrowthandfuture

technologicaladvancements,suchasdevelopingaclient-facingapp.