Docstoc

Here - Tech Support Guy

Document Sample
Here - Tech Support Guy Powered By Docstoc
					                                                         Room         Arrival     Departure
ID Guest First Name Guest Last Name      Room                                               Days
                                                         Type          Date         Date

1    Barry           Lloyd                    Hayes    Bay-window     12/1/2001    12/4/2001    3
2    Michael         Lunsford             Cleveland        Ocean      12/1/2001    12/9/2001    8
3    Kim             Kyuong                Coolidge    Bay-window     12/4/2001    12/7/2001    3
4    Edward          Holt               Washington         Ocean      12/1/2001    12/3/2001    2
5    Thomas          Collins                 Lincoln       Ocean      12/9/2001   12/13/2001    4
6    Paul            Bodkin                Coolidge    Bay-window     12/1/2001    12/3/2001    2
7    Randall         Battenburg         Washington         Ocean      12/4/2001   12/12/2001    8
8    Calvin          Nowotney                Lincoln       Ocean      12/2/2001    12/4/2001    2
9    Homer           Gonzalez                Lincoln       Ocean      12/5/2001    12/7/2001    2
10   David           Sanchez              Jefferson    Bay-window     12/5/2001    12/7/2001    2
11   Buster          Whisler               Jackson         Ocean      12/5/2001    12/8/2001    3
12   Julia           Martines               Reagan     Bay-window    12/10/2001   12/15/2001    5
13   Samuel          Kim                    Truman            Side   12/20/2001   12/30/2001   10
14   Arthur          Gottfried              Garfield          Side   12/13/2001   12/15/2001    2
15   Darlene         Shore                    Arthur       Ocean     12/24/2001   12/31/2001    7
16   Carlyle         Charleston       Quincy Adams     Bay-window     12/3/2001    12/6/2001    3
17   Albert          Goldstone             Johnson         Ocean      12/5/2001    12/7/2001    2
18   Charlene        Tilson              Van Buren     Bay-window     12/5/2001    12/7/2001    2
19   Everett         Chad                  Madison         Ocean     12/10/2001   12/14/2001    4
20   Gerald          Pittsfield           Roosevelt        Ocean      12/5/2001    12/7/2001    2
21   Jamal           Smith                     Tyler   Bay-window    12/20/2001   12/23/2001    3
22   Louis           Paris                 Jackson         Ocean     12/10/2001   12/14/2001    4
23   Nigel           Stratford          Eisenhower         Ocean     12/14/2001   12/16/2001    2
24   Peter           Willington               Grant        Ocean     12/19/2001   12/21/2001    2
25   Ronald          Cartier              Jefferson    Bay-window    12/24/2001   12/28/2001    4
26   Trista          Leven              Eisenhower         Ocean     12/17/2001   12/20/2001    3
27   Valerie         Snell                   Adams     Bay-window     12/3/2001    12/6/2001    3
28   Walter          Acton                      Polk          Side   12/24/2001   12/31/2001    7
29   Xavier          Trezza                McKinley           Side   12/14/2001   12/17/2001    3
30   Zachary         Miller             Washington         Ocean     12/13/2001   12/16/2001    3
31   Place example   Here                                                                       0
         Starting                        Enter
No. of            5+ People Discounted             Final
          Daily                          other                     Total
