NOTES
The GUI output of this data set should be reflected in the figures in the project description.

DATA
Apartment Complexes
(ID, Name, Managed By)
1, North East, Jonathan Foreman
2, South West, Jessica Wilson

APARTMENT INFO
Units (id, #bed, #bath, floor)
North East
1, 1, 1, 1
2, 1, 1, 1
3, 1, 2, 2
4, 1, 2, 2

South West
1, 1, 1, 1
2, 1, 1, 1
3, 2, 2, 2
4, 2, 2, 2


SERVICE TYPE
	Carpet Cleaning
	A/C
	Electrical
	Landscaping
	Plumbers
	Painting
	Roof

CONTRACTOR
- ANZ Service: Carpet Cleaning, A/C, Electrical, Plumbers, Painting, Landscaping
- Metro Service: Lanscaping
- Monroe Ltd.: Plumbers, Painting
- NBC Corp.: A/C, Electrical

GENERAL MANAGER
3, richard, Richard Wilson

APARTMENT MANAGER
(uid,password, name)
1, jonathan, Jonathan Foreman
2, jessica, Jessica Simpson

CUSTOMER INFO
------------------- (Apartment 1)------------------------------------
4, stefany, Stefany Holmes
	Leases (months from to, unit, apartment, rate):
		10/1 - 12/31/2008, 1, 1, 700:  (going to expire as of 12/1 and has been renewed)
			Payment 10/1: paid on 10/1
			Payment 11/1: paid on 10/31
			Payment 12/1: paid on 12/2 (late)
				Request 12/1: A/C (approved with ANZ)
		Renewed lease: 1/1/2009 - 3/31/2009, 1, 1, 650

5, michael, Michael Brokeman (roof request, carpet Cleaning, plumbers, painting) (renew leases)
	Leases (months from to, unit, apartment):	
		7/1/2008 -  9/30/2008, 1, 1 (North East), 700 
			Payment 7/1: paid on 6/31
			Payment 8/1: paid on 8/5 (late)
				8/1: roof request
					Done by ANZ on 8/10
				8/2: carpet cleaning
					Done by ANZ on 8/10
				8/3: plumbers
					Done by ANZ on 8/10
			Payment 9/1: paid on 9/5 (late)
		10/1/2008 - 12/31/2008, 2, 1 (renewed leases, and moved to new apartment), 900  (going to expire as of 12/1)
			Payment 10/1: paid on 10/1
			Payment 11/1: paid on 10/31
				2/1: painting
					Done by Monroe Lt.d on 2/10
			Payment 12/1: paid on 12/3 (late)
				12/2: carpet cleaning (not yet approved by the manager)
------------------- (Apartment 2)------------------------------------
6, kepler, Kepler Wick
	Leases (months from to, unit, apartment:
		1/1/2008 - 3/31/2008, 1, 2, 700 (South West)
			Payment Jan 1: paid on Jan 1
			Payment Feb 1: paid on Jan 31
				1/10: electrical request, rejected by manager
			Payment Mar 1: paid on Mar 5 (late)

7, david, David Dutton
	Leases (months from to, unit, apartment, rate):
		10/1 - 12/31/2008, 2, 2, 800 (South West): (going to expire as of 12/1)
			Payment 10/1: paid on 10/1
			Payment 11/1: paid on 10/30
			Payment 12/1: not yet paid

8, avalon, Avalon Butcher:
	Leases (months from to, unit, apartment, rate):
		11/1/2008 - 3/31/2009, 3, 2, 1000 (South West):
			Payment 11/1: paid on 10/1
			Payment 12/1: paid on 11/30
				12/2: A/C request 
					done by ANZ
				12/3: Plumbers Request (not yet approved)					

9, feyman, Feyman Baker:
	Leases (months from to, unit, apartment):
		11/1/2008 - 5/31/2009, 4, 2, 1000 (South West):
			Payment 11/1: paid on 10/1
			Payment 12/1: paid on 11/30
				
Going to expire within one months