Skip to contentSkip to footer
      employer cover photo
      employer logo
      employer logo

      BNY

      Engaged Employer

      BNY IT Intern interview

      BNY Interview Question

      IT Intern Interview

      What is wrong with this SQL table? Primary Key: House Attributes: HouseID HouseAddress OwnerFirstName OwnerLastName OwnerSSN HouseSize

      Interview Answers

      Anonymous

      Nov 30, 2013

      All the attributes starting with Owner could be put into another tables. List some other analytical solutions as to the risks involved with having mixed data.

      1

      Anonymous

      Sep 25, 2015

      Yes owner details should be in owners' table(firstname,lastname,ssn) Also primary key of the house table should be houseid(num)

      Related searches: BNY reviews | BNY jobs | BNY salaries | BNY benefits | BNY conversations
      BNY interviews