The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Property Management...
This data model was designed to handle rental property management.  (Note, there only tables included in this database the balance is up to you!)
Business Rules...

Each Unit can have multiple Guests

Each Guest may have a car

Units pricing may change

Each Unit will have to be Inspected when a new Guest moves in

There can be multiple Properties

Each Property can have multiple Buildings

Each Building can have multiple rental Units and commercial space

Some Guests may be companies

Each Building may have Features

Each Building will have Utilities

Main Entities...




Each Building can have a Manager

Each Unit has Features

Download Sample (Access 2003 and Unzipping program needed)