Guests            Daily Rate   Rate              Daily Rate
          Rate                         discounts
  2      $150.00   $   150.00   $   150.00   20.00% $   120.00   $ 360.00
  3      $112.50   $   112.50   $   101.25          $   101.25   $ 810.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  4      $325.00   $   325.00   $   325.00          $   325.00   $ 650.00
  2      $300.00   $   300.00   $   300.00          $   300.00   $ 1,200.00
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 300.00
  2      $292.50   $   292.50   $   263.25          $   263.25   $ 2,106.00
  1      $300.00   $   300.00   $   300.00          $   300.00   $ 600.00
  5      $320.00   $   340.00   $   320.00          $   320.00   $ 640.00
  2      $175.00   $   175.00   $   175.00          $   175.00   $ 350.00
  2      $250.00   $   250.00   $   250.00          $   250.00   $ 750.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 750.00
  3      $112.50   $   112.50   $   101.25          $   101.25   $ 1,012.50
  2      $125.00   $   125.00   $   125.00          $   125.00   $ 250.00
  5      $198.00   $   218.00   $   178.20          $   178.20   $ 1,247.40
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  3      $250.00   $   250.00   $   250.00          $   250.00   $ 500.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 300.00
  2      $275.00   $   275.00   $   275.00          $   275.00   $ 1,100.00
  2      $275.00   $   275.00   $   275.00          $   275.00   $ 550.00
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  1      $250.00   $   250.00   $   250.00          $   250.00   $ 1,000.00
  2      $200.00   $   200.00   $   200.00          $   200.00   $ 400.00
  1      $200.00   $   200.00   $   200.00          $   200.00   $ 400.00
  4      $175.00   $   175.00   $   175.00          $   175.00   $ 700.00
  1      $200.00   $   200.00   $   200.00          $   200.00   $ 600.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  6      $148.50   $   188.50   $   133.65          $   133.65   $ 935.55
  2      $125.00   $   125.00   $   125.00          $   125.00   $ 375.00
  2      $325.00   $   325.00   $   325.00          $   325.00   $ 975.00
                   $      -     $      -            $      -     $      -
Database Exercise: Using a Database for Strategic Business Development
     The Presidents' Inn is a three-story hotel on the Atlantic Ocean in Cape May, NJ, a popular Northeastern U.S. resort.
     Ten rooms overlook side streets, ten rooms have bay windows that offer limited views of the ocean, and the remaining te
     rooms in the front of the hotel face the ocean. Room rates are based on room choice, length of stay, and number of gues
     per room. Room rates are the same for one to four guests. Fifth and sixth guests must pay an additional $20 charge eac
     per day. Guests staying for seven days or more receive a ten-percent discount on their daily room rates.
     Business has grown steadily over the past ten years. Now totally renovated, the hotel uses a romantic weekend package
     to attract couples, a vacation package to attract young families, and a weekday discount package to attract business
     travelers. The owners currently use a manual reservation and bookkeeping system, which has caused many problems.
     Sometimes two families have been booked in the same room at the same time. Management does not have immediate d
     about the bed and breakfast's daily operations and income.
     Based on the information provided below, develop reports that would provide information to help management make the
     business more competitive and profitable. The database and related queries should be designed to make it easy to ident
     the information such as the average length of stay per room type, the average number of visitors per room type, and the
     base income per room (i.e., length of visit multiplied times the daily rate) during a specified period of time.
     After identifying the above information, write a brief report describing what your database information tells you about your
     current business situation. For example, what is your strongest customer base? What specific business strategies might
     you pursue to increase room occupancy and revenue? For example, would you add, modify, or delete discount packages
      Why or why not? Design at least two discount packages. Show the effect on the revenue of the company.
