Consider a relation Stocks (B, O, C,S, Q, R) whose attributes may be treated as broker,...

 

Transcribed Image Text:

Consider a relation Stocks (B, O, C,S, Q, R) whose attributes may be treated as broker, office (of the broker), a client of the investor, a particular stock investment, the number of shares owned by the client, and the rate of return so far for the stock investment. The set of FDs for this schema are SD,S → R,CB,CS →Q, and B → 0. 1. What are all the keys for Stocks? 2. Are the given FDs already their own minimal basis? Explain. Consider a relation Stocks (B, O, C,S, Q, R) whose attributes may be treated as broker, office (of the broker), a client of the investor, a particular stock investment, the number of shares owned by the client, and the rate of return so far for the stock investment. The set of FDs for this schema are SD,S → R,CB,CS →Q, and B → 0. 1. What are all the keys for Stocks? 2. Are the given FDs already their own minimal basis? Explain.

Answer rating: 100% (QA)

To determine the keys for the relation Stocks and to check if the given functional dependencies FDs ... View the full answer