Pergunta de entrevista da empresa BNY

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

Respostas da entrevista

Sigiloso

30 de nov. de 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

Sigiloso

25 de set. de 2015

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