ID   Guest First Name Guest Last Name Room                      Room Type Arrival Date Departure Date
1    Barry                 Lloyd               Hayes            Bay-window 12/1/2001         12/4/2001
2    Michael               Lunsford            Cleveland        Ocean          12/1/2001     12/9/2001
3    Kim                   Kyuong              Coolidge         Bay-window 12/4/2001         12/7/2001
4    Edward                Holt                Washington       Ocean          12/1/2001     12/3/2001
5    Thomas                Collins             Lincoln          Ocean          12/9/2001     12/13/2001
6    Paul                  Bodkin              Coolidge         Bay-window 12/1/2001         12/3/2001
7    Randall               Battenburg          Washington       Ocean          12/4/2001     12/12/2001
8    Calvin                Nowotney            Lincoln          Ocean          12/2/2001     12/4/2001
9    Homer                 Gonzalez            Lincoln          Ocean          12/5/2001     12/7/2001
10   David                 Sanchez             Jefferson        Bay-window 12/5/2001         12/7/2001
11   Buster                Whisler             Jackson          Ocean          12/5/2001     12/8/2001
12   Julia                 Martines            Reagan           Bay-window 12/10/2001 12/15/2001
13   Samuel                Kim                 Truman           Side           12/20/2001 12/30/2001
14   Arthur                Gottfried           Garfield         Side           12/13/2001 12/15/2001
15   Darlene               Shore               Arthur           Ocean          12/24/2001 12/31/2001
16   Carlyle               Charleston          Quincy Adams Bay-window 12/3/2001             12/6/2001
17   Albert                Goldstone           Johnson          Ocean          12/5/2001     12/7/2001
18   Charlene              Tilson              Van Buren        Bay-window 12/5/2001         12/7/2001
19   Everett               Chad                Madison          Ocean          12/10/2001 12/14/2001
20   Gerald                Pittsfield          Roosevelt        Ocean          12/5/2001     12/7/2001
21   Jamal                 Smith               Tyler            Bay-window 12/20/2001 12/23/2001
22   Louis                 Paris               Jackson          Ocean          12/10/2001 12/14/2001
23   Nigel                 Stratford           Eisenhower       Ocean          12/14/2001 12/16/2001
24   Peter                 Willington          Grant            Ocean          12/19/2001 12/21/2001
25   Ronald                Cartier             Jefferson        Bay-window 12/24/2001 12/28/2001
26   Trista                Leven               Eisenhower       Ocean          12/17/2001 12/20/2001
27   Valerie               Snell               Adams            Bay-window 12/3/2001         12/6/2001
28   Walter                Acton               Polk             Side           12/24/2001 12/31/2001
29   Xavier                Trezza              McKinley         Side           12/14/2001 12/17/2001
30   Zachary               Miller              Washington       Ocean          12/13/2001 12/16/2001
ular Northeastern U.S. resort.
 f the ocean, and the remaining ten
ength of stay, and number of guests
pay an additional $20 charge each
daily room rates.
ses a romantic weekend package
 t package to attract business
 ch has caused many problems.
ement does not have immediate data

 n to help management make the
 designed to make it easy to identify
of visitors per room type, and the
 ied period of time.
 e information tells you about your
 pecific business strategies might
odify, or delete discount packages?
ue of the company.
               No of Guests Daily Rate
               2              $150.00
               3              $112.50
               1              $150.00
               4              $325.00
               2              $300.00
               2              $150.00
               2              $292.50
               1              $300.00
               5              $320.00
               2              $175.00
               2              $250.00
               1              $150.00
               3              $112.50
               2              $125.00
               5              $198.00
               2              $150.00
               3              $250.00
               1              $150.00
               2              $275.00
               2              $275.00
               2              $150.00
               1              $250.00
               2              $200.00
               1              $200.00
               4              $175.00
               1              $200.00
               1              $150.00
               6              $148.50
               2              $125.00
               2              $325.00
                                                            Room         Arrival     Departure
 ID   Guest First Name Guest Last Name      Room                                               Days
                                                            Type          Date         Date

