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