Management and information system help
FFx5526
mistc1_lowbudgetrentals_data.xlsxCustomer
| CUSTOMER_ID | CUSTOMER_FNAME | CUSTOMER_LNAME | STREET_ADDR1 | STREET_ADDR2 | CITY | STATE | ZIP | PHONE | |
| 1234567891 | JOHN | SMITH | 981 KINGS DR | RUSSVEGAS | AR | 72801 | [email protected] | 4799999971 | |
| 1234567892 | AMY | JOHNSON | 982 QUEENS AVE | RUSSVEGAS | AR | 72802 | [email protected] | 4799999972 | |
| 1234567893 | SARAH | JONES | 983 PRINCESS DR | RUSSVEGAS | AR | 72803 | [email protected] | 4799999973 | |
| 1234567894 | JESSICA | ARNOLD | 984 PRINCE DR | APT. #5 | RUSSVEGAS | AR | 72804 | [email protected] | 4799999974 |
| 1234567895 | AARON | ROBERTSON | 985 JACK RD | RUSSVEGAS | AR | 72805 | [email protected] | 4799999975 | |
| 1234567896 | KIM | WINDMERE | 986 JOKER DR | RUSSVEGAS | AR | 72806 | [email protected] | 4799999976 | |
| 1234567897 | ROBERT | JACOBS | 987 FIRST ST | RUSSVEGAS | AR | 72807 | [email protected] | 4799999977 | |
| 1234567898 | JOSE | GONZALEZ | 988 SECOND ST | RUSSVEGAS | AR | 72808 | [email protected] | 4799999978 | |
| 1234567899 | MOHAMMED | ALI | 989 THIRD ST | RUSSVEGAS | AR | 72809 | [email protected] | 4799999979 | |
| 1234567900 | LING | LEE | 990 FOURTH ST | DOVER | AR | 72810 | [email protected] | 4799999980 | |
| 1234567901 | MICHAEL | JORDAN | 991 FIFTH ST | CLARKSVILLE | AR | 72811 | [email protected] | 4799999981 | |
| 1234567902 | JIMMY | KIMMEL | 992 SIXTH ST | LONDON | AR | 72812 | [email protected] | 4799999982 | |
| 1234567903 | ANGELICA | HILL | 993 SEVENTH ST | RUSSELLVILLE | AR | 72813 | [email protected] | 4799999983 | |
| 1234567904 | ROBERTA | NEWMAN | 994 EIGHTH ST | RUSSELLVILLE | AR | 72814 | [email protected] | 4799999984 | |
| 1234567905 | TERRY | BRADSHAW | 995 NINTH ST | RUSSELLVILLE | AR | 72815 | [email protected] | 4799999985 | |
| 1234567906 | TOM | BRADY | 996 TENTH ST | RUSSELLVILLE | AR | 72816 | [email protected] | 4799999986 | |
| 1234567907 | ALEXIS | THOMPSON | 997 ELEVENTH ST | RUSSELLVILLE | AR | 72817 | [email protected] | 4799999987 |
Rental
| RENTAL_ID | RENTAL_DATE | EMP_ID | RENTAL_RETURN_DATE | VEHICLE_ID | CUSTOMER_ID | PAYMENT_METHOD | CARD_NBR | CARD_EXP_DATE | CARD SEC # | RENTAL_INSURANCE | RENTAL_PRICE | RENTAL_PRICE_ADJUSTMENT | INITIAL_MILEAGE | INITIAL_VEH_CONDITION | RETURN_MILEAGE | RETURN_VEH_CONDITION | RENTAL_NOTES |
| 54321 | 5/12/15 | 1 | 5/25/15 | 12345 | 1234567891 | CARD | 99999999999981 | 12/12/16 | 7771 | Y | 500 | 60 | 100000 | GOOD | 100100 | GOOD | |
| 54322 | 5/13/15 | 2 | 5/26/15 | 12346 | 1234567892 | CARD | 99999999999982 | 12/13/16 | 7772 | N | 1000 | 0 | 95000 | GOOD | 95100 | GOOD | |
| 54323 | 5/14/15 | 3 | 5/27/15 | 12347 | 1234567893 | CARD | 99999999999983 | 12/14/16 | 7773 | Y | 1500 | 5 | 90000 | GOOD | 90100 | GOOD | |
| 54324 | 5/15/15 | 4 | 5/28/15 | 12348 | 1234567894 | CARD | 99999999999984 | 12/15/16 | 7774 | N | 600 | 55 | 150000 | GOOD | 150100 | GOOD | |
| 54325 | 5/16/15 | 1 | 5/29/15 | 12349 | 1234567895 | CARD | 99999999999985 | 12/16/16 | 7775 | Y | 700 | 71 | 175000 | GOOD | 175200 | GOOD | |
| 54326 | 5/17/15 | 2 | 5/30/15 | 12350 | 1234567896 | CARD | 99999999999986 | 12/17/16 | 7776 | N | 800 | 72 | 2000 | GOOD | 3000 | GOOD | |
| 54327 | 5/18/15 | 3 | 5/31/15 | 12351 | 1234567897 | CARD | 99999999999987 | 12/18/16 | 7777 | Y | 1000 | 1 | 34000 | GOOD | 35000 | GOOD | |
| 54328 | 5/19/15 | 4 | 6/1/15 | 12352 | 1234567898 | CARD | 99999999999988 | 12/19/16 | 7778 | N | 500 | 5 | 56000 | GOOD | 57000 | GOOD | |
| 54329 | 5/20/15 | 1 | 6/2/15 | 12353 | 1234567899 | CARD | 99999999999989 | 12/20/16 | 7779 | Y | 1000 | 60 | 60000 | GOOD | 62000 | BAD | |
| 54330 | 5/21/15 | 2 | 6/3/15 | 12354 | 1234567900 | CARD | 99999999999990 | 12/21/16 | 7780 | N | 1500 | 0 | 45000 | GOOD | 46000 | GOOD | |
| 54331 | 5/22/15 | 3 | 6/4/15 | 12355 | 1234567901 | CARD | 99999999999991 | 12/22/16 | 7781 | Y | 600 | 5 | 44000 | GOOD | 45000 | GOOD | |
| 54332 | 5/23/15 | 4 | 6/5/15 | 12356 | 1234567902 | CARD | 99999999999992 | 12/23/16 | 7782 | N | 700 | 55 | 35000 | GOOD | 37000 | GOOD | |
| 54333 | 5/24/15 | 1 | 6/6/15 | 12357 | 1234567903 | CARD | 99999999999993 | 12/24/16 | 7783 | Y | 800 | 71 | 105000 | GOOD | 110000 | GOOD | |
| 54334 | 5/25/15 | 2 | 12358 | 1234567904 | CARD | 99999999999994 | 12/25/16 | 7784 | N | 1000 | 72 | 54000 | GOOD | 60000 | GOOD | ||
| 54335 | 5/26/15 | 3 | 12359 | 1234567905 | CARD | 99999999999995 | 12/26/16 | 7785 | Y | 700 | 1 | 100000 | GOOD | 105000 | GOOD | ||
| 54336 | 5/27/15 | 4 | 12360 | 1234567906 | CARD | 99999999999996 | 12/27/16 | 7786 | N | 800 | 5 | 90000 | GOOD | 85000 | GOOD | ||
| 54337 | 5/28/15 | 2 | 12361 | 1234567907 | CARD | 99999999999997 | 12/28/16 | 7787 | Y | 1000 | 25 | 95000 | GOOD | 100000 | GOOD |
Vehicle
| VEHICLE_ID | VEH_MAKE | VEH MODEL | VEH_YEAR | VEH_CONDITION | VEH_NOTES | Veh_Operational_Cost_per_Mile |
| 12345 | CHEVROLET | SILVERADO | 2001 | GOOD | $ 20.00 | |
| 12346 | FORD | TAURUS | 2000 | FAIR | $ 15.00 | |
| 12347 | FORD | F-150 | 2010 | GOOD | $ 13.00 | |
| 12348 | CHEVROLET | MALIBU | 2003 | BAD | TOTALLED | $ 6.00 |
| 12349 | NISSAN | ALTIMA | 2006 | FAIR | $ 7.00 | |
| 12350 | TOYOTA | CAMRY | 2013 | GOOD | $ 8.00 | |
| 12351 | TOYOTA | CORROLLA | 2014 | GOOD | $ 3.00 | |
| 12352 | HONDA | ACCORD | GOOD | $ 7.00 | ||
| 12353 | HONDA | CIVIC | 2011 | GOOD | $ 4.00 | |
| 12354 | GMC | DENALI | 2005 | BAD | $ 22.00 | |
| 12355 | DODGE | DURANGO | 2000 | FAIR | $ 18.00 | |
| 12356 | FIAT | UNO | 2007 | GOOD | BEST CAR | $ 5.00 |
| 12357 | HYUNDAI | SONATA | GOOD | $ 10.00 | ||
| 12358 | DODGE | NITRO | 2010 | GOOD | $ 15.00 | |
| 12359 | CHEVROLET | IMPALA | 2013 | GOOD | $ 10.00 | |
| 12360 | FORD | FOCUS | 2014 | GOOD | $ 5.00 | |
| 12361 | NISSAN | MAXIMA | 2008 | FAIR | $ 20.00 | |
| 12362 | FERRARI | GOOD | $ 100.00 |
