6. (20 points) We need to store information related to broker(B), broker's office (0), investor(1), stocks(S), how many shares for each stock(Q), and dividend(D) of each stock in the database. Assume all the above information was designed to be put into spread sheet of one relation (bad design!): Stocks(B, 0, 1, S, Q, D) Sample Data Broker Office | Investor I Stock Stock Quantity | Dividen B101 B101 B101 B102 B102 B101 B101 Hancock Hancock Hancock Houghton Houghton Hancock Hancock Alice Alice Alice Joe Joe Mike Mike CMRE T1 PIR CLX 1000 5000 3000 10,000 4000 20000 | 2000 7% 7.38% 0.91% 2.89% 7.38% 7.38% | 5.98% Ti T1 PMM We know that a. Each investor has one broker (I->B) Sample data: Alice's broker is B101 Joe's broken is B102 Mike's broker is also B101 b. Every broker has an office (B->0) Sample data: B101's office is in Hancock, B102's office is in Houghton c. Each investor(1) owns different stocks(S) with different quantity (Q) of each stock. (IS->Q) Sample data: Alice has 1000 shares of CMRE, 5000 shares of T1, 3000 shares of PIR Joe has 10,000 shares of CLX, 4000 shares of Ti. Mike has 20000 shares of T1, 2000 shares of PMM d. Dividend (D) of each stock(s) is same no matter who owns it (S->D). Sample data: PMM's dividend is 5.98% Ti' dividend is 7.38% CLX's dividend is 2.89% PIR's dividend is 0.91% CMRE's dividend is 7% Decompose the above relation Stocks(B,0,1,S, Q, D) into multiple relations of BCNF Hint: if X->Y violates the BCNF, compute X+, decompose R into two relations