Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Need help in finding the candidate key.


    I need to find 2 possible candidate keys of this un-normalised relation and find a possible primary key.

    The company has a number of branches and agents employed.Each agent is paid a salary and commission. The salary and the rate of commission
    depend on the agent's type (Fresh, Experienced, Senior).Each customer is allotted to an agent who helps the customer. A customer may have
    many deposits.

    InvestmentFirm ( CustomerId, CustomerName DepositNo, Amount, DepositAmount, Interest-Rate, Period –of-Deposit, Maturity-Value, AgentId, AgentName, Years-ofservice, Salary, Category, Rate-of-commission, BranchNo, BranchAddress, BranchPhone)

    Could you help me to find out the answer.

    Thanks and regards.

  2. #2
    Join Date
    Jun 2007
    Rather than posting all your homework on the forum wouldn't it be better to just find an easier course that you're more suited to?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts