Database+Exercise+Using+a+database+for+strategic+business+development

 **After carefully studying the database tables at ** [|**www.prenhall.com/laudon(chapter**] **3)**  ** ,i have developed the following table of information that will help the ** **  management of the presidents' Inn to solve the problem of reservations and be comptetive and profitable . **   For December(2004)
 * For December (2004) **
 * Room || base income per room ||
 * Hayes || $450 ||
 * Cleveland || $900 ||
 * Coolidge || $750 ||
 * Washingtone || $3961 ||
 * lincoln || $2440 ||
 * Jefferson || $1050 ||
 * Jackson || $1750 ||
 * Reagan || $750 ||
 * Truman || $1125 ||
 * Garfield || $250 ||
 * Arthur || $1386 ||
 * Quincy Adams || $450 ||
 * Johnson || $500 ||
 * Van Buren || $300 ||
 * Madison || $1100 ||
 * Roosevelt || $550 ||
 * Tyler || $450 ||
 * Eisenhower || $1000 ||
 * Grant || $400 ||
 * Adams || $450 ||
 * Polk || $1036 ||
 * Mckinely || $375 ||
 * **Room Type** || **Side ** || **ocean** || 
 * bay-window** ||
 * ** Avg.length of stay per room type ** ||~ 5.5 days ||= **3.625 days** ||= **3 days** ||
 * **<span style="font-family: 'Times New Roman',Times,serif; font-size: 110%;">Avg.no.of visitors per room type ** ||~ 4 guests ||= **3 guests** ||= **2 guests** ||

<span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 110%; text-align: center;">__<span style="font-family: 'Times New Roman',Times,serif; font-size: 110%;">Breif Report __ <span style="font-family: 'Times New Roman',Times,serif; font-size: 110%;"> **Based on the preceding information I think that in terms of finance the strongest customer base are customers who go to washington room from ocean type this room had the largest income during december which is __$3961__** __<span style="font-family: 'Times New Roman',Times,serif; font-size: 110%;">. __<span style="font-family: 'Times New Roman',Times,serif; font-size: 110%;">**I think that the suitable business strategy is .to provide better information for strategic decisions we need more information about the internal and external environment,such as the no.of reservation for each room per season (summer ,winter ,autmn,spring) and in some occasions such as christmas,easter,holidays...information about the daily rate per room for your competitors ,internal information such as the no.of members avalible in the staff of services per room during a specific period of time.**