MI assignment-Management information systems-OLAP assignments

profileyxuesong
mdcc_res_oct15.accdb
Home>Information Systems homework help>MI assignment-Management information systems-OLAP assignments
ResNo Room# CustNo RateCode ResDate ResStartDate ResEndDate AccCode
R0001 AU C0012 ST 11/14/05 8/5/06 8/5/06 LE
R0001 BD C0012 ST 11/14/05 8/5/06 8/5/06 CI
R0002 CF C0011 AD 11/14/05 8/7/06 8/9/06 LE
R0003 CA C0006 AD 12/3/05 8/6/06 8/6/06 LE
R0003 CO C0006 AD 12/3/05 8/6/06 8/6/06 LE
R0004 FL C0007 ST 12/5/05 8/6/06 8/6/06 LE
R0005 GA C0008 ST 12/6/05 8/6/06 8/6/06 LE
R0006 AL C0009 ST 12/23/05 8/6/06 8/6/06 LE
R0007 FL C0010 AD 12/24/05 8/7/06 8/8/06 LE
R0007 GA C0010 AD 12/24/05 8/7/06 8/8/06 LE
R0008 CA C0011 AD 12/26/05 8/7/06 8/9/06 CL
R0008 CO C0011 AD 12/26/05 8/7/06 8/9/06 CL
R0009 AL C0020 AD 1/4/06 8/10/06 8/10/06 LE
R0009 CA C0020 AD 1/4/06 8/10/06 8/10/06 LE
R0010 AL C0001 AD 1/5/06 6/7/06 6/7/06 LE
R0010 CA C0001 AD 1/5/06 6/7/06 6/7/06 CI
R0011 CO C0002 ST 1/5/06 6/7/06 6/7/06 US
R0012 FL C0003 ST 1/5/06 6/7/06 6/7/06 CL
R0013 AL C0022 SP 1/5/06 6/8/06 6/12/06 US
R0013 AU C0022 SP 1/5/06 6/8/06 6/12/06 CL
R0013 BD C0022 SP 1/5/06 6/8/06 6/12/06 CL
R0013 CA C0022 SP 1/5/06 6/8/06 6/12/06 US
R0013 CF C0022 SP 1/5/06 6/8/06 6/12/06 LE
R0013 CO C0022 SP 1/5/06 6/8/06 6/12/06 US
R0013 FL C0022 SP 1/5/06 6/8/06 6/12/06 US
R0013 GA C0022 SP 1/5/06 6/8/06 6/12/06 LE
R0014 CA C0023 AD 1/6/06 6/13/06 6/13/06 CI
R0014 CF C0023 AD 1/6/06 6/13/06 6/13/06 CI
R0015 AL C0024 AD 1/24/06 7/1/06 7/4/06 LE
R0015 GA C0024 AD 1/24/06 7/1/06 7/4/06 LE
R0016 AL C0025 ST 1/25/06 6/15/06 6/18/06 LE
R0016 AU C0025 ST 1/25/06 6/14/06 6/19/06 US
R0016 BD C0025 ST 1/25/06 6/14/06 6/19/06 US
R0016 FL C0025 ST 1/25/06 6/15/06 6/18/06 LE
R0016 GA C0025 ST 1/25/06 6/15/06 6/18/06 LE
R0017 AL C0005 ST 2/15/06 8/1/06 8/5/06 CL
R0017 CA C0005 ST 2/15/06 8/1/06 8/5/06 CL
R0017 CO C0005 ST 2/15/06 8/1/06 8/5/06 CL
R0017 FL C0005 ST 2/15/06 8/1/06 8/5/06 CL
R0017 GA C0005 ST 2/15/06 8/1/06 8/5/06 CL
R0018 BD C0026 ST 2/27/06 8/23/06 8/28/06 LE
R0018 CF C0026 ST 2/27/06 8/23/06 8/28/06 LE
R0018 CO C0026 ST 2/27/06 8/23/06 8/28/06 LE
R0019 AU C0013 SP 3/15/06 8/12/06 8/15/06 LE
R0019 BD C0013 SP 3/15/06 8/12/06 8/15/06 CI
R0019 CA C0013 SP 3/15/06 8/12/06 8/15/06 US
R0019 GA C0013 SP 3/15/06 8/12/06 8/15/06 US
R0020 CO C0014 ST 4/12/06 8/12/06 8/14/06 CL
R0020 FL C0014 ST 4/12/06 8/12/06 8/14/06 CL
R0021 FL C0015 ST 4/17/06 8/15/06 8/15/06 LE
R0022 AU C0016 ST 4/18/06 8/11/06 8/11/06 LE
R0022 BD C0016 ST 4/18/06 8/11/06 8/11/06 CI
R0023 BD C0017 ST 5/1/06 8/16/06 8/18/06 CI
R0023 FL C0017 ST 5/1/06 8/16/06 8/18/06 US
R0023 GA C0017 ST 5/1/06 8/16/06 8/18/06 US
R0024 AL C0018 SP 5/2/06 8/16/06 8/18/06 LE
R0024 CA C0018 SP 5/2/06 8/16/06 8/18/06 LE
R0024 CF C0018 SP 5/2/06 8/16/06 8/18/06 LE
R0024 CO C0018 SP 5/2/06 8/16/06 8/18/06 US
R0025 AL C0019 ST 5/3/06 8/19/06 8/20/06 CI
R0025 BD C0019 ST 5/3/06 8/19/06 8/20/06 CI
R0025 CF C0019 ST 5/3/06 8/19/06 8/20/06 LE
R0025 FL C0019 ST 5/3/06 8/19/06 8/20/06 CI
R0026 AL C0021 SP 5/3/06 8/5/06 8/7/06 CI
R0026 CF C0021 ST 5/3/06 8/5/06 8/5/06 CI
R0027 AL C0022 ST 5/4/06 9/5/06 9/10/06 LE
R0027 CF C0022 SP 5/4/06 8/25/06 8/30/06 US