You have been hired to design a relational database for a convenience store which is located within an apartment complex. The goal of the database is to keep track of the inventory sold in hopes of using the data to better meet the customer's convenience store needs. Up until your arrival, the store kept track of each customer’s purchases using a flat database log, as shown in the following table. Using the information provided, build a relational database that will allow for querying things such as products sold, customer purchases, total apartment purchases, and total spent per apartment. Include any created tables and identify the keys and key types that are used. Identify all relationships, labeling them 1:1, 1:N, or M:N. Name Apt # Products Price Quantity
Joseph Anthony 1125 Orange Juice 4.59 1
Joseph Anthony 1125 Bread Loaf 2.29 1
Yolanda Burns 3221 Milk 3.67 1
Yolanda Burns 3221 Candy Bar 1.19 3
Francis Jordan 1138 Gum 0.99 2
Steve Miller 2221 Gum 0.99 1
Cho Lin 2239 Bread Loaf 2.29 1

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

< back to assignment attempts: 1 1 keep the highest: 1 / 2 2. determining opportunity cost juanita is deciding whether to buy a suit that she wants, as well as where to buy it. three stores carry the same suit, but it is more convenient for juanita to get to some stores than others. for example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $102 for the suit: store travel time each way price of a suit (minutes) (dollars per suit) local department store 15 102 across town 30 88 neighboring city 60 65 juanita makes $42 an hour at work. she has to take time off work to purchase her suit, so each hour away from work costs her $42 in lost income. assume that returning to work takes juanita the same amount of time as getting to a store and that it takes her 30 minutes to shop. as you answer the following questions, ignore the cost of gasoline and depreciation of her car when traveling. complete the following table by computing the opportunity cost of juanita's time and the total cost of shopping at each location. store opportunity cost of time price of a suit total cost (dollars) (dollars per suit) (dollars) local department store 102 across town 88 neighboring city 65 assume that juanita takes opportunity costs and the price of the suit into consideration when she shops. juanita will minimize the cost of the suit if she buys it from the . grade it now save & continue continue without saving

How did the contribution of the goods producing sector to gdp growth change between 2010 and 2011 a. it fell by 0.3%. b. it fell by 2.3%. c. it rose by 2.3%. d. it rose by 0.6%. the answer is b