1     Barry           Lloyd                      Hayes    Bay-window     12/1/2001    12/4/2001    3
2     Michael         Lunsford               Cleveland        Ocean      12/1/2001    12/9/2001    8
3     Kim             Kyuong                  Coolidge    Bay-window     12/4/2001    12/7/2001    3
4     Edward          Holt                 Washington         Ocean      12/1/2001    12/3/2001    2
5     Thomas          Collins                   Lincoln       Ocean      12/9/2001   12/13/2001    4
6     Paul            Bodkin                  Coolidge    Bay-window     12/1/2001    12/3/2001    2
7     Randall         Battenburg           Washington         Ocean      12/4/2001   12/12/2001    8
8     Calvin          Nowotney                  Lincoln       Ocean      12/2/2001    12/4/2001    2
9     Homer           Gonzalez                  Lincoln       Ocean      12/5/2001    12/7/2001    2
10    David           Sanchez                Jefferson    Bay-window     12/5/2001    12/7/2001    2
11    Buster          Whisler                 Jackson         Ocean      12/5/2001    12/8/2001    3
12    Julia           Martines                 Reagan     Bay-window    12/10/2001   12/15/2001    5
13    Samuel          Kim                      Truman            Side   12/20/2001   12/30/2001   10
14    Arthur          Gottfried                Garfield          Side   12/13/2001   12/15/2001    2
15    Darlene         Shore                      Arthur       Ocean     12/24/2001   12/31/2001    7
16    Carlyle         Charleston         Quincy Adams     Bay-window     12/3/2001    12/6/2001    3
17    Albert          Goldstone               Johnson         Ocean      12/5/2001    12/7/2001    2
18    Charlene        Tilson                Van Buren     Bay-window     12/5/2001    12/7/2001    2
19    Everett         Chad                    Madison         Ocean     12/10/2001   12/14/2001    4
20    Gerald          Pittsfield             Roosevelt        Ocean      12/5/2001    12/7/2001    2
21    Jamal           Smith                       Tyler   Bay-window    12/20/2001   12/23/2001    3
22    Louis           Paris                   Jackson         Ocean     12/10/2001   12/14/2001    4
23    Nigel           Stratford            Eisenhower         Ocean     12/14/2001   12/16/2001    2
24    Peter           Willington                 Grant        Ocean     12/19/2001   12/21/2001    2
25    Ronald          Cartier                Jefferson    Bay-window    12/24/2001   12/28/2001    4
26    Trista          Leven                Eisenhower         Ocean     12/17/2001   12/20/2001    3
27    Valerie         Snell                     Adams     Bay-window     12/3/2001    12/6/2001    3
28    Walter          Acton                        Polk          Side   12/24/2001   12/31/2001    7
29    Xavier          Trezza                  McKinley           Side   12/14/2001   12/17/2001    3
30    Zachary         Miller               Washington         Ocean     12/13/2001   12/16/2001    3
         Starting                        Enter
No. of            5+ People Discounted             Final
          Daily                          other                     Total
Guests            Daily Rate   Rate              Daily Rate
          Rate                         discounts
  2      $150.00   $   150.00   $   150.00   20.00% $   120.00   $ 360.00
  3      $112.50   $   112.50   $   101.25          $   101.25   $ 810.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  4      $325.00   $   325.00   $   325.00          $   325.00   $ 650.00
  2      $300.00   $   300.00   $   300.00          $   300.00   $ 1,200.00
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 300.00
  2      $292.50   $   292.50   $   263.25          $   263.25   $ 2,106.00
  1      $300.00   $   300.00   $   300.00          $   300.00   $ 600.00
  5      $320.00   $   340.00   $   320.00          $   320.00   $ 640.00
  2      $175.00   $   175.00   $   175.00          $   175.00   $ 350.00
  2      $250.00   $   250.00   $   250.00          $   250.00   $ 750.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 750.00
  3      $112.50   $   112.50   $   101.25          $   101.25   $ 1,012.50
  2      $125.00   $   125.00   $   125.00          $   125.00   $ 250.00
  5      $198.00   $   218.00   $   178.20          $   178.20   $ 1,247.40
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  3      $250.00   $   250.00   $   250.00          $   250.00   $ 500.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 300.00
  2      $275.00   $   275.00   $   275.00          $   275.00   $ 1,100.00
  2      $275.00   $   275.00   $   275.00          $   275.00   $ 550.00
  2      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  1      $250.00   $   250.00   $   250.00          $   250.00   $ 1,000.00
  2      $200.00   $   200.00   $   200.00          $   200.00   $ 400.00
  1      $200.00   $   200.00   $   200.00          $   200.00   $ 400.00
  4      $175.00   $   175.00   $   175.00          $   175.00   $ 700.00
  1      $200.00   $   200.00   $   200.00          $   200.00   $ 600.00
  1      $150.00   $   150.00   $   150.00          $   150.00   $ 450.00
  6      $148.50   $   188.50   $   133.65          $   133.65   $ 935.55
  2      $125.00   $   125.00   $   125.00          $   125.00   $ 375.00
  2      $325.00   $   325.00   $   325.00          $   325.00   $ 975.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:2/3/2013
language:Unknown
pages:9