1. The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on.

Because the manager is not an IS expert, the following table is used to store the information. As a member can attend many dinners and a member will not attend more than 1 dinner on the same date, the primary key of the following table is Member ID and Dinner ID. Dinners can have many courses, from one-course dinner to as many courses as the chef desired.

1. Transform the table above into first normal form 1NF. (To do this, check if there are multivalued attributes and transform the table to get rid of them)
   1. Identify the dependencies and which type they are (full dependencies, partial dependencies, transitive dependencies
2. Transform the table above into second normal form 2NF. (To do this separate partial dependencies into separate tables).
3. Transform the table above into third normal form 3NF. (To do this, remove the transitive dependencies by creating separate tables and relate them with the common attribute)

Question 2
[25] Jenny is the owner of The Bride Boutique. The boutique sells well-known brands of wedding dresses and related products. Jenny recently attended a short course on financial management for SMEs. One of the topics covered in the programme was cash budgets. Jenny wants to implement cash budgeting for the boutique and she prepared a cash budget for the period April – June 2020. However, she is still concerned that she may not have prepared the cash budget correctly and requested your assistance to help her prepare the cash budget. At a meeting between Jenny and yourself, she provided you with the following information: Actual and forecasted sales and purchases for the period February – June 2020   February
(Actual) March (Actual) April (Forecast) May (Forecast) June (Forecast) Total sales R950 000 R1 050 000 R1 200 000 R1 350 000    R1 100 000 Total purchases R760 000 R892 500 R1 020 000 R945 000 R770 000
The boutique’s monthly cash sales are 60% of its total monthly sales, the balance being credit sales.  The boutique’s credit terms to customers require that the customers settle their credit purchases by paying 70% of their outstanding balances one month after the month of purchase and the remaining balances two months after the month of purchase.  The boutique pays 30% of its monthly purchases in cash and the rest of the monthly purchases are made on credit. Jenny has to pay her suppliers 40% of the credit purchases one month after the month of purchase and the outstanding balance two months after the month of purchase.  Jenny plans to replace some of the display cabinets in July 2020. A friend of hers who owns a jewellery shop will buy the cabinets from her for R15 000 in June 2020 and will pay her in cash.    The monthly wages and salaries are R12 000 and Jenny intends to grant an 8% increase in wages and salaries from May 2020.    The monthly rent for the boutique premises is R25 000 while the business insurance is R2 500 per month. The insurer advised that an insurance premium increase of 10% will take effect as from 1 June 2020.  Consumables average R1 500 per month and Jenny intends to spend R1 400, R2 500 and R1 500 on advertising in April, May, and June, respectively.  Jenny’s tax advisor informed her that the boutique will have to pay tax of R46 000 to SARS in April 2020. Required: Prepare a cash budget for The Bride Boutique for the period April – June 2020 using the format for a detailed cash budget as presented in the prescribed textbook.

7. The distribution of annual profit at the chain of Shoe Palace stores was approximately normal with a mean of $457,300 and a standard deviation of $58,000. The CEO of the company would like to reassess the efficiency of all managers of the stores with the lowest 15% of profits. What is the maximum annual profit at the stores that fit in the lowest 15%?

8. If the population of monthly internet bills for the Ida neighborhood has a mean of $82.00 and a standard deviation of $7.50, what is the probability of selecting a household at random whose monthly bill is $64.00 or less?

9. The administration is planning on giving assessments to the top 10% of seniors. If the mean of the senior class GPAs is 3.38 with a standard deviation of 0.15, what is the indicated z-score?

10. Indicate whether the following statistics can be examples of binomial probability distributions:

a.) results of spinning a 4-color spinner

b.) results of flipping a quarter

c.) results of drawing a red or black suit from a deck of cards

d.) results of hitting red light or green light at the intersection of Main and Rt. 340

Viking Trivia Company Chart of Account Titles (selected):

Assets: Prepaid Rent, Prepaid Advertising. Prepaid Insurance, Office Supplies, Inventory, Accumulated Depreciation

Liabilities: Interest Payable, Utilities Payable, Commissions Payable, Unearned Rent

Revenues: Rent Revenue, Interest Revenue

Expenses: Office Supplies Expense, Commissions Expense, Utilities Expense, Insurance Expense, Advertising Expense, Depreciation Expense, Interest Expense, Rent Expense

Review the following items and make the necessary adjusting entries using the account titles shown above as of December 31, 2019. If no entry is required, write N/A in all blanks for that item. Round all amounts to the nearest dollar.

a) On October 1, 2019, Viking Trivia Company paid $72,000 for a two-year lease on an office building. The payment was recorded as prepaid rent, and the lease commenced on the date of payment.

Debit Account  Debit Amount

Credit Account  Credit Amount

b) On December 1, 2019, Viking Trivia Company entered into a legally binding contract to purchase $40,000 of advertising. The advertising will begin on March 1, 2020 with payment due at that time.

Debit Account  Debit Amount

Credit Account  Credit Amount

c) On December 1, 2019, Viking Trivia Company rented some office space to a local telemarketer. Viking collected $5,400 rent for the period of December 1, 2019, to February 29, 2020. The cash collected was recorded as unearned rent.

Debit Account  Debit Amount

Credit Account  Credit Amount

d) During 2019, Viking Trivia Company purchased office supplies that cost $23,400. The purchase was recorded as office supplies inventory. At the beginning of 2019, the office supplies inventory was $3,600. At the end of 2019, a count showed unused office supplies amounting to $2,600.

Debit Account  Debit Amount

Credit Account  Credit Amount

e) For the week ended December 31, 2019, Viking Trivia Company sales employees earned $37,000 in commissions that will be paid in the next payroll on January 11, 2020.

Debit Account  Debit Amount

Credit Account  Credit Amount

f) On June 1, 2019, Viking Trivia Company borrowed $360,000 cash on a one-year, 6% note payable. The interest is payable on the due date, May 31, 2020.

Debit Account  Debit Amount

Credit Account  Credit Amount

g) On July 1, 2019, Viking Trivia Company paid $7,800 for six months’ property insurance coverage beginning on that date. The payment was debited to insurance expense on that date.

Debit Account  Debit Amount

Credit Account  Credit Amount

h) On October 1, 2019, Viking Trivia Company purchased office equipment that cost $44,000. The estimated life of the office equipment was five years with no residual value.

Debit Account  Debit Amount

Credit Account  Credit Amount

Policy and Economic Issues of the opioid crisis in the US. Write 3-4 paragraphs and don't use everything from the internet except data. Thanks

Explain about the open-source philosophy in Shenzhen. How does the philosophy make Shenzhen ecosystem different from Silicon Valley or business in the US?

As a marketing manager in one of the leading companies in US.

Discuss all the activities in creating value for customer's till capture the value from customers in return ?

Discuss the evolution of US nuclear deterrence strategies from Massive Retaliation through Mutual Assured Destruction. What led to the adoption of each strategy?

How is the supreme court case Int'l Refugee Assistance Project v Trump. different from the US Court of Appeals case of the same name?

Resettling in the US, how were the challenges faced by Cambodian refugees different economically and socially from the challenges faced by the first wave of Vietnamese refugees?