Independent Project 4-6 Courtyard Medical Plaza FOUR HRS TO COMPLETE

profileLucy_93
CourtyardMedicalPlaza-04copy.accdb
Home>Computer Science homework help>Independent Project 4-6 Courtyard Medical Plaza FOUR HRS TO COMPLETE
DoctorID LastName FirstName OfficeNumber PrimarySpecialty MoveInDate
1 Beyer Robert 101 Cardiovascular Disease 2/5/12
2 Scher Elizabeth 115 Pediatrics 4/1/14
3 Ostrander Emy 101 Cardiovascular Disease 11/8/14
4 Foster Margaret 200 Pediatrics 7/1/05
5 Flores Ricardo 151 Internal Medicine 2/1/15
6 Camacho Juan 180 Dermatology 6/1/10
7 Alamar Alicia 151 Internal Medicine 2/20/11
8 Hennessy James 220 Pediatrics 7/1/10
9 Plice Rick 305 Family Medicine 3/15/08
10 Dyer Daniel 115 Pediatrics 4/1/14
11 Singh Robyn 210 Family Medicine 6/1/13
12 Norman Steven 230 Internal Medicine 12/15/07
13 Ansari Randy 180 Dermatology 4/1/12
14 Pelayo Kumara 210 Family Medicine 5/15/07
15 Bolden Victor 215 Podiatry 1/15/16
16 Fowler Seth 140 Allergy & Immunology 3/23/16
InvoiceID InvoiceDate DueDate AmountDue FKDoctorID Description DateReceived Discount
1 4/14/17 5/1/17 ¤ 1,250.00 1 May 2017 Rent (Beyer & Ostrander) 4/30/17
2 4/14/17 5/1/17 ¤ 1,100.00 2 May 2017 Rent (Scher & Dyer) 5/1/17
3 4/14/17 5/1/17 ¤ 1,350.00 4 May 2017 Rent 5/1/17
4 4/14/17 5/1/17 ¤ 1,350.00 5 May 2017 Rent (Flores & Alamar) 4/29/17 ¤ 13.50
5 4/14/17 5/1/17 ¤ 1,100.00 6 May 2017 Rent (Camacho & Ansari) 5/1/17
6 4/14/17 5/1/17 ¤ 1,600.00 8 May 2017 Rent 5/1/17
7 4/14/17 5/1/17 ¤ 1,400.00 9 May 2017 Rent 5/1/17
8 4/14/17 5/1/17 ¤ 1,650.00 11 May 2017 Rent (Singh & Pelayo) 5/1/17
9 4/14/17 5/1/17 ¤ 1,600.00 12 May 2017 Rent 4/29/17 ¤ 16.00
10 5/15/17 6/1/17 ¤ 1,250.00 1 June 2017 Rent (Beyer & Ostrander) 5/29/17 ¤ 25.00
11 5/15/17 6/1/17 ¤ 1,100.00 2 June 2017 Rent (Scher & Dyer) 6/1/17
12 5/15/17 6/1/17 ¤ 1,350.00 4 June 2017 Rent 6/1/17
13 5/15/17 6/1/17 ¤ 1,350.00 5 June 2017 Rent (Flores & Alamar) 5/28/17 ¤ 27.00
14 5/15/17 6/1/17 ¤ 1,100.00 6 June 2017 Rent (Camacho & Ansari) 6/1/17
15 5/15/17 6/1/17 ¤ 1,600.00 8 June 2017 Rent 6/1/17
16 5/15/17 6/1/17 ¤ 1,400.00 9 June 2017 Rent 6/1/17
17 5/15/17 6/1/17 ¤ 1,650.00 11 June 2017 Rent (Singh & Pelayo) 6/1/17
18 5/15/17 6/1/17 ¤ 1,600.00 12 June 2017 Rent 5/28/17 ¤ 32.00
19 6/16/17 7/1/17 ¤ 1,250.00 1 July 2017 Rent (Beyer & Ostrander) 6/30/17
20 6/16/17 7/1/17 ¤ 1,100.00 2 July 2017 Rent (Scher & Dyer) 7/1/17
21 6/16/17 7/1/17 ¤ 1,350.00 4 July 2017 Rent 7/1/17
22 6/16/17 7/1/17 ¤ 1,350.00 5 July 2017 Rent (Flores & Alamar) 6/29/17 ¤ 13.50
23 6/16/17 7/1/17 ¤ 1,100.00 6 July 2017 Rent (Camacho & Ansari) 6/30/17
24 6/16/17 7/1/17 ¤ 1,600.00 8 July 2017 Rent 7/1/17
25 6/16/17 7/1/17 ¤ 1,400.00 9 July 2017 Rent 7/1/17
26 6/16/17 7/1/17 ¤ 1,650.00 11 July 2017 Rent (Singh & Pelayo) 7/1/17
27 6/16/17 7/1/17 ¤ 1,600.00 12 July 2017 Rent 6/29/17 ¤ 16.00
28 7/14/17 8/1/17 ¤ 1,250.00 1 August 2017 Rent (Beyer & Ostrander) 8/1/17
29 7/14/17 8/1/17 ¤ 1,100.00 2 August 2017 Rent (Scher & Dyer) 8/1/17
30 7/14/17 8/1/17 ¤ 1,350.00 4 August 2017 Rent 8/1/17
31 7/14/17 8/1/17 ¤ 1,350.00 5 August 2017 Rent (Flores & Alamar) 8/1/17
32 7/14/17 8/1/17 ¤ 1,100.00 6 August 2017 Rent (Camacho & Ansari) 7/29/17 ¤ 22.00
33 7/14/17 8/1/17 ¤ 1,600.00 8 August 2017 Rent 8/1/17
34 7/14/17 8/1/17 ¤ 1,400.00 9 August 2017 Rent 8/1/17
35 7/14/17 8/1/17 ¤ 1,650.00 11 August 2017 Rent (Singh & Pelayo) 7/27/17 ¤ 33.00
36 7/14/17 8/1/17 ¤ 1,600.00 12 August 2017 Rent 8/1/17
37 8/17/17 9/1/17 ¤ 1,250.00 1 September 2017 Rent (Beyer & Ostrander) 9/1/17
38 8/17/17 9/1/17 ¤ 1,100.00 2 September 2017 Rent (Scher & Dyer) 9/1/17
39 8/17/17 9/1/17 ¤ 1,350.00 4 September 2017 Rent 8/29/17 ¤ 27.00
40 8/17/17 9/1/17 ¤ 1,350.00 5 September 2017 Rent (Flores & Alamar) 9/1/17
41 8/17/17 9/1/17 ¤ 1,100.00 6 September 2017 Rent (Camacho & Ansari) 8/27/17 ¤ 22.00
42 8/17/17 9/1/17 ¤ 1,600.00 8 September 2017 Rent 9/1/17
43 8/17/17 9/1/17 ¤ 1,400.00 9 September 2017 Rent 9/1/17
44 8/17/17 9/1/17 ¤ 1,650.00 11 September 2017 Rent (Singh & Pelayo) 9/1/17
45 8/17/17 9/1/17 ¤ 1,600.00 12 September 2017 Rent 8/30/17 ¤ 16.00
46 9/15/17 10/1/17 ¤ 1,250.00 1 October 2017 Rent (Beyer & Ostrander) 9/30/17
47 9/15/17 10/1/17 ¤ 1,100.00 2 October 2017 Rent (Scher & Dyer) 10/1/17
48 9/15/17 10/1/17 ¤ 1,350.00 4 October 2017 Rent 9/29/17 ¤ 13.50
49 9/15/17 10/1/17 ¤ 1,350.00 5 October 2017 Rent (Flores & Alamar) 10/1/17
50 9/15/17 10/1/17 ¤ 1,100.00 6 October 2017 Rent (Camacho & Ansari) 10/1/17
51 9/15/17 10/1/17 ¤ 1,600.00 8 October 2017 Rent 10/1/17
52 9/15/17 10/1/17 ¤ 1,400.00 9 October 2017 Rent 10/1/17
53 9/15/17 10/1/17 ¤ 1,650.00 11 October 2017 Rent (Singh & Pelayo) 9/28/17 ¤ 33.00
54 9/15/17 10/1/17 ¤ 1,600.00 12 October 2017 Rent 10/1/17