Resources:Completed Week One Individual Assignment titled, "DreamHome Case Study"Completed Week Two Individual Assignment titled, "Object Oriented Data Model and SQL Query Definition"Appendix A, "User
Advertisement
-adsNo
-dateAdvertised
-cost
Properties
-type
-noOfRooms
-rent
-address
Branch
-branchNo{PK}
-street
-city
-postCode
Leases
-paymentMethod
-advancedDeposit
-leaseDuration
-startDate
-endDate
SalesStaff
Manager
Staff
-Staff_no{PK}
-Position
-Salary
PrivateOwner
BusinessOwner
-businessType
-contactName
Owner
-OwnerNo{PK}
-OwnerType
Client
-Client_no{PK}
-PrefType
-MaxRent
-JoinDate
Person
-First_name
-Last_name
-Dob
-Gender
-address