CASE BACKGROUND

MGMT Boutique Inc. is a high$-$end retailer that operates a chain of boutique stores in major hotel properties along the west coast of Barbados, including the famous five$-$diamonds Sandy Lane Hotel. Operating in eleven $(11)$ locations, the company offers chic brands like Roberto Cavalli, Pain$-$de$-$Sucre, Versace, and Etro Milano, to name a few, and is well known for an eclectic collection of designer swimwear, fine linens, cotton and silk apparel for warm days and sultry evenings. A fine complement of shoes, hats and handbags with hand$-$picked custom jewelry are included to embrace the very essence of luxurious fashion. The locations connect over a MetroE$-$wide area network $($WAN$)$ that FLOW provides. Each store has a local Point$-$of$-$Sale $($POS$),$ replicated to a central hub in the main office. Replication occurs once every $15$ minutes, so the head office is virtually up$-$to$-$date, in real$-$time, and can see, at a glance, transactions in each store. Customers primarily shop duty$-$free, paying in either Barbados $($BDS$)$ or USA dollars. Duty$-$free sales do not attract a $15\mathrm{.}0\%$ VAT tax. The list price, seen on the shelf, is the price paid. For customer convenience, the company offers a limited range of duty$-$paid items. Again, customers can pay in either currency or the price listed on the self is still the price paid. However, this price now includes $15\mathrm{.}0\%$ VAT. Customers pay by cash or card, charge the expense to their room, and settle the bill later. As a reporting requirement for a duty$-$free establishment, POS details for customers are routinely captured. This information has proven helpful for analyzing behavior, and the company also tries to capture the exact details of duty$-$paid transactions. As a rule, duty$-$free transactions will be done in US dollars, while duty$-$paid transactions will appear in BDS dollars. $$ As a new boutique employee, your manager wants you to produce some reports to review performance in preparation for an upcoming trip to purchase new merchandise. $$ All queries and reports should appear in Barbados dollars, and so do the conversions. $$ Format all money as currency to improve the display. $$ Please don't have weird values with seven $(7)$ decimal places. $$ Use the currency table provided to convert US dollars to Barbados dollars and pay attention to the currencies in the sales table. First, you need to peruse the database. It comprises the following tables: $$ CURRENCY: A list of currencies and conversion rates to the Barbados dollar. $$ SALES: The POS transactions, both duty$-$free and duty$-$paid. $$ LOCATION: Both stores that sell and head office stock storage locations. You are asked to prepare several queries, as well as some reports. Create query showing the following for Jan, Feb, Mar in $2009.$ Duty$-$free sales, duty$-$paid sales, and taxes $($original$)$ are collected monthly